static void Main(string[] args)
{
var context = new employeesContext();
// Select
{
foreach (var department in context.Departments)
{
Console.WriteLine(department.DeptName);
}
}
// Update
{
var department = context.Departments.FirstOrDefault(d => d.DeptNo == "d002");
department.DeptName = "Money"; // Finances => Money
context.SaveChanges();
}
// Delete
{
var department = context.Departments.FirstOrDefault(d => d.DeptNo == "d002");
context.Departments.Remove(department);
context.SaveChanges();
}
}
public IActionResult AddPermission(int userId, int permissionId)
{
var userPermission = new UserPermission()
{
UserId = userId,
PermissionId = permissionId,
};
_context.UserPermission.Add(userPermission);
_context.SaveChanges();
return(RedirectToAction("Permissions", new { id = userId }));
}