public string UpdateUserPages(UserPagesVM userPage) { string userPageId = string.Empty; SqlParameter[] parameters = { new SqlParameter { ParameterName = "@Id", Value = userPage.Id }, new SqlParameter { ParameterName = "@UserId", Value = userPage.UserId }, new SqlParameter { ParameterName = "@PageId", Value = userPage.PageId }, new SqlParameter { ParameterName = "@IsAdd", Value = userPage.IsAdd }, new SqlParameter { ParameterName = "@IsEdit", Value = userPage.IsEdit }, new SqlParameter { ParameterName = "@IsDelete", Value = userPage.IsDelete }, new SqlParameter { ParameterName = "@IsView", Value = userPage.IsView }, new SqlParameter { ParameterName = "@Description", Value = userPage.Description }, new SqlParameter { ParameterName = "@IsActive", Value = userPage.IsActive }, new SqlParameter { ParameterName = "@UpdatedBy", Value = userPage.UpdatedBy } }; userPageId = Convert.ToString(DALHelper.ExecuteScalar("UpdateUserPages", parameters)); return(userPageId); }
public ActionResult Register(UserVM model) { try { #region Get Student Role Id var userRoles = userRoleRepository.GetUserRoles(); var studentRoleId = userRoles.Where(m => m.Code == "STUDENT").FirstOrDefault().Id; #endregion //Check Email Exist. #region Check User Email Exist if (this.CheckUserEmailExist(model.Id, studentRoleId, model.Email) == true) { return(Json(new { IsSuccess = false, errorMessage = string.Format("Email : {0} already registered.", model.Email) }, JsonRequestBehavior.AllowGet)); } #endregion #region Max. User Id //Get Max. User Id. var newUserId = (userRepository.GetMaxUserId()) + 1; model.UserId = newUserId; #endregion #region Generate Cashier Number var firstTwoCharactersOfName = !string.IsNullOrWhiteSpace(model.Name) ? model.Name.Substring(0, 2) : ""; model.CashierNumber = (firstTwoCharactersOfName + newUserId).ToUpper(); #endregion Generate Cashier Number #region Generate New Password //Generate new password. string newPassword = Utility.Utility.GenerateRandomPassword(8); model.Password = Utility.Utility.Encrypt(newPassword, Utility.Utility.EncryptionKey); #endregion #region Get Admin User Id int createdBy = 0; var adminRoleId = userRoles.Where(m => m.Code == "ADMIN").FirstOrDefault().Id; var adminUser = userRepository.GetUserDetailByRoleId(adminRoleId).FirstOrDefault(); if (adminUser != null) { createdBy = adminUser.UserId; } #endregion string userId = string.Empty; model.CreatedBy = createdBy; model.IsActive = false; model.IsRecordActivity = true; model.IsFromRegistrationPage = true; userId = userRepository.AddUserDetail(model); if (!string.IsNullOrWhiteSpace(userId)) { #region Add User Role Mapping UserRoleMappingVM userRoleMapping = new UserRoleMappingVM(); userRoleMapping.UserId = Guid.Parse(userId); userRoleMapping.UserRoleId = studentRoleId; userRoleMapping.IsActive = true; userRoleMapping.CreatedBy = createdBy; userRoleMapping.UpdatedBy = createdBy; userRepository.AddUpdateUserRoleMapping(userRoleMapping); #endregion #region Add User Page Access Rights For Profile Page var profilePage = pageRepository.GetPageDetailByPageCode("INDIVIDUALPROFILE").FirstOrDefault(); if (profilePage != null) { UserPagesVM userPage = new UserPagesVM(); userPage.UserId = Guid.Parse(userId); userPage.PageId = profilePage.Id; if (model.IsAllowToDeleteProfile) { userPage.IsDelete = true; } else { userPage.IsDelete = false; } userPage.IsAdd = true; userPage.IsEdit = true; userPage.IsView = true; userPage.IsActive = true; userPage.CreatedBy = createdBy; userPageRepository.AddUserPages(userPage); } #endregion #region Add Tutor Student Mapping TutorStudentMappingVM tutorStudentMapping = new TutorStudentMappingVM(); tutorStudentMapping.TutorId = model.TutorId.Value; tutorStudentMapping.StudentId = Guid.Parse(userId); tutorStudentMapping.UserId = newUserId; tutorStudentMapping.CreatedBy = createdBy; tutorStudentMapping.UpdatedBy = createdBy; tutorStudentMapping.IsActive = true; userRepository.AddUpdateTutorStudentMapping(tutorStudentMapping); #endregion return(Json(new { IsSuccess = true, data = new { UserId = userId } }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { IsSuccess = false, errorMessage = "You have not registered successfully. Something went wrong!" }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Utility.Utility.LogError(e, "Register POST"); return(Json(new { IsSuccess = false, errorMessage = e.Message })); } }
public ActionResult Create(UserVM model) { try { string userId = string.Empty; model.CreatedBy = LogInManager.LoggedInUserId; model.Password = Utility.Utility.Encrypt(model.Password, Utility.Utility.EncryptionKey); #region Get Student Role Id var userRoles = userRoleRepository.GetUserRoles(); var studentRoleId = userRoles.Where(m => m.Code == "STUDENT").FirstOrDefault().Id; model.UserRoleId = studentRoleId; #endregion #region Check User Email Exist. if (this.CheckUserEmailExist(model.Id, model.UserRoleId, model.Email) == false) { return(Json(new { IsSuccess = false, errorMessage = string.Format("Email : {0} already exist.", model.Email) }, JsonRequestBehavior.AllowGet)); } #endregion #region Get Max. User Id //Get Max. User Id. var newUserId = (userRepository.GetMaxUserId()) + 1; model.UserId = newUserId; #endregion #region Generate Cashier Number var firstTwoCharactersOfName = !string.IsNullOrWhiteSpace(model.Name) ? model.Name.Substring(0, 2) : ""; model.CashierNumber = (firstTwoCharactersOfName + newUserId).ToUpper(); #endregion Generate Cashier Number model.IsFromRegistrationPage = false; userId = userRepository.AddUserDetail(model); if (!string.IsNullOrWhiteSpace(userId)) { #region Add User Role Mapping UserRoleMappingVM userRoleMapping = new UserRoleMappingVM(); userRoleMapping.UserId = Guid.Parse(userId); userRoleMapping.UserRoleId = model.UserRoleId; userRoleMapping.IsActive = true; userRoleMapping.CreatedBy = LogInManager.LoggedInUserId; userRoleMapping.UpdatedBy = LogInManager.LoggedInUserId; userRepository.AddUpdateUserRoleMapping(userRoleMapping); #endregion #region Add User Page Access Rights For Profile var profilePage = pageRepository.GetPageDetailByPageCode("INDIVIDUALPROFILE").FirstOrDefault(); if (profilePage != null) { UserPagesVM userPage = new UserPagesVM(); userPage.UserId = Guid.Parse(userId); userPage.PageId = profilePage.Id; if (model.IsAllowToDeleteProfile) { userPage.IsDelete = true; } else { userPage.IsDelete = false; } userPage.IsAdd = true; userPage.IsEdit = true; userPage.IsView = true; userPage.IsActive = true; userPage.CreatedBy = LogInManager.LoggedInUserId; userPageRepository.AddUserPages(userPage); } #endregion #region Add Tutor Student Mapping TutorStudentMappingVM tutorStudentMapping = new TutorStudentMappingVM(); tutorStudentMapping.TutorId = model.TutorId.Value; tutorStudentMapping.StudentId = Guid.Parse(userId); tutorStudentMapping.UserId = newUserId; tutorStudentMapping.CreatedBy = LogInManager.LoggedInUserId; tutorStudentMapping.UpdatedBy = LogInManager.LoggedInUserId; tutorStudentMapping.IsActive = true; userRepository.AddUpdateTutorStudentMapping(tutorStudentMapping); #endregion return(Json(new { IsSuccess = true, data = new { UserId = userId } }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { IsSuccess = false, errorMessage = "Student details not saved successfully." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Utility.Utility.LogError(e, "Create"); return(Json(new { IsSuccess = false, errorMessage = e.Message })); } }
public ActionResult Edit(UserVM model) { try { string userId = string.Empty; model.UpdatedBy = LogInManager.LoggedInUserId; #region Get Student Role Id var userRoles = userRoleRepository.GetUserRoles(); var studentRoleId = userRoles.Where(m => m.Code == "STUDENT").FirstOrDefault().Id; model.UserRoleId = studentRoleId; #endregion #region Check User Email Exist. if (this.CheckUserEmailExist(model.Id, model.UserRoleId, model.Email) == false) { return(Json(new { IsSuccess = false, errorMessage = string.Format("Email : {0} already exist.", model.Email) }, JsonRequestBehavior.AllowGet)); } #endregion #region Check Cashier Number Exist. if (!string.IsNullOrWhiteSpace(model.CashierNumber)) { if (this.CheckCashierNumberExist(model.Id, model.CashierNumber) == false) { return(Json(new { IsSuccess = false, errorMessage = string.Format("Cashier Number : {0} already exist.", model.Email) }, JsonRequestBehavior.AllowGet)); } } #endregion userId = userRepository.UpdateUserDetail(model); if (!string.IsNullOrWhiteSpace(userId)) { #region Add / Update User Role Mapping UserRoleMappingVM userRoleMapping = new UserRoleMappingVM(); userRoleMapping.UserId = Guid.Parse(userId); userRoleMapping.UserRoleId = model.UserRoleId; userRoleMapping.IsActive = true; userRoleMapping.CreatedBy = LogInManager.LoggedInUserId; userRoleMapping.UpdatedBy = LogInManager.LoggedInUserId; userRepository.AddUpdateUserRoleMapping(userRoleMapping); #endregion #region Add/Update User Page Access Rights For Profile var profilePage = pageRepository.GetPageDetailByPageCode("INDIVIDUALPROFILE").FirstOrDefault(); var profilePageAccessRights = userPageRepository.GetUserPageAccessRights(Guid.Parse(userId), "INDIVIDUALPROFILE").FirstOrDefault(); if (profilePage != null) { UserPagesVM userPage = new UserPagesVM(); userPage.UserId = Guid.Parse(userId); userPage.PageId = profilePage.Id; if (model.IsAllowToDeleteProfile) { userPage.IsDelete = true; } else { userPage.IsDelete = false; } userPage.IsAdd = true; userPage.IsEdit = true; userPage.IsView = true; userPage.IsActive = true; userPage.CreatedBy = LogInManager.LoggedInUserId; userPage.UpdatedBy = LogInManager.LoggedInUserId; if (profilePageAccessRights == null) { userPageRepository.AddUserPages(userPage); } else { userPage.Id = profilePageAccessRights.Id; userPageRepository.AddUserPages(userPage); } } #endregion #region Add/Update Tutor Student Mapping TutorStudentMappingVM tutorStudentMapping = new TutorStudentMappingVM(); tutorStudentMapping.TutorId = model.TutorId.Value; tutorStudentMapping.StudentId = Guid.Parse(userId); tutorStudentMapping.UserId = model.UserId; tutorStudentMapping.CreatedBy = LogInManager.LoggedInUserId; tutorStudentMapping.UpdatedBy = LogInManager.LoggedInUserId; tutorStudentMapping.IsActive = true; userRepository.AddUpdateTutorStudentMapping(tutorStudentMapping); #endregion return(Json(new { IsSuccess = true, data = new { UserId = userId } }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { IsSuccess = false, errorMessage = "Student details not updated successfully." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Utility.Utility.LogError(e, "Edit"); return(Json(new { IsSuccess = false, errorMessage = e.Message })); } }