private void barButtonItemDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup")) { if (gridViewGroup.FocusedRowHandle < 0) return; DataRow row = gridViewGroup.GetDataRow(gridViewGroup.FocusedRowHandle); DialogResult reply = FWMsgBox.questionGroupDelete(row["GROUPNAME"].ToString()); if (reply == DialogResult.Yes) { Group group = new Group(); group.id = HelpNumber.ParseInt64(row["GROUPID"].ToString()); if (!group.delete()) { FWMsgBox.showDeleteUsing(); return; } else { gridViewGroup.DeleteRow(gridViewGroup.FocusedRowHandle); editEnabledButtonDeleteAndEdit(); } } } else { if (gridViewUser.FocusedRowHandle < 0) return; DataRow row = gridViewUser.GetDataRow(gridViewUser.FocusedRowHandle); if (row["USERNAME"].ToString() == "admin") { HelpMsgBox.ShowNotificationMessage("Bạn không thể xóa người dùng 'admin'"); return; } DialogResult reply = FWMsgBox.questionUserDelete(row["USERNAME"].ToString()); if (reply == DialogResult.Yes) { User user = new User(); user.id = HelpNumber.ParseInt64(row["USERID"].ToString()); if (!user.delete()) { FWMsgBox.showDeleteUsing(); return; } else { this.gridViewUser.DeleteRow(gridViewUser.FocusedRowHandle); editEnabledButtonDeleteAndEdit(); } } } //HUNG reLoadGroupUserThanhPhan(); }
//PHUOC OK public Group findById(long groupId) { Group group = null; DatabaseFB db = DABase.getDatabase(); DbCommand select = db.GetSQLStringCommand("SELECT GROUPID, GROUPNAME FROM " + "GROUP_CAT WHERE GROUPID=@groupId"); db.AddInParameter(select, "@groupId", DbType.Int64, groupId); IDataReader reader = db.ExecuteReader(select); if (reader.Read()) { group = new Group(); group.id = HelpNumber.ParseInt64(reader["GROUPID"].ToString()); group.groupName = reader["GROUPNAME"].ToString(); } reader.Close(); return group; }
//PHUOC OK public List<Group> getListGroupByIdUser(long userId) { List<Group> groups = new List<Group>(); DatabaseFB db = DABase.getDatabase(); DbCommand dbSelect = db.GetSQLStringCommand("SELECT * FROM GROUP_CAT g, GROUP_USER_REL ug WHERE" + " g.GROUPID=ug.GROUPID AND ug.USERID=@userId ORDER BY lower(GROUPNAME) ASC"); db.AddInParameter(dbSelect, "@userId", DbType.Int64, userId); IDataReader reader = db.ExecuteReader(dbSelect); while (reader.Read()) { Group group = new Group(); group.id = HelpNumber.ParseInt64(reader["groupid"].ToString()); group.groupName = reader["groupname"].ToString(); groups.Add(group); } reader.Close(); return groups; }
//PHUOC OK public List<Group> findAllGroup() { List<Group> groups = new List<Group>(); DatabaseFB db = DABase.getDatabase(); DbCommand select = db.GetSQLStringCommand("SELECT GROUPID, GROUPNAME FROM GROUP_CAT ORDER BY lower(GROUPNAME) ASC"); IDataReader reader = db.ExecuteReader(select); while (reader.Read()) { Group group = new Group(HelpNumber.ParseInt64(reader["GROUPID"].ToString()), reader["GROUPNAME"].ToString()); groups.Add(group); } reader.Close(); return groups; }