private void btnDelete_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (dataGridViewRoles.SelectedRows.Count != 0) { try { spRole role = (spRole)bindingSourceRoles.Current; var _userolesquery = from us in db.spUsers where us.RoleId == role.Id select us; List <spUser> _Users = _userolesquery.ToList(); var _AllowedRoleMenusquery = from us in db.spAllowedRoleMenus where us.RoleId == role.Id select us; List <spAllowedRoleMenu> _AllowedRoleMenus = _AllowedRoleMenusquery.ToList(); var _AllowedReportsRolesMenusquery = from us in db.spAllowedReportsRolesMenus where us.RoleId == role.Id select us; List <spAllowedReportsRolesMenu> _AllowedReportsRolesMenus = _AllowedReportsRolesMenusquery.ToList(); if (_Users.Count > 0) { MessageBox.Show("There is a User Associated with this Role.\n Delete the User First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else if (_AllowedRoleMenus.Count > 0) { MessageBox.Show("There is a Menu Right Associated with this Role.\n Delete the Menu Right First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else if (_AllowedReportsRolesMenus.Count > 0) { MessageBox.Show("There is a Report Menu Right Associated with this Role.\n Delete the Report Menu Right First!", "Confirm Delete", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { if (DialogResult.Yes == MessageBox.Show("Are you sure you want to delete Role\n" + role.Description.ToUpper().ToString().Trim(), "Confirm Delete", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)) { db.spRoles.DeleteObject(role); db.SaveChanges(); RefreshGrid(); } } } catch (Exception ex) { Utils.ShowError(ex); } } }
public EditRolesForm(spRole _role, string Conn) { InitializeComponent(); if (string.IsNullOrEmpty(Conn)) { throw new ArgumentNullException("connection"); } connection = Conn; rep = new Repository(connection); db = new SBPayrollDBEntities(connection); role = _role; }
public async Task <UserResponse> RegisterUserAsync(RegisterUserModel model) { var eu = await db.tbUsers.FirstOrDefaultAsync(x => x.Username == model.Username); if (eu != null) { return new UserResponse() { Status = 0, StatusMessage = "User exits" } } ; var role = db.spRoles.Find(1); if (role == null) { var r = new spRole(); r.Name = "Admin"; r.UserAccess = ",999"; await db.spRoles.AddAsync(r); await db.SaveChangesAsync(); } var u = new tbUser(); u.FirstName = model.FirstName; u.LastName = model.LastName; u.Username = model.Username; u.Password = HashSha256.Get(model.Password); u.EMail = model.EMail; u.RoleId = 1; await db.tbUsers.AddAsync(u); await db.SaveChangesAsync(); return(await AuthenticateAsync(new UserRequest() { Username = model.Username, Password = model.Password })); } }
public static void Run(Apteka.SqlServer.AptekaSqlServerDbContext sqlDb, MyDbContext pgDb) { var sr = new spRole() { Name = "admin", UserAccess = "999;1;2;3", CreateDate = DateTime.Now, CreateUser = 1, Status = 1 }; var sl = new spAccessList() { Id = 999, Name = "admin", CreateDate = DateTime.Now, CreateUser = 1, Status = 1 }; pgDb.tbUser.Add ( new tbUser() { FirstName = "admin", LastName = "admin", Role = sr, Status = 1, CreateDate = DateTime.Now, CreateUser = 1, Username = "******", Password = "******" } ); pgDb.ChangeTracker.DetectChanges(); pgDb.SaveChanges(); }
private void btnAdd_Click(object sender, EventArgs e) { errorProvider1.Clear(); if (IsRoleValid()) { try { spRole role = new spRole(); if (!string.IsNullOrEmpty(txtShortCode.Text)) { role.ShortCode = Utils.ConvertFirstLetterToUpper(txtShortCode.Text); } if (!string.IsNullOrEmpty(txtDescription.Text)) { role.Description = Utils.ConvertFirstLetterToUpper(txtDescription.Text); } role.IsDeleted = false; if (db.spRoles.Any(i => i.ShortCode == role.ShortCode)) { MessageBox.Show("Role Code Exist!", "SB Payroll", MessageBoxButtons.OK, MessageBoxIcon.Information); } if (!db.spRoles.Any(i => i.ShortCode == role.ShortCode)) { db.spRoles.AddObject(role); db.SaveChanges(); RolesListForm rlf = (RolesListForm)this.Owner; rlf.RefreshGrid(); this.Close(); } } catch (Exception ex) { Utils.ShowError(ex); } } }