private void btnUpdate_Click(object sender, EventArgs e)
{
string userName = LbUsers.SelectedValue.ToString();
DataTable dt = new DataTable();
dt.Columns.Add("username");
dt.Columns.Add("idScreen");
dt.Columns.Add("Prev");
try
{
for (int i = 0; i < gridUser.Rows.Count; i++)
{
int idScreen = Convert.ToInt32(gridUser.Rows[i].Cells[0].Value.ToString());
Boolean show = gridUser.Rows[i].Cells[2].Value.Equals(true || false);
dt.Rows.Add(userName, idScreen, show);
}
Class_Users.usp_UpatePriv(dt);
MessageBox.Show("تم حفظ الصلاحيات بنجاح");
}
catch (Exception ex)
{
// throw;
}
}
private void LbUsers_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = Class_Users.getPriv(LbUsers.SelectedValue.ToString());
gridUser.DataSource = dt;
gridUser.Columns[0].Visible = false;
}
private void Permission()
{
DataTable dt = Class_Users.GetPermission();
cmbPerm.DisplayMember = "PermLabel";
cmbPerm.ValueMember = "idPermission";
cmbPerm.DataSource = dt;
}
public Form_Priveleges()
{
InitializeComponent();
DataTable dt = Class_Users.usp_getNameOfUsers();
LbUsers.DisplayMember = "username";
LbUsers.ValueMember = "username";
LbUsers.DataSource = dt;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
foreach (Control c in groupBox1.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c == txtEmail)
{
continue;
}
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
}
}
try
{
if (txtPassword.Text != txtPasswordConfirm.Text)
{
MessageBox.Show("كلمة المرور غير متطابقة");
txtPasswordConfirm.Clear();
return;
}
if (txtUsername.Text.ToLower() == "administrateur" && cmbPerm.Text.ToLower() == "admin")
{
MessageBox.Show("لا يمكن تنزيل رتبة المدير", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
Class_Users.usp_tblUsersUpdate(txtUsername.Text, txtFullName.Text, txtPassword.Text, txtEmail.Text, Convert.ToInt32(cmbPerm.SelectedValue));
MessageBox.Show("تم التعديل بنجاح");
loadData();
Clear();
}
catch (Exception ex)
{
//
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
foreach (Control c in groupBox1.Controls)
{
if (c is TextBox || c is ComboBox)
{
if (c == txtEmail)
{
continue;
}
if (c.Text == "")
{
MessageBox.Show("المرجوا ملئ جميع الخانات", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
}
}
try
{
if (txtPassword.Text != txtPasswordConfirm.Text)
{
MessageBox.Show("كلمة المرور غير متطابقة");
txtPasswordConfirm.Clear();
return;
}
Class_Users.usp_tblUsersInsert(txtUsername.Text, txtFullName.Text, txtPassword.Text, txtEmail.Text, Convert.ToInt32(cmbPerm.SelectedValue));
MessageBox.Show("تمت الإضافة بنجاح", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadData();
Clear();
}
catch (Exception ex)
{
MessageBox.Show("لا يمكن إضافة هذا المستخدم، قد يكون موجوداً", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
string username = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
if (username == "Administrateur")
{
MessageBox.Show("لا يمكن حذف هذا المستخدم", "إشعار", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DialogResult dr = MessageBox.Show("هل تريد حقا حذف هذا المتسخدم", "إشعار", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
Class_Users.usp_tblUsersDelete(username);
MessageBox.Show("تم الحذف بنجاح");
loadData();
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("يتعذر حذف هذا المستخدم");
}
}
private void loadData()
{
DataTable dt = Class_Users.usp_tblUsersSelect();
dataGridView1.DataSource = dt;
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dt = Class_Users.usp_searchUsr(txtSearch.Text);
dataGridView1.DataSource = dt;
}
private void MainForm_Activated(object sender, EventArgs e)
{
if (check == false)
{
Maintab.DisableTab(metroTabPage1);
}
else if (check == true)
{
if (idPre == 1)
{
Maintab.EnableTab(metroTabPage1);
LogoutPanel.Enabled = true;
Pbackup.Enabled = true;
foreach (Control c in metroTabPage1.Controls)
{
if (c is Button)
{
c.Enabled = true;
}
}
}
else if (idPre == 2)
{
try
{
DataTable dt = Class_Users.usp_getMyprevilages(username);
if (dt.Rows[0][0].ToString() == "False" || dt.Rows[0][0].ToString() == string.Empty)
{
btnAddStudent.Enabled = false;
}
if (dt.Rows[1][0].ToString() == "False" || dt.Rows[1][0].ToString() == string.Empty)
{
btnStudentsManagment.Enabled = false;
}
if (dt.Rows[2][0].ToString() == "False" || dt.Rows[2][0].ToString() == string.Empty)
{
btnAddSchoolYear.Enabled = false;
}
if (dt.Rows[3][0].ToString() == "False" || dt.Rows[3][0].ToString() == string.Empty)
{
btnSchoolYearManagment.Enabled = false;
}
if (dt.Rows[4][0].ToString() == "False" || dt.Rows[4][0].ToString() == string.Empty)
{
btnAddFilier.Enabled = false;
}
if (dt.Rows[5][0].ToString() == "False" || dt.Rows[5][0].ToString() == string.Empty)
{
btnFiliereManagment.Enabled = false;
}
if (dt.Rows[6][0].ToString() == "False" || dt.Rows[6][0].ToString() == string.Empty)
{
btnClasses.Enabled = false;
}
if (dt.Rows[7][0].ToString() == "False" || dt.Rows[7][0].ToString() == string.Empty)
{
btnDiscount.Enabled = false;
}
if (dt.Rows[8][0].ToString() == "False" || dt.Rows[8][0].ToString() == string.Empty)
{
btnOtherFees.Enabled = false;
}
if (dt.Rows[9][0].ToString() == "False" || dt.Rows[9][0].ToString() == string.Empty)
{
btnAddFacture.Enabled = false;
}
if (dt.Rows[10][0].ToString() == "False" || dt.Rows[10][0].ToString() == string.Empty)
{
btnFeesMang.Enabled = false;
}
if (dt.Rows[11][0].ToString() == "False" || dt.Rows[11][0].ToString() == string.Empty)
{
btnFeeStatic.Enabled = false;
}
if (dt.Rows[12][0].ToString() == "False" || dt.Rows[12][0].ToString() == string.Empty)
{
btnLateFees.Enabled = false;
}
if (dt.Rows[13][0].ToString() == "False" || dt.Rows[13][0].ToString() == string.Empty)
{
btnUsersMan.Enabled = false;
}
if (dt.Rows[14][0].ToString() == "False" || dt.Rows[14][0].ToString() == string.Empty)
{
btnPrev.Enabled = false;
}
Maintab.EnableTab(metroTabPage1);
LogoutPanel.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (idPre == 0)
{
Maintab.DisableTab(metroTabPage1);
LogoutPanel.Enabled = false;
Pbackup.Enabled = false;
username = null;
idPre = 0;
check = false;
}
}
}
