private void btnLogin_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtUserName.Text) || String.IsNullOrEmpty(txtPassword.Text) || String.IsNullOrEmpty(txtDBName.Text))
{
MessageBox.Show("الرجاء ادخال اسم خادم قاعدة البيانات او اسم المستخدم او كلمة المرور ");
return;
}
ConnectionDatabaseServer();
string cmd = "SELECT Id FROM Users WHERE UserName='******' AND UserPassword='******'";
//Checck UserName & Password
if (Cv_Session.HasRows(cmd))
{
Cv_Session.UserId = int.Parse(Cv_Session.GetFieldText(cmd));
ucDashBoard uc = new ucDashBoard(Cv_Session);
uc.Dock = DockStyle.Fill;
frmMain.Instance.MetroController.Controls.Add(uc);
//Show user buttons
frmMain.Instance.MetroUser.Visible = true;
frmMain.Instance.MetroLogout.Visible = true;
frmMain.Instance.MetroController.Controls["ucDashBoard"].BringToFront();
// formMain.Controls.Add(uc);
if (frmMain.Instance.MetroController.Controls["ucDashBoard"] == null)
{
frmMain.Instance.MetroController.Controls["ucDashBoard"].BringToFront();
frmMain.Instance.MetroBack.Visible = true;
}
frmMain.Instance.Cv_Session = Cv_Session;
frmMain.Instance.MetroUser.Text = "Welcome \r\n" + txtUserName.Text;
cmd = " SELECT StartOpenSystem FROM Users";
bool Fv_IsAlertShow;
Fv_IsAlertShow = Cv_Session.GetFieldBoolean(cmd);
if (!Fv_IsAlertShow)
{
return;
}
frmRemmber frmAlert = new frmRemmber(Cv_Session);
frmAlert.Show();
}
else
{
string msg = "خطأ! اسم المستخدم او كلمة المرور غير صحيحه " + Cv_Session.DbErrorMessage;
MessageBox.Show(msg);
return;
}
}
private void LaodDocExpire()
{
Cv_Flag = false;
string cmd = " SELECT AlertByDayAfter FROM Users";
int Fv_DaySetting = 0;
int.TryParse(Cv_Session.GetFieldText(cmd), out Fv_DaySetting);
cmd = "SELECT Id,DocName FROM ViewDocuments WHERE (" + Fv_DaySetting + " >= DATEDIFF(d, GETDATE(), ExpireDate))";
Cv_Session.FillTreeNode(treeDocExpire, cmd, 0);
Cv_Flag = true;
}
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("لم تتم عملية الحفظ هناك خطأ ما تأكد انك مازلت متصل بقاعدة البيانات");
}
public void LoadDocType(bool IsSearch)
{
pnlContent.Controls.Clear();
string cmd = "SELECT Id,Name,IconUrl FROM DocumentsType";
if (IsSearch)
{
if (!String.IsNullOrEmpty(txtSearch.Text))
{
cmd += " WHERE Name LIKE '%" + txtSearch.Text + "%'";
}
}
DataTable dt = new DataTable();
if (!Cv_Session.FillDataTable(dt, cmd))
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
docTypeTitle = new MetroFramework.Controls.MetroTile();
docTypeTitle.Dock = System.Windows.Forms.DockStyle.Top;
docTypeTitle.Size = new System.Drawing.Size(279, 77);
docTypeTitle.Text = dt.Rows[i]["Name"].ToString();
cmd = "SELECT COUNT(Id) FROM Documents WHERE DocTypeId=" + dt.Rows[i]["Id"].ToString();
docTypeTitle.TileCount = int.Parse(Cv_Session.GetFieldText(cmd));
docTypeTitle.TileImage = Image.FromFile(dt.Rows[i]["IconUrl"].ToString());
docTypeTitle.TileImage.Tag = dt.Rows[i]["IconUrl"].ToString();
docTypeTitle.UseCustomBackColor = true;
docTypeTitle.UseCustomForeColor = true;
docTypeTitle.Tag = dt.Rows[i]["Id"];
docTypeTitle.UseSelectable = true;
docTypeTitle.UseTileImage = true;
docTypeTitle.Click += new System.EventHandler(this.docTypeSelect_Click);
docTypeTitle.Name = "docTypeTitle" + i;
this.pnlContent.Controls.Add(docTypeTitle);
}
}
