public Boolean IsUserValid(string Username, string Password)
{
try
{
dsclerk.Clear();
dsclerk = pubclass.IsUserValid(Username, Password.GetHashCode().ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
try
{
if (dsclerk.Tbl_Clerk[0].Username.Trim() == Username && dsclerk.Tbl_Clerk[0].Pass.Trim() == Password.GetHashCode().ToString())
{
return(true);
}
else
{
return(false);
}
}
catch
{
throw new Exception("کاربر مورد نظر در سیستم موجود نمی باشد!");
}
}
public void Load_DataGridView()
{
dsclerk = clerkclass.GetClerkGroups();
dsclerk.AcceptChanges();
DataGridView.DataSource = dsclerk.Tbl_ClerkGroup;
txtClerkGroup.Clear();
}
private void SendMessage_Load(object sender, EventArgs e)
{
CmbClerks.Items.Clear();
dsclerk = clerkclass.GetClerks();
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
CmbClerks.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
}
}
private void UserAccount_Load(object sender, EventArgs e)
{
dsclerk.Clear();
dsclerk = clerkclass.GetClerkByUsername(online_Username);
txtName.Text = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
try
{
CmbSex.Text = dsclerk.Tbl_Clerk[0].Sex.Trim();
}
catch { }
try
{
txtAge.Text = dsclerk.Tbl_Clerk[0].Age.ToString();
}
catch { }
try
{
txtTel.Text = dsclerk.Tbl_Clerk[0].Tel.Trim();
}
catch { }
try
{
txtMobile.Text = dsclerk.Tbl_Clerk[0].Mobile.Trim();
}
catch { }
try
{
txtExpert.Text = dsclerk.Tbl_Clerk[0].Expert.Trim();
}
catch { }
try
{
txtEmail.Text = dsclerk.Tbl_Clerk[0].Email.Trim();
}
catch { }
try
{
txtAddress.Text = dsclerk.Tbl_Clerk[0].Address_.Trim();
}
catch { }
try
{
MemoryStream mstrm1 = new MemoryStream(dsclerk.Tbl_Clerk[0].ImagePic);
PicImage.Image = Image.FromStream(mstrm1);
}
catch { }
try
{
MemoryStream mstrm2 = new MemoryStream(dsclerk.Tbl_Clerk[0].SignPic);
PicSign.Image = Image.FromStream(mstrm2);
}
catch { }
}
private void InsertImportMail_Load(object sender, EventArgs e)
{
try
{
CmbTopic.Items.Clear();
dsmTopic = mTopicclass.GetMailTopics();
for (int i = 1; i <= dsmTopic.Tbl_MailTopic.Rows.Count; i++)
{
CmbTopic.Items.Add(dsmTopic.Tbl_MailTopic[i - 1].TopicName.Trim());
}
CmbSecurity.Items.Clear();
dsmSecurity = mSecurityclass.GetMailSecuritys();
for (int i = 1; i <= dsmSecurity.Tbl_MailSecurity.Rows.Count; i++)
{
CmbSecurity.Items.Add(dsmSecurity.Tbl_MailSecurity[i - 1].SecurityName.Trim());
}
CmbPriority.Items.Clear();
dsmPriority = mPriorityclass.GetMailPrioritys();
for (int i = 1; i <= dsmPriority.Tbl_MailPriority.Rows.Count; i++)
{
CmbPriority.Items.Add(dsmPriority.Tbl_MailPriority[i - 1].PriorityName.Trim());
}
CmbCondition.Items.Clear();
dsmCondition = mConditionclass.GetMailConditions();
for (int i = 1; i <= dsmCondition.Tbl_MailCondition.Rows.Count; i++)
{
CmbCondition.Items.Add(dsmCondition.Tbl_MailCondition[i - 1].ConditionName.Trim());
}
CmbClerks.Items.Clear();
dsclerk = clerkclass.GetClerks();
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
CmbInternalCC.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
CmbClerks.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
}
CmbPersons.Items.Clear();
dsexoffice = exofficeclass.GetExOffice();
for (int i = 1; i <= dsexoffice.Tbl_ExOffice.Rows.Count; i++)
{
CmbPersons.Items.Add(dsexoffice.Tbl_ExOffice[i - 1].PersonName.Trim());
}
txtDate.Text = Persia.Calendar.ConvertToPersian(DateTime.Now).Simple.ToString();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
public OCA.Common.DataSets.BaseInformation.Clerk GetClerkGroups()
{
try
{
dsclerk.Clear();
dsclerk = clerkclass.GetClerkGroups();
return(dsclerk);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.BaseInformation.Clerk GetNameByUsername(string Username)
{
try
{
dsclerk.Clear();
dsclerk = clerkclass.GetNameByUsername(Username);
return(dsclerk);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.BaseInformation.Clerk SearchClerk(string SearchKind, string SearchWord)
{
try
{
dsclerk.Clear();
dsclerk = clerkclass.SearchClerk(SearchKind, SearchWord);
return(dsclerk);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void Load_DataGridView()
{
try
{
txtName.Clear();
txtFamily.Clear();
txtUsername.Clear();
txtPassword.Clear();
CmbAccess.Text = "";
CmbAccess.Items.Clear();
CmbSemat.Text = "";
CmbSemat.Items.Clear();
CmbUnit.Text = "";
CmbUnit.Items.Clear();
CmbClerkGroup.Text = "";
CmbClerkGroup.Items.Clear();
dsclerk = clerkclass.GetClerkGroups();
for (int i = 1; i <= dsclerk.Tbl_ClerkGroup.Rows.Count; i++)
{
CmbClerkGroup.Items.Add(dsclerk.Tbl_ClerkGroup[i - 1].GroupName.Trim());
}
dsunit = unitclass.GetAllUnits();
for (int i = 1; i <= dsunit.Tbl_Unit.Rows.Count; i++)
{
CmbUnit.Items.Add(dsunit.Tbl_Unit[i - 1].UnitName.Trim());
}
dssemat = sematclass.GetSemats();
for (int i = 1; i <= dssemat.Tbl_Semat.Rows.Count; i++)
{
CmbSemat.Items.Add(dssemat.Tbl_Semat[i - 1].SematName.Trim());
}
dsaccess = accessclass.GetAccess();
for (int i = 1; i <= dsaccess.Tbl_Access.Rows.Count; i++)
{
CmbAccess.Items.Add(dsaccess.Tbl_Access[i - 1].AccessName.Trim());
}
dsclerk = clerkclass.GetClerks();
dsclerk.AcceptChanges();
DataGridView.DataSource = dsclerk.Tbl_Clerk;
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void ReferMail_Load(object sender, EventArgs e)
{
try
{
dsclerk = clerkclass.GetNameByUsername(online_Username);
Online_Name = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
CmbClerks.Items.Clear();
dsclerk = clerkclass.GetClerks();
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
CmbInternalCC.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
CmbClerks.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
}
CmbPersons.Items.Clear();
dsexoffice = exofficeclass.GetExOffice();
for (int i = 1; i <= dsexoffice.Tbl_ExOffice.Rows.Count; i++)
{
Cmb_ExternalCC.Items.Add(dsexoffice.Tbl_ExOffice[i - 1].PersonName.Trim());
CmbPersons.Items.Add(dsexoffice.Tbl_ExOffice[i - 1].PersonName.Trim());
}
CmbMails.Items.Clear();
dsmail = mailclass.GetMails(online_Username);
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
CmbMails.Items.Add(dsmail.Tbl_MailBox[i - 1].Mail_Num + "#" + dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim());
}
CmbName.Items.Clear();
dsmail = mailclass.GetReceivedMails(online_Username);
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
CmbName.Items.Add(dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim());
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnMySign_Click(object sender, EventArgs e)
{
try
{
dsclerk = clerkclass.GetClerks();
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
if (dsclerk.Tbl_Clerk[i - 1].Username.Trim() == online_Username)
{
txtSingerName.Text = dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim();
MemoryStream mstrm = new MemoryStream(dsclerk.Tbl_Clerk[i - 1].ImagePic);
PicSign.Image = Image.FromStream(mstrm);
File.WriteAllBytes(Directory.GetCurrentDirectory() + "\\temp.dat", dsclerk.Tbl_Clerk[i - 1].ImagePic);
str_PicSign = Directory.GetCurrentDirectory() + "\\temp.dat";
break;
}
}
}
catch { }
}
private void BtnSend_Click(object sender, EventArgs e)
{
try
{
string Receiver_Username = "";
txtReferText.Text = pubclass.SqlInjection(txtReferText.Text);
if (CmbName.Text == "")
{
throw new Exception("لطفا عنوان نامه را وارد کنید!");
}
if (CmbName.SelectedIndex == -1)
{
throw new Exception("لطفا عنوان نامه را درست وارد کنید!");
}
if (txtReferText.Text == "")
{
throw new Exception("متن ارجاع خالی است!");
}
if (radioButton_Clerk.Checked == true) //Internal
{
try
{
Receiver_Username = dsclerk.Tbl_Clerk[CmbClerks.SelectedIndex].Username.Trim();
}
catch { throw new Exception("لطفا نام گیرنده داخلی را درست وارد کنید!"); }
if (online_Username == Receiver_Username)
{
throw new Exception("شما به خودتان ایمیل می زنید؟!!");
}
Refer_Mail(Online_Name, Receiver_Username, CmbClerks.Text.Trim(), Receiver_Username, CmbClerks.Text.Trim());
}
else //External
{
try
{
Receiver_Username = dsexoffice.Tbl_ExOffice[CmbPersons.SelectedIndex].PersonName.Trim();
}
catch { throw new Exception("لطفا نام گیرنده خارجی را درست وارد کنید!"); }
Refer_Mail(Online_Name, "دبیرخانه", "دبیرخانه", Receiver_Username, CmbPersons.Text.Trim());
}
try
{
//External_CC
for (int i = 1; i <= lst_ExternalCC.Items.Count; i++)
{
string Recive_User = lst_ExternalCC.Items[i - 1].ToString().Trim();
if (CmbPersons.Text.Trim() == Recive_User)
{
continue;
}
dsclerk = clerkclass.GetNameByUsername(Recive_User);
try
{
string Receive_name = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
Refer_Mail(Online_Name, "دبیرخانه", "دبیرخانه", Recive_User, Receive_name);
}
catch
{
Refer_Mail(Online_Name, "دبیرخانه", "دبیرخانه", Recive_User, Recive_User);
}
}
//Internal_CC
for (int i = 1; i <= lst_InternalCC.Items.Count; i++)
{
string Recive_User = clerkclass.GetUsernameByName(lst_InternalCC.Items[i - 1].ToString().Trim());
if (online_Username == Recive_User)
{
continue;
}
dsclerk = clerkclass.GetNameByUsername(Recive_User);
string Receive_name = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
Refer_Mail(Online_Name, Recive_User, Receive_name, Recive_User, Receive_name);
}
}
catch
{
mesg.Error("خطا", "خطا در ارسال رونوشت");
}
mesg.Information("توجه", "نامه " + CmbName.Text.Trim() + " با موفقیت ارسال شد.");
this.Close();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void MainPage_Load(object sender, EventArgs e)
{
dsclerk = clerkclass.GetNameByUsername(online_Username);
lblWelcome.Text = "\"" + dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim() + "\"" +
" خوش آمدید!";
}
private void CreateMail_Load(object sender, EventArgs e)
{
try
{
dsclerk = clerkclass.GetNameByUsername(online_Username);
Online_Name = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
CmbTopic.Items.Clear();
dsmTopic = mTopicclass.GetMailTopics();
for (int i = 1; i <= dsmTopic.Tbl_MailTopic.Rows.Count; i++)
{
CmbTopic.Items.Add(dsmTopic.Tbl_MailTopic[i - 1].TopicName.Trim());
}
CmbSecurity.Items.Clear();
dsmSecurity = mSecurityclass.GetMailSecuritys();
for (int i = 1; i <= dsmSecurity.Tbl_MailSecurity.Rows.Count; i++)
{
CmbSecurity.Items.Add(dsmSecurity.Tbl_MailSecurity[i - 1].SecurityName.Trim());
}
CmbPriority.Items.Clear();
dsmPriority = mPriorityclass.GetMailPrioritys();
for (int i = 1; i <= dsmPriority.Tbl_MailPriority.Rows.Count; i++)
{
CmbPriority.Items.Add(dsmPriority.Tbl_MailPriority[i - 1].PriorityName.Trim());
}
CmbCondition.Items.Clear();
dsmCondition = mConditionclass.GetMailConditions();
for (int i = 1; i <= dsmCondition.Tbl_MailCondition.Rows.Count; i++)
{
CmbCondition.Items.Add(dsmCondition.Tbl_MailCondition[i - 1].ConditionName.Trim());
}
CmbClerks.Items.Clear();
dsclerk = clerkclass.GetClerks();
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
CmbInternalCC.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
CmbClerks.Items.Add(dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim());
}
CmbPersons.Items.Clear();
dsexoffice = exofficeclass.GetExOffice();
for (int i = 1; i <= dsexoffice.Tbl_ExOffice.Rows.Count; i++)
{
Cmb_ExternalCC.Items.Add(dsexoffice.Tbl_ExOffice[i - 1].PersonName.Trim());
CmbPersons.Items.Add(dsexoffice.Tbl_ExOffice[i - 1].PersonName.Trim());
}
txtDate.Text = Persia.Calendar.ConvertToPersian(DateTime.Now).Simple.ToString();
CmbDrafts.Items.Clear();
dsmail = mailclass.GetDrafts(online_Username);
for (int i = 1; i <= dsmail.Tbl_Draft.Rows.Count; i++)
{
CmbDrafts.Items.Add(dsmail.Tbl_Draft[i - 1].Draft_Name.Trim());
}
CmbMails.Items.Clear();
dsmail = mailclass.GetMails(online_Username);
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
CmbMails.Items.Add(dsmail.Tbl_MailBox[i - 1].Mail_Num + "#" + dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim());
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
string Receiver_Username = "";
string Sender_Username = "";
richTextBox1.Text = pubclass.SqlInjection(richTextBox1.Text);
if (txtName.Text == "")
{
throw new Exception("لطفا عنوان نامه را وارد کنید!");
}
if (mailclass.IsMailExist(txtName.Text.Trim()))
{
throw new Exception("نامه ای با این عنوان در سیستم موجود می باشد!");
}
if (richTextBox1.Text == "با سلام" || richTextBox1.Text == "")
{
throw new Exception("متن نامه خالی است!");
}
//Internal
try
{
Receiver_Username = dsclerk.Tbl_Clerk[CmbClerks.SelectedIndex].Username.Trim();
}
catch { throw new Exception("لطفا نام گیرنده را درست وارد کنید!"); }
try
{
Sender_Username = dsexoffice.Tbl_ExOffice[CmbPersons.SelectedIndex].PersonName.Trim();
}
catch { throw new Exception("لطفا نام فرستنده را درست وارد کنید!"); }
Insert_Mail(Sender_Username, Receiver_Username, CmbClerks.Text.Trim(), Receiver_Username, CmbClerks.Text.Trim());
try
{
//Internal_CC
for (int i = 1; i <= lst_InternalCC.Items.Count; i++)
{
string Recive_User = clerkclass.GetUsernameByName(lst_InternalCC.Items[i - 1].ToString().Trim());
dsclerk = clerkclass.GetNameByUsername(Recive_User);
string Receive_name = dsclerk.Tbl_Clerk[0].Name_.Trim() + " " + dsclerk.Tbl_Clerk[0].Family.Trim();
Insert_Mail(Sender_Username, Recive_User, Receive_name, Recive_User, Receive_name);
}
}
catch
{
mesg.Error("خطا", "خطا در ارسال رونوشت");
}
mesg.Information("توجه", "نامه " + txtName.Text.Trim() + " با موفقیت ارسال شد.");
this.Close();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnInsert_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا نام کاربر را وارد کنید!");
}
else if (txtFamily.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا نام خانوادگی کاربر را وارد کنید!");
}
else if (txtUsername.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا نام کاربری کاربر را وارد کنید!");
}
else if (txtPassword.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا کلمه عبور کاربر را وارد کنید!");
}
else if (CmbAccess.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا سطح دسترسی کاربر را انتخاب کنید!");
}
else if (CmbSemat.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا سمت کاربر را انتخاب کنید!");
}
else if (CmbUnit.Text.Trim() == "")
{
mesg.Error("خطا", "لطفا واحد سازمانی کاربر را انتخاب کنید!");
}
else if (CmbClerkGroup.Text.Trim() != "" && CmbClerkGroup.SelectedIndex == -1)
{
mesg.Error("خطا", "لطفا نام گروه کاربری را درست انتخاب کنید!");
}
else if (txtUsername.Text.Trim().Length < 4)
{
mesg.Error("خطا", "طول نام کاربری باید حداقل 4 کاراکتر باشد!");
}
else if (txtPassword.Text.Trim().Length < 4)
{
mesg.Error("خطا", "طول کلمه عبور باید حداقل 4 کاراکتر باشد!");
}
else
{
dsclerk = clerkclass.GetClerks();
int i;
for (i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
if (dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim() == txtName.Text.Trim().Replace("ی", "ي") + " " + txtFamily.Text.Trim().Replace("ی", "ي"))
{
break;
}
}
if (i == dsclerk.Tbl_Clerk.Rows.Count + 1)
{
clerkclass.InsertClerk(txtName.Text.Trim(), txtFamily.Text.Trim(), txtUsername.Text.Trim(),
txtPassword.Text.Trim(), CmbClerkGroup.Text.Trim(), CmbAccess.Text.Trim(), CmbSemat.Text.Trim(),
CmbUnit.Text.Trim());
Load_DataGridView();
}
else
{
mesg.Warning("توجه", "در حال حاضر کاربری با این نام و نام خانوادگی در سیستم موجود است!");
}
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
