//Get DepartmentAccess
public EditDepartmentAccess GetDepartmentAccess(int id)
{
DepartmentAccess departmentAccess = ctx.DepartmentAccess.Single(e => e.CompanyID == _companyID && e.DepartmentAccessID == id);
EditDepartmentAccess readDepartmentAccess = new EditDepartmentAccess
{
DepartmentAccessID = departmentAccess.DepartmentAccessID,
DepartmentID = departmentAccess.DepartmentID,
DepartmentName = ctx.Departments.Single(e => e.DepartmentID == departmentAccess.DepartmentID).DepartmentName,
Username = ctx.Users.Single(e => e.Id == departmentAccess.UserID).UserName,
//UserID = departmentAccess.UserID,
PermissionID = departmentAccess.PermissionID,
Access = ctx.Permissions.Single(e => e.PermissionID == departmentAccess.PermissionID).Access,
};
CreateHistory history = new CreateHistory
{
CompanyID = _companyID,
UserID = _userID.ToString(),
Table = "DepartmentAccess",
stringID = id.ToString(),
Request = $"GetDepartmentAccess({id})"
};
AddHistory(history);
return(readDepartmentAccess);
}
//Edit DepartmentAccess
public bool EditDepartmentAccess(EditDepartmentAccess model)
{
DepartmentAccess departmentAccess = ctx.DepartmentAccess.Find(model.DepartmentAccessID);
if (departmentAccess == null)
{
return(false);
}
if (departmentAccess.CompanyID != _companyID) //Check that user is in the same company as the requesting user.
{
return(false);
}
string uID = ctx.Users.Single(e => e.UserNumber == model.UserID).Id;
departmentAccess.DepartmentID = model.DepartmentID;
departmentAccess.UserID = uID;
departmentAccess.PermissionID = model.PermissionID;
departmentAccess.ModifiedDateUTC = DateTimeOffset.UtcNow;
CreateHistory history = new CreateHistory
{
CompanyID = _companyID,
UserID = _userID.ToString(),
Table = "DepartmentAccess",
stringID = model.DepartmentAccessID.ToString(),
Request = Newtonsoft.Json.JsonConvert.SerializeObject(model)
};
return(AddHistory(history));
}
public void CheckDepartmentExist()
{
var obj = new DepartmentAccess();
var Res = obj.CheckDeptExist(10);
Assert.That(Res, Is.True);
}
public void CheckDepartmentExist()
{
// arrange
var obj = new DepartmentAccess();
// act
var Res = obj.CheckDeptExist(10);
// assert
Assert.That(Res, Is.True);
}
//Delete DepartmentAccess
public bool DeleteDepartmentAccess(int id)
{
DepartmentAccess departmentAccess = ctx.DepartmentAccess.Find(id);
if (departmentAccess == null)
{
return(false);
}
if (departmentAccess.CompanyID != _companyID) //Check that user is in the same company as the requesting user.
{
return(false);
}
ctx.DepartmentAccess.Remove(departmentAccess);
CreateHistory history = new CreateHistory
{
CompanyID = _companyID,
UserID = _userID.ToString(),
Table = "DepartmentAccess",
stringID = id.ToString(),
Request = $"DeleteDepartmentAccess({id})"
};
return(AddHistory(history));
}
public DepartmentController()
{
objds = new DepartmentAccess();
}