I have had a task. When user Post any news to any person in database as a request and the user can select who able to get the request. when person accept this request, that post is inserted in the database. How can i complete this task using MVC? Please Someone help me. My Database design is given below...
Create Table UserPost
(
PostId int Primary Key Identity,
EmpId int Foreign Key References Employee(EmpId),
Post Nvarchar(300)
)
GO
Create Table Employee
(
EmpId int Primary Key Identity,
Name Nvarchar(50),
Email Nvarchar(50),
[Address] Nvarchar(150),
Phone Nvarchar(20),
Dob Date
)
GO
Create Table ReviewRequestPost
(
Id int Primary Key Identity,
PostId int Foreign Key References UserPost(PostId),
EmpId int Foreign Key References Employee(EmpId),
ReviewId int Foreign Key References Employee(EmpId),
IsReviewed bit
)
GO
Laxmidhar SahooPosted Mar 17, 2020, 12:23 AM