//[TypeFilter(typeof(ActionFilters.RolesValidate), Arguments = new object[] { "User_Role", EnumPermission.Edit })]
public async Task <IActionResult> Edit(User_RoleView user_Role)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = ModelException.Errors(ModelState);
return(BadRequest(objHelper));
}
try
{
if (user_RoleRepository.Exists(user_Role))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await user_RoleRepository.Update(user_Role);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
objHelper.Data = user_Role;
return(Ok(objHelper));
}
catch (Exception ex)
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = ex.Message;
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public bool Exists(User_RoleView entity)
{
int intCount = 0;
if (entity.Id > 0)
{
intCount = adbContext.user_role.Where(w => w.Id != entity.Id && (w.User_Id == entity.User_Id && w.Role_Id == entity.Role_Id)).Count();
}
else
{
intCount = adbContext.user_role.Where(w => w.User_Id == entity.User_Id && w.Role_Id == entity.Role_Id).Count();
}
return(intCount > 0 ? true : false);
}
public async Task Insert(User_RoleView entity)
{
try
{
//Insert New Zone
var vList = new User_Role
{
User_Id = entity.User_Id,
Role_Id = entity.Role_Id,
isActive = entity.isActive,
AddedBy = entity.AddedBy,
AddedOn = DateTime.Now
};
adbContext.user_role.Add(vList);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task Update(User_RoleView entity)
{
try
{
var vList = adbContext.user_role.Where(x => x.Id == entity.Id).FirstOrDefault();
if (vList != null)
{
vList.User_Id = entity.User_Id;
vList.Role_Id = entity.Role_Id;
vList.isActive = entity.isActive;
adbContext.user_role.Update(vList);
await Task.FromResult(adbContext.SaveChanges());
}
else
{
throw new Exception("Data Not Available");
}
}
catch (Exception ex)
{
throw ex;
}
}
