private void copyRoles(string user1, string user2) { //copy role var ctx = gen.GetNewEntity(); // khai bao new entity Framework var query = ctx.UserJoinRoles .Where(c => c.UserName == user1 && c.CompanyCode == Globals.companycode); foreach (var data in query) { UserJoinRole obj = new UserJoinRole(); obj.RoleCode = data.RoleCode; obj.UserName = user2; obj.CompanyCode = data.CompanyCode; ctx.UserJoinRoles.Add(obj); //insert } try { ctx.SaveChanges(); XtraMessageBox.Show("Copy roles successfully", "Copy", MessageBoxButtons.OK, MessageBoxIcon.Information); } //catch (DbUpdateException ex) // exception khac catch (DbUpdateConcurrencyException ex) // exception khac { XtraMessageBox.Show(ex.Message + ex.StackTrace + ex.TargetSite + ex.InnerException.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_DeleteRole_Click(object sender, EventArgs e) // delete role { // delete UserJoinRole UserJoinRole data = new UserJoinRole();// lop UserJoinRole data.UserName = txtuser.Text; data.CompanyCode = Globals.companycode; data.RoleCode = txtRole.Text; var db = gen.GetNewEntity(); // khai bao new entity Framework try { db.Entry(data).State = System.Data.Entity.EntityState.Deleted; // delete db.SaveChanges(); XtraMessageBox.Show("Deleted successfully", "btn_DeleteRole_Click", MessageBoxButtons.OK, MessageBoxIcon.Information); load_lai_grid_role(); } catch (Exception ex) // exception khac { XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_AddRole_Click(object sender, EventArgs e) // add role { // insert in to UserJoinRole UserJoinRole data = new UserJoinRole();// lop UserJoinRole data.UserName = txtuser.Text; data.CompanyCode = Globals.companycode; data.RoleCode = txtRole.Text; var db = gen.GetNewEntity(); // khai bao new entity Framework try { db.UserJoinRoles.Add(data); //insert db.SaveChanges(); XtraMessageBox.Show("Insert successfully", "tsbtsave_Click", MessageBoxButtons.OK, MessageBoxIcon.Information); load_lai_grid_role(); } catch (Exception ex) // exception khac { XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }