Emdadul Haque

Emdadul Haque

  • NA
  • 26
  • 858

Logic related task in MVC using Ajax

Mar 16 2020 6:52 AM
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
 

Answers (1)