public int Delete(EndUser_VM Model)
{
int result = 0;
using (var db = new WebPortalEntities())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
result = db.DeleteEndUser(Model.EndUserID,
Model.CurrentLanguageCode, Model.CurrentUTCOffset, Model.CurrentEndUserID,
Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint);
db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
logger.Error("EndUserRepository_Delete Error: ", ex);
trans.Rollback();
throw;
}
}
}
return(result);
}
public List <EndUser_VM> GetControllerUserNameData(EndUser_VM Model)
{
List <EndUser_VM> query = new List <EndUser_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] {
new SqlParameter("@p_UserName", GetDBNULL(Model.Name)),
};
ds = db.ExecuteDataSet("GetControllerEndUserName", par);
query = ConvertToList <EndUser_VM>(ds.Tables[0]);
}
}
catch (Exception ex)
{
logger.Error("EndUserRepository_GetUserNameData Error: ", ex);
throw;
}
return(query);
}
public List <EndUser_VM> GetData(EndUser_VM Model)
{
List <EndUser_VM> Data = new List <EndUser_VM>();
try
{
Data = ConnectGetDataProcedure(Model);
}
catch (Exception ex)
{
logger.Error("UserRepository_GetData", ex);
}
return(Data);
}
public JsonResult GetControllerUserData(EndUser_VM Model)
{
List <EndUser_VM> vm = new List <EndUser_VM>();
try
{
GetUserInfo(Model);
vm = _UserRepo.GetControllerUserNameData(Model);
return(Json(new JsonResponse("Success", "Success", vm), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonResponse("Error", "Error occured while processing request: " + ex.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
}
//end user code start here
private List <EndUser_VM> ConnectGetDataProcedure(EndUser_VM Model)
{
var query = new List <EndUser_VM>();
try
{
using (var db = new DBConnection())
{
var ds = new DataSet();
var par = new SqlParameter[] {
new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID)),
new SqlParameter("@p_LoginID", GetDBNULL(Model.LoginID)),
new SqlParameter("@p_FirstName", GetDBNULLString(Model.FirstName)),
new SqlParameter("@p_MiddleName", GetDBNULLString(Model.MiddleName)),
new SqlParameter("@p_LastName", GetDBNULLString(Model.LastName)),
new SqlParameter("@p_Name", GetDBNULLString(Model.Name)),
new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.LanguageCode)),
new SqlParameter("@p_UTCOffset", GetDBNULL(Model.UTCOffset)),
new SqlParameter("@p_DefaultModuleCode", GetDBNULLString(Model.DefaultModuleCode)),
new SqlParameter("@p_Gender", GetDBNULLString(Model.Gender)),
new SqlParameter("@p_EmailID", GetDBNULLString(Model.EmailID)),
new SqlParameter("@p_UserRoleName", GetDBNULLString(Model.UserRoleName)),
new SqlParameter("@p_IsChildResult", GetDBNULL(Model.IsChildResult)),
new SqlParameter("@p_IsCustomerUser", GetDBNULL(Model.IsCustomerUser)),
};
ds = db.ExecuteDataSet("GetEndUser", par);
query = ConvertToList <EndUser_VM>(ds.Tables[0]);
if (Model.IsChildResult == true)
{
query[0].EndUserModuleList = ConvertToList <EndUserModule_VM>(ds.Tables[1]);
query[0].UserRoleUserList = ConvertToList <UserRoleUser_VM>(ds.Tables[2]);
}
}
}
catch (Exception ex)
{
logger.Error("EndUserRepository_GetData Error: ", ex);
throw;
}
return(query);
}
public JsonResult GetUser(EndUser_VM Model)
{
try
{
DropDownRepository DDRepo = new DropDownRepository();
IEnumerable <SelectListItem> data = new List <SelectListItem>();
data = DDRepo.GetUser(Model);
return(Json(new JsonResponse("Success", "Success", data), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
//Log the error
logger.Error("AjaxCommonDataController_GetUser: "******"Error", "Error occured while processing request: " + ex.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
}
public int RefreshUserLeafLocation(EndUser_VM Model)
{
List <int> outPara = new List <int>();
using (var db = new WebPortalEntities())
{
try
{
var par = new SqlParameter[] { new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID)) };
var dd = db.Database.SqlQuery <List <int> >("exec InsertUserLeafLocation", par).ToList();
return(1);
}
catch (Exception ex)
{
logger.Error("CustomerDashboardRepository_RefreshUserLeafLocation Error: ", ex);
throw;
}
}
}
/// <summary>
/// Is Use for Controller Tagging in Mobile app
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public JsonResult GetUserData(EndUser_VM Model)
{
var vm = new List <EndUser_VM>();
try
{
// This condition tells if comes null/0 then bind from session varial edither comes form user browers
if (Model.CurrentEndUserID == 0)
{
GetUserInfo(Model);
}
vm = _UserRepo.GetUserNameData(Model);
return(Json(new JsonResponse("Success", "Success", vm), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new JsonResponse("Error", "Error occured while processing request: " + ex.Message.ToString(), null), JsonRequestBehavior.AllowGet));
}
}
public JsonResult Delete(EndUser_VM Model)
{
if (CheckAccessDelete(Model.CurrentScreenID, "User"))
{
try
{
GetUserInfo(Model);
if (Model.EndUserID > 0 && Model.EndUserID != null)
{
var data = _UserRepo.Delete(Model);
return(GetAddEditDeleteResponse(data, "Delete"));
}
}
catch (Exception ex)
{
logger.Error("UserController_Delete Error: ", ex);
return(GetAddEditErrorException(ex));
}
}
return(GetModelStateIsValidException(ViewData));
}
public IEnumerable <SelectListItem> GetUser(EndUser_VM Model)
{
IEnumerable <EndUser_VM> query = new UserRepository().GetData(Model);
IEnumerable <SelectListItem> list;
if (Model.EndUserID != null)
{
list = query.Select(x => new SelectListItem()
{
Text = x.LoginID + " ( " + x.EmailID + " ) ", Value = x.EndUserID.ToString(), Selected = (x.EndUserID == Model.EndUserID ? true : false)
}).ToList();
}
else
{
list = query.Select(x => new SelectListItem()
{
Text = x.LoginID + " ( " + x.EmailID + " ) ", Value = x.EndUserID.ToString()
}).ToList();
}
return(list.OrderBy(x => x.Text));
}
public JsonResult AddUpdateData(EndUser_VM Model)
{
if (ModelState.IsValid)
{
try
{
GetUserInfo(Model);
if (Model.EndUserID == 0 || Model.EndUserID == null)
{
var data = _UserRepo.Add(Model);
if (data > 0)
{
return(Json(new JsonResponse("Success", saveMessage, data), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResponse("Error", saveErrorMessage, data), JsonRequestBehavior.AllowGet));
}
}
else if (Model.EndUserID > 0)
{
var data = _UserRepo.Update(Model);
if (data > 0)
{
return(Json(new JsonResponse("Success", updateMessage, data), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new JsonResponse("Error", updateErrorMessage, data), JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
logger.Error("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));
}
public int Update(EndUser_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var dt_EndUserModule = new DataTable();
if (Model.EndUserModule_TableTypeList != null && Model.EndUserModule_TableTypeList.Count > 0)
{
dt_EndUserModule = ConvertToDatatable(Model.EndUserModule_TableTypeList);
}
else
{
dt_EndUserModule = ConvertToDatatable(new List <EndUserModule_TableType_VM>());
}
var dt_UserRoleUser = new DataTable();
if (Model.UserRoleUser_TableTypeList != null && Model.UserRoleUser_TableTypeList.Count > 0)
{
dt_UserRoleUser = ConvertToDatatable(Model.UserRoleUser_TableTypeList);
}
else
{
dt_UserRoleUser = ConvertToDatatable(new List <UserRoleUser_TableType_VM>());
}
var par = new SqlParameter[] {
new SqlParameter("@p_EndUserID", GetDBNULL(Model.EndUserID)),
new SqlParameter("@p_LoginID", GetDBNULLString(Model.LoginID)),
new SqlParameter("@p_FirstName", GetDBNULLString(Model.FirstName)),
new SqlParameter("@p_MiddleName", GetDBNULLString(Model.MiddleName)),
new SqlParameter("@p_LastName", GetDBNULLString(Model.LastName)),
new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.LanguageCode)),
new SqlParameter("@p_UTCOffset", GetDBNULL(Model.UTCOffset)),
new SqlParameter("@p_DefaultModuleCode", GetDBNULL(Model.DefaultModuleCode)),
new SqlParameter("@p_Gender", GetDBNULL(Model.Gender)),
new SqlParameter("@p_EmailID", GetDBNULL(Model.EmailID)),
new SqlParameter("@p_UserIdentity", GetDBNULLString(Model.UserIdentity)),
new SqlParameter("@p_ActivatedDTM", GetDBNULL(Model.ActivatedDTM)),
new SqlParameter("@p_LastAccessPoint", GetDBNULLString(Model.LastAccessPoint)),
new SqlParameter("@p_LastLoginDTM", GetDBNULL(Model.LastLoginDTM)),
new SqlParameter("@p_SecretQuestion", GetDBNULLString(Model.SecretQuestion)),
new SqlParameter("@p_SecretAnswer", GetDBNULLString(Model.SecretAnswer)),
new SqlParameter("@p_ActivationURLID", GetDBNULL(Model.ActivationURLID)),
new SqlParameter("@p_ResetPasswordURLID", GetDBNULL(Model.ResetPasswordURLID)),
new SqlParameter("@p_DesignationID", GetDBNULL(Model.DesignationID)),
new SqlParameter("@p_DepartmentID", GetDBNULL(Model.DepartmentID)),
new SqlParameter("@p_EndUserModule", dt_EndUserModule)
{
TypeName = "EndUserModule_TableType"
},
new SqlParameter("@p_UserRoleUser", dt_UserRoleUser)
{
TypeName = "UserRoleUser_TableType"
},
new SqlParameter("@p_CurrentLanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
new SqlParameter("@p_CurrentUTCOffset", GetDBNULL(Model.CurrentUTCOffset)),
new SqlParameter("@p_CurrentEndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_CurrentUserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_CurrentScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_CurrentAccessPoint", GetDBNULLString(Model.AccessPoint)),
};
result = db.ExecuteNonQueryRollBack("UpdateEndUser", par);
}
}
catch (Exception ex)
{
logger.Error("EndUserRepository_Update Error: ", ex);
throw;
}
return(result);
}
