public static int Insert(tblUserInGroup userGroup) { var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true)); db.AddTotblUserInGroups(userGroup); int re= db.SaveChanges(); db.Connection.Close(); return re; }
private void btnUpdateListGroup_Click(object sender, EventArgs e) { //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 current Group of this User before add new ones UserInGroupFactory.DeleteUserInGroupByUserID(_userID); //add selected group into userInGroup try { foreach (DataGridViewRow dr in grvGroup.Rows) { if (dr.Cells[0].Value + "" == "True") { int groupID = new Int32(); groupID = (Int32)dr.Cells[1].Value; tblUserInGroup userInGroup = new tblUserInGroup(); userInGroup.GroupID = groupID; userInGroup.UserID = _userID; UserInGroupFactory.Insert(userInGroup); } } } catch (Exception) { MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL); return; } MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY); }
private void btnSave_Click(object sender, EventArgs e) { //delete all current user of this Group before add new ones UserInGroupFactory.DeleteUserInGroupByGroupID(_groupID); //add selected user into groups try { foreach (DataGridViewRow dr in grvUser.Rows) { if (dr.Cells[0].Value + "" == "True") { int userID = new Int32(); userID = (Int32)dr.Cells[1].Value; tblUserInGroup userInGroup = new tblUserInGroup(); userInGroup.GroupID = _groupID; userInGroup.UserID = userID; UserInGroupFactory.Insert(userInGroup); } } } catch (Exception) { MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL); return; } MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY); // Bind the lastest to the parrent Form[] listForm = this.Owner.OwnedForms; foreach (Form form in listForm) { if (form.Name == "frmAddGroup") { ((frmAddGroup)form).BindData(); } } this.Close(); }