private void Setup_grd_usergroup(string select_usergroup = "")
{
grd_usergroup.DataSource = Permission_ds.Select_usergroup();
if (grd_usergroup.Rows.Count == 0)
{
return;
}
grd_usergroup.ClearSelection();
if (select_usergroup == "")
{
grd_usergroup.Rows[0].Selected = true;
grd_usergroup.CurrentCell = grd_usergroup[0, 0];
}
else
{
select_usergroup = select_usergroup.ToUpper();
foreach (DataGridViewRow grd_row in grd_usergroup.Rows)
{
if (grd_row.Cells["usergroup"].Value.ToString().ToUpper() == select_usergroup)
{
grd_row.Selected = true;
grd_usergroup.CurrentCell = grd_row.Cells["usergroup"];
break;
}
}
}
grd_usergroup.AutoResizeColumns();
Setup_grd_permission();
}
private void Btn_ok_Click(object sender, EventArgs e)
{
string str_new_usergroup = txt_name.Text.Trim();
string str_usergroup_description = txt_description.Text.Trim();
if (str_new_usergroup.Length == 0)
{
MessageBox.Show("Usergroup name is required.", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (!Permission_ds.Usergroup_available(str_new_usergroup, _usergroup))
{
MessageBox.Show("Usergroup name already in use.", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (_usergroup == "")
{
// Adding new usergroup
if (!Program.System_user.Has_permission(Class_enum.User_permission.ADD_USERGROUP))
{
MessageBox.Show("You do not have permission to add usergroup!", "ACCESS DENIED",
MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
return;
}
Permission_ds.Insert_usergroup(str_new_usergroup, str_usergroup_description);
}
else
{
// editing existing usergroup
if (!Program.System_user.Has_permission(Class_enum.User_permission.EDIT_USERGROUP))
{
MessageBox.Show("You do not have permission to edit usergroup!", "ACCESS DENIED",
MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
return;
}
string str_perm_combine = Class_listview.Get_checked_results_as_string(listview_permission, "permission");
Permission_ds.Update_usergroup(str_new_usergroup, str_usergroup_description, _usergroup);
}
string str_permission_combine = Class_listview.Get_checked_results_as_string(listview_permission, "permission");
if (str_permission_combine == "")
{
MessageBox.Show("Select one or more permission.", "Invalid input", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Permission_ds.Update_usergroup_permission(str_new_usergroup, str_permission_combine);
_usergroup = str_new_usergroup;
this.DialogResult = DialogResult.OK;
this.Close();
}
private void Select_listview_permission()
{
List <string> list_permission = new List <string>();
foreach (DataRow dt_row in Permission_ds.Select_permission_by_usergroup(_usergroup).Rows)
{
list_permission.Add(dt_row["permission"].ToString());
}
foreach (ListViewItem lv_item in listview_permission.Items)
{
lv_item.Checked = list_permission.Contains(lv_item.Text);
}
}
private void Form_edit_users_Shown(object sender, EventArgs e)
{
if (!Program.System_user.Has_permission(Class_enum.User_permission.EDIT_USER))
{
MessageBox.Show("You do not have permission to edit users!", "ACCESS DENIED",
MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
Class_style.Grd_style.Common_style(grd_permission);
Class_style.Grd_style.Common_style(grd_usergroup);
grd_usergroup.DataSource = Permission_ds.Select_usergroup();
grd_usergroup.ClearSelection();
grd_usergroup.CurrentCell = null;
txt_username.Text = Obj_user.Username;
txt_name.Text = Obj_user.Name;
txt_ic_no.Text = Obj_user.IcNo;
dtp_join.Value = Obj_user.JoinDate;
if (Obj_user.LeaveDate != null)
{
dtp_leave.Value = (DateTime)Obj_user.LeaveDate;
dtp_leave.Enabled = true;
ch_empty_leave_date.Checked = false;
}
else
{
dtp_leave.Enabled = false;
ch_empty_leave_date.Checked = true;
}
if (Obj_user.UserImage != null)
{
picbox_image.Image = Image.FromStream(new MemoryStream(Obj_user.UserImage));
}
if (Obj_user.UserGroup != null)
{
foreach (DataGridViewRow grd_row in grd_usergroup.Rows)
{
if (grd_row.Cells["usergroup"].Value.ToString() == Obj_user.UserGroup)
{
grd_usergroup.ClearSelection();
grd_row.Cells["usergroup"].Selected = true;
grd_usergroup.CurrentCell = grd_row.Cells["usergroup"];
break;
}
}
}
grd_usergroup.RowEnter += Grd_usergroup_RowEnter;
}
private void Setup_grd_permission()
{
if (grd_usergroup.SelectedCells.Count == 0)
{
return;
}
string str_usergroup = grd_usergroup.SelectedRows[0].Cells["usergroup"].Value.ToString();
grd_permission.DataSource = null;
grd_permission.DataSource = Permission_ds.Select_permission_by_usergroup(str_usergroup);
grd_permission.Columns["permission"].Width = 160;
grd_permission.Columns["permission_desc"].Width = 200;
}
private void Setup_grd_permission()
{
if (grd_usergroup.SelectedCells.Count == 0)
{
return;
}
string str_usergroup = grd_usergroup.SelectedRows[0].Cells["usergroup"].Value.ToString();
bool is_administrator = str_usergroup == "ADMINISTRATOR";
editToolStripMenuItem.Enabled = !is_administrator;
btn_edit.Enabled = !is_administrator;
removeToolStripMenuItem.Enabled = !is_administrator;
btn_remove.Enabled = !is_administrator;
grd_permission.DataSource = null;
grd_permission.DataSource = Permission_ds.Select_permission_by_usergroup(str_usergroup);
grd_permission.Columns["permission"].Width = 160;
grd_permission.Columns["permission_desc"].Width = 200;
}
private void Remove_usergroup(object sender, EventArgs e)
{
DataGridViewRow grd_row = grd_usergroup.Rows[grd_usergroup.SelectedCells[0].RowIndex];
string str_usergroup = grd_row.Cells["usergroup"].Value.ToString();
// ADMINISTRATOR usergroup CANNOT be edited and removed
if (str_usergroup.ToUpper() == "ADMINISTRATOR")
{
MessageBox.Show("ADMINISTRATOR usergroup cannot be edited or deleted.", "",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Are you sure? This action cannot be undone", "Confirm",
MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
Permission_ds.Delete_usergroup(str_usergroup);
Setup_grd_usergroup();
}
private void Init_form()
{
Class_listview.Setup_listview(listview_permission, Permission_ds.Select_all_permission());
}
