(Data Layer)⚙️
(Business Layer)⚙️
(Presentation Layer)⚙️
Async Programming ⚙️
Dependency Injection ⚙️
using AJAX ⚙️
using SignalR ⚙️
using Microsoft Identity ⚙️
real time chat and group chat ⚙️
Tables📋
User
| Id | firstName | lastName | DateOfBirth | profilePhoto | EmailConfirmed | PasswordHash | SecurityStamp | PhoneNumber | PhoneNumberConfirmed | TwoFactorEnabled | LockoutEndDateUtc | LockoutEnabled | AccessFailedCount | UserName | profileDescription |
| PostId | UserId | Username | UserProfilePhoto | PostPicture | Description | LikeCount | PostDateTime |
| Id | Name |
| UserId | RoleId |
| Id | PostId | UserId |
| Id | UserId1 | UserId2 | CheckFriend |
| Id | SenderMessageUser | RecipientMessageUser | MessageText | MessageDateTime |
| GroupId | GroupName | GroupDateTime | CreateGroupUserId |
| MessageId | GroupId | SenderUserId | Message | MessageDateTime |
| MemberId | GroupId | UserId | Role |
| MessageId | GroupId | SenderUserId | Message | MessageDateTime |
| Id | PostId | UserName | UserId | CommentDescription | CommentDateTime |
| Id | CommentId | UserName | UserId | AnswerDescription | AnswerDateTime |
