private void SaveDocType()
{
string cmd = "INSERT INTO DocumentsType (Name,IconUrl) VALUES ('" + txtDocType.Text.Trim() + @"','" + picIcon.Tag.ToString() + "')";
if (Cv_Session.ExecuteCommand(cmd))
{
cmd = "SELECT MAX(Id) FROM DocumentsType";
DocTypeId = int.Parse(Cv_Session.GetFieldText(cmd));
MessageBox.Show("تم الحفظ بنجاح ");
list.LoadDocType(false);
SetEventList();
return;
}
MessageBox.Show("لم تتم عملية الحفظ هناك خطأ ما تأكد انك مازلت متصل بقاعدة البيانات");
}
private void DeleteDocSelect()
{
DialogResult rs = MessageBox.Show("هل انت متأكد من عملية الحذف ", "تنبيه حذف", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (rs == DialogResult.No)
{
return;
}
string cmd = " DELETE FROM Documents WHERE Id=" + DocId;
if (Cv_Session.ExecuteCommand(cmd))
{
DocId = 0;
LoadDocList(false);
}
else
{
MessageBox.Show("خطأ!" + Cv_Session.DbErrorMessage);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (!CheckControl())
{
return;
}
string cmd = " UPDATE Users SET UserName='******',";
cmd += " UserPassword='******',";
cmd += " AlertByDayAfter=" + txtDayAlert.Text;
cmd += " , StartOpenSystem='" + ckhAlertIsOpen.Checked.ToString() + "' WHERE Id=1";
if (Cv_Session.ExecuteCommand(cmd))
{
MessageBox.Show("تم تحديث البيانات بنجاح ");
}
frmMain.Instance.MetroUser.Text = "Welcome \r\n" + txtUserName.Text;
if (picUser.Image != null && picUser.Tag != null)
{
SaveUserPic();
}
}
