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;
}
