private List <UserRole_VM> ConnectGetDataProcedure(UserRole_VM VM)
{
List <UserRole_VM> query = new List <UserRole_VM>();
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetUserRole_Result, UserRole_VM>());
var mapper = config.CreateMapper();
List <GetUserRole_Result> data = db.GetUserRole(VM.UserRoleID, VM.UserRoleName).ToList();
return(mapper.Map <List <GetUserRole_Result>, List <UserRole_VM> >(data, query));
}
}
public bool Update(UserRole_VM Model)
{
try
{
using (var db = new WebPortalEntities())
{
int returnResult = db.UpdateUserRole(Model.UserRoleID, Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint);
db.SaveChanges();
return(returnResult > 0);
}
}
catch (Exception ex)
{
logger.Error("Error: ", ex);
throw;
}
}
public bool Add(UserRole_VM Model)
{
try
{
using (var db = new WebPortalEntities())
{
var returnResult = new ObjectParameter("p_UserRoleID", 0);
db.AddUserRole(Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint, returnResult);
db.SaveChanges();
return(Convert.ToInt32(returnResult.Value) > 0);
}
}
catch (Exception ex)
{
logger.Error("UserRoleRepository_Add: ", ex);
throw;
}
}
public JsonResult AddUpdateData(UserRole_VM Model)
{
if (Model != null)
{
if (ModelState.IsValid)
{
try
{
GetUserInfo(Model);
if (Model.UserRoleID == null || Model.UserRoleID == 0)
{
var data = _RoleRepo.Add(Model);
if (data)
{
return(Json(new JsonResponse("Success", saveMessage, data), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResponse("Error", saveErrorMessage, data), JsonRequestBehavior.AllowGet));
}
}
else if (Model.UserRoleID > 0)
{
var data = _RoleRepo.Update(Model);
if (data)
{
return(Json(new JsonResponse("Success", updateMessage, data), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResponse("Error", updateErrorMessage, data), JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
//Log the error
logger.Error("UserRoleController_AddUpdateData Error: ", ex);
if (ex.InnerException != null)
{
return(Json(new JsonResponse("Error", ex.InnerException.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResponse("Error", ex.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
}
}
else
{
string ErrorMessage = string.Empty;
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
ErrorMessage += error.ErrorMessage + "<br/>";
}
}
return(Json(new JsonResponse("Error", ErrorMessage, null), JsonRequestBehavior.AllowGet));
}
}
return(Json(new JsonResponse("Error", "Data can not be null.", null), JsonRequestBehavior.AllowGet));
}
