public tbl_UserRole AddRole(tbl_UserRole role) { role.CreatedUtc = Clock.UtcDateTime; _context.Set<tbl_UserRole>().Add(role); return role; }
public ActionResult userRoleDelete(int id = 0) { tbl_UserRole bc1 = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == id); db.tbl_UserRole.Remove(bc1); db.SaveChanges(); return(RedirectToAction("userRoleList")); }
public static Role Map(tbl_UserRole role) { Role ret = new User.Role(); ret.Deleted = role.Deleted; ret.ID = role.ID; ret.Name = role.Name; return(ret); }
public tbl_UserRole Map() { tbl_UserRole ret = new tbl_UserRole(); ret.ID = this.ID; ret.Name = this.Name; ret.Deleted = this.Deleted; return(ret); }
public ActionResult addUserRole(tbl_UserRole userRole) { if (ModelState.IsValid) { db.tbl_UserRole.Add(userRole); db.SaveChanges(); return(RedirectToAction("userRoleList")); } return(View(userRole)); }
internal int UpdateRole(tbl_UserRole userRoleObj, int roleId) { int rId = Convert.ToInt32(roleId); tbl_UserRole roleObj = _context.tbl_UserRole.First(x => x.RoleID == rId); roleObj.RoleName = userRoleObj.RoleName; roleObj.EditDate = userRoleObj.EditDate; roleObj.EditUser = userRoleObj.EditUser; _context.SaveChanges(); return(1); }
public ActionResult userRoleUpdate(int id = 0) { userRolId = id; tbl_UserRole bc = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == userRolId); if (bc == null) { return(HttpNotFound()); } ViewBag.GetUserRoleName = bc.UserRoleName; return(View(bc)); }
public ActionResult userRoleUpdate(tbl_UserRole bc, int id = 0) { tbl_UserRole bc1 = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == userRolId); bc1.UserRoleName = bc.UserRoleName; if (bc1 == null) { return(HttpNotFound()); } db.SaveChanges(); ViewBag.Message = "Update Succesfully"; return(View(bc1)); }
internal int SaveRole(tbl_UserRole userRoleObj) { try { _context.tbl_UserRole.AddObject(userRoleObj); _context.SaveChanges(); return(1); } catch (Exception) { throw; } }
public ActionResult Signup(UserViewModel uvm) { tbl_User tb = new tbl_User(); tb.username = uvm.username; tb.password = uvm.password; tb.email = uvm.email; tb.fullname = uvm.fullname; _db.tbl_User.Add(tb); _db.SaveChanges(); tbl_UserRole utb = new tbl_UserRole(); int userID = tb.userID; int roleID = 2; utb.userID = userID; utb.roleID = roleID; _db.tbl_UserRole.Add(utb); _db.SaveChanges(); return(RedirectToAction("Login")); }
public ActionResult Signup(UserViewModel uv) { tbl_User tbl = _db.tbl_User.Where(u => u.username == uv.username).FirstOrDefault(); if (tbl != null) { return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet)); } else { tbl_User tb = new tbl_User(); tb.username = uv.username; tb.password = uv.password; _db.tbl_User.Add(tb); _db.SaveChanges(); tbl_UserRole ud = new tbl_UserRole(); ud.userID = tb.userID; ud.userroleID = 2; _db.tbl_UserRole.Add(ud); _db.SaveChanges(); return(Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet)); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { tbl_UserRole userRoleObj = new tbl_UserRole(); userRoleObj.RoleName = txtbxRoleName.Text; userRoleObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId; userRoleObj.EditDate = DateTime.Now; if (BtnSave.Text == "Save Role") { int result = roleDal.SaveRole(userRoleObj); if (result == 1) { // lblStatus.Text = "Data Save Successfully"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true); } } else { int roleId = Convert.ToInt32(hidRoleId.Value); int result = roleDal.UpdateRole(userRoleObj, roleId); if (result == 1) { // lblStatus.Text = "Data Update Successfully"; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true); } } getRoles(); txtbxRoleName.Text = ""; BtnSave.Text = "Save Role"; } catch (Exception) { throw; } }
public tbl_UserRole RemoveRole(tbl_UserRole role) { _context.Set<tbl_UserRole>().Remove(role); return role; }
public ActionResult EditUser(string id, tbl_User tbl_User, string selectedItems) { using (var _context = new Entities()) { using (var transaction = _context.Database.BeginTransaction()) { try { if (!ModelState.IsValid) { UserRoleViewModel vm = new UserRoleViewModel() { RolesModel_list = _context.tbl_Role.Select(x => new RolesModel { RoleId = x.RoleId, Name = x.Name, }).ToList(), _tbl_Unit = _context.tbl_Unit.ToList(), }; return(PartialView("_CreateUser", vm)); } List <UserRoleModel> items = (new JavaScriptSerializer()).Deserialize <List <UserRoleModel> >(selectedItems); if (tbl_User.Pno != null) { string password = string.Empty; using (var newCOntext = new Entities()) { var previousUser = newCOntext.tbl_User.FirstOrDefault(x => x.UserId == tbl_User.Pno); password = previousUser.Password; } string pwd = password; tbl_User.UserId = tbl_User.Pno; tbl_User.Password = pwd; _context.Entry(tbl_User).State = EntityState.Modified; _context.SaveChanges(); _context.tbl_UserRole.RemoveRange(_context.tbl_UserRole.Where(x => x.UserId == id)); _context.SaveChanges(); if (items[0].RoleId != "") { foreach (var data in items) { if (data != null) { var obj = new tbl_UserRole() { UserId = tbl_User.UserId, RoleId = data.RoleId, IsDefault = data.IsDefault }; _context.tbl_UserRole.Add(obj); } } _context.SaveChanges(); } #region User Injection var UserName = tbl_User.UserId; ApplicationUser result = UserManager.FindById(UserName); // Was a password sent across? if (result != null && !string.IsNullOrEmpty(tbl_User.Password)) { // Remove current password var removePassword = UserManager.RemovePassword(result.Id); if (removePassword.Succeeded) { // Add new password var AddPassword = UserManager.AddPassword( result.Id, tbl_User.Password ); if (AddPassword.Succeeded) { transaction.Commit(); } else { transaction.Rollback(); throw new Exception(AddPassword.Errors.FirstOrDefault()); } } else { transaction.Rollback(); throw new Exception("Some error occured."); } } else { transaction.Commit(); } #endregion } return(RedirectToAction("UserIndex")); } catch (Exception ex) { transaction.Rollback(); return(RedirectToAction("UserIndex")); } } } }
public ActionResult CreateUser(tbl_User tbl_User, tbl_Role tbl_Role) { using (var _context = new Entities()) { using (var transaction = _context.Database.BeginTransaction()) { try { string password = string.Empty; if (tbl_User.Pno != null) { password = "******" + tbl_User.Pno.Trim(); } if (!ModelState.IsValid) { UserRoleViewModel vm = new UserRoleViewModel() { _tbl_Role = _context.tbl_Role.ToList(), _tbl_Unit = _context.tbl_Unit.ToList(), }; return(PartialView("_CreateUser", vm)); } if (tbl_User.Pno != null) { tbl_User.UserId = tbl_User.Pno; tbl_User.Password = password; _context.tbl_User.Add(tbl_User); _context.SaveChanges(); if (tbl_Role.RoleId != null) { var obj = new tbl_UserRole() { UserId = tbl_User.UserId, RoleId = tbl_Role.RoleId, IsDefault = 1, IsActive = 1, }; _context.tbl_UserRole.Add(obj); _context.SaveChanges(); } } #region User Injection var UserName = tbl_User.UserId; var Password = password; var objNewAdminUser = new ApplicationUser { Id = tbl_User.UserId, UserName = tbl_User.UserId, Email = tbl_User.UserId }; var AdminUserCreateResult = UserManager.Create(objNewAdminUser, Password); if (AdminUserCreateResult.Succeeded) { transaction.Commit(); } else { transaction.Rollback(); } #endregion return(RedirectToAction("UserIndex")); } catch (Exception ex) { transaction.Rollback(); // Exception(ex); // Alert("Their is something went wrong!!!", NotificationType.error); return(RedirectToAction("UserIndex")); } } } }