Help with entering information base on another table

Schleid Alex

6y747

I have in my database 3 tables Supervisor, which contain personal information about the supervisor like ID, Name, Dob I have another table like Department DepartmentID, SuperviserID, and so forth and a 3rd table that contains status information SupervisorID, DepartmentID, Date, Status

Whenever a supervisor is blocked the info is entered in the status table vice versa now I want to able to block(adding info) all department related to this particular supervisor when he is blocked. Does anyone have an idea?

Best regards

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh6y ago
while adding Info check the Supervisor Status if he is blocked then show him a message that you are not allowed for this operation.
public ActionResult AddInfo(string SupervisorName)
{
var superviserInfo= Context.Supervisors.Where(x=>x.name==SupervisorName).singleorDefault();

if(superviserInfo.Status=="Blocked")
{
  Viewbag.Message="Not allowed currently";
return View();
}
return View();
}
+1
Abhishek Chadha6y ago
what i understand from your question is you want to block all the department when supervisor is blocked for that you can use the status column of boolean type if blocked column true then you block in department table also when supervisor is blocked
0