public bool UpdateUserLoginDepartment(int userLoginDepartmentId, int loginId, int departmentId, out string error)
{
try
{
error = string.Empty;
UserLoginDepartment updateULD = GetUserLoginDepartment(userLoginDepartmentId);
if (updateULD != null)
{
updateULD.DepartmentId = departmentId;
updateULD.UserLoginId = loginId;
_ctx.SaveChanges();
return(true);
}
else
{
error = "No UserLoginDepartment in database";
return(false);
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public bool InsertUserLoginDepartmentByUserLoginId(int userLoginId, List <int> departmentIds, out string error)
{
try
{
error = string.Empty;
if (departmentIds != null && departmentIds.Count > 0)
{
List <UserLoginDepartment> newULDs = new List <UserLoginDepartment>();
foreach (int departmentId in departmentIds)
{
UserLoginDepartment newULD = new UserLoginDepartment();
newULD.DepartmentId = departmentId;
newULD.UserLoginId = userLoginId;
newULDs.Add(newULD);
}
_ctx.UserLoginDepartments.AddRange(newULDs);
_ctx.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public DepartmentDDLModel(UserLoginDepartment userLoginDepartment)
{
if (userLoginDepartment != null && userLoginDepartment.Department != null)
{
DepartmentId = userLoginDepartment.DepartmentId;
DepartmentName = userLoginDepartment.Department.Name;
}
}
public bool DeleteUserLoginDepartment(int userLoginDepartmentId, out string error)
{
try
{
error = string.Empty;
UserLoginDepartment removeULD = GetUserLoginDepartment(userLoginDepartmentId);
_ctx.UserLoginDepartments.Remove(removeULD);
_ctx.SaveChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public bool InsertUserLoginDepartment(int loginId, int departmentId, out string error)
{
try
{
error = string.Empty;
UserLoginDepartment newULD = new UserLoginDepartment();
newULD.DepartmentId = departmentId;
newULD.UserLoginId = loginId;
_ctx.UserLoginDepartments.Add(newULD);
_ctx.SaveChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
