public static int Insert(tblUserGroupPermission userGroupPermission) { var db = new dbTrainEntities(ConnectionController.GetConnection()); db.AddTotblUserGroupPermissions(userGroupPermission); int re = db.SaveChanges(); db.Connection.Close(); return(re); }
private void btnUpdatePermission_Click(object sender, EventArgs e) { var confirm = MessageBox.Show(ConstantInfo.CONFIRM_UPDATE, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (confirm != DialogResult.Yes) { return; } //check is user exist tblUser user = UserFactory.GetByID(_userID); if (user == null) { MessageBox.Show("Người dùng này không còn tại tại trong hệ thống nữa, xin kiểm tra lại"); return; } //delete all old permissions UserGroupPermissionFactory.DeleteUserGroupPermissionByUserID(_userID); //add new permissions try { List <tblUserGroupPermission> listUserGroupPermission = new List <tblUserGroupPermission>(); foreach (DataGridViewRow dr in grvPermission.Rows) { if (dr.Cells[0].Value + "" == "True") { int permissionID = (int)dr.Cells[1].Value; tblUserGroupPermission userGroupPermission = new tblUserGroupPermission(); userGroupPermission.UserID = _userID; userGroupPermission.PermissionID = permissionID; userGroupPermission.PermissionType = UserGroupPermissionFactory.PERMISSION_TYPE_USER; userGroupPermission.CreatedBy = _userInfo.UserID; userGroupPermission.ModifiedBy = _userInfo.UserID; userGroupPermission.CreatedDate = CommonFactory.GetCurrentDate(); userGroupPermission.ModifiedDate = CommonFactory.GetCurrentDate(); //add to listUserGroupPermission listUserGroupPermission.Add(userGroupPermission); } } //save listUserGroupPermission to database UserGroupPermissionFactory.Insert(listUserGroupPermission); } catch (Exception) { MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL); return; } MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY); }
private void btnUpdatePermission_Click(object sender, EventArgs e) { //check is group exist tblGroup group = GroupFactory.getGroupByID(_groupID); if (group == null) { MessageBox.Show("Nhóm người dùng này không còn tại tại trong hệ thống nữa, xin kiểm tra lại"); return; } //delete all old permissions UserGroupPermissionFactory.DeleteUserGroupPermissionByGroupID(_groupID); //add new permissions try { List <tblUserGroupPermission> listUserGroupPermission = new List <tblUserGroupPermission>(); foreach (DataGridViewRow dr in grvPermission.Rows) { if (dr.Cells[0].Value + "" == "True") { int permissionID = (int)dr.Cells[1].Value; tblUserGroupPermission userGroupPermission = new tblUserGroupPermission(); userGroupPermission.GroupID = _groupID; userGroupPermission.PermissionID = permissionID; userGroupPermission.PermissionType = UserGroupPermissionFactory.PERMISSION_TYPE_GROUP; userGroupPermission.CreatedBy = _userInfo.UserID; userGroupPermission.ModifiedBy = _userInfo.UserID; userGroupPermission.CreatedDate = CommonFactory.GetCurrentDate(); userGroupPermission.ModifiedDate = CommonFactory.GetCurrentDate(); //add to listUserGroupPermission listUserGroupPermission.Add(userGroupPermission); } } //save listUserGroupPermission to database UserGroupPermissionFactory.Insert(listUserGroupPermission); } catch (Exception) { MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL); return; } MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY); }
public static tblUserGroupPermission CreatetblUserGroupPermission(int id, string branchId) { tblUserGroupPermission tblUserGroupPermission = new tblUserGroupPermission(); tblUserGroupPermission.ID = id; tblUserGroupPermission.BranchId = branchId; return tblUserGroupPermission; }
public void AddTotblUserGroupPermissions(tblUserGroupPermission tblUserGroupPermission) { AddObject("tblUserGroupPermissions", tblUserGroupPermission); }