public void Load_DataGridView()
{
try
{
dsmail = mailclass.GetArchivedMails(online_Username);
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_MailBox;
PicSign.Image = global::OCA.WinUI.Properties.Resources.ArenaWarsMonitor;
CmbParvandeh.Text = "";
txtSignerName.Clear();
txt_Search.Clear();
lst_Files.Items.Clear();
lst_Mails.Items.Clear();
CmbSearchKind.SelectedIndex = 0;
CmbParvandeh.Items.Clear();
dsparvandeh = parvandehclass.GetParvandeh();
for (int i = 1; i <= dsparvandeh.Tbl_MailParvandeh.Rows.Count; i++)
{
CmbParvandeh.Items.Add(dsparvandeh.Tbl_MailParvandeh[i - 1].ParvandehName.Trim());
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void radioButton_Archived_CheckedChanged(object sender, EventArgs e)
{
CmbName.Items.Clear();
dsmail = mailclass.GetArchivedMails(online_Username);
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
CmbName.Items.Add(dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim());
}
}
private void CmbDrafts_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dsmail = mailclass.GetDrafts(online_Username);
richTextBox1.Text = richTextBox1.Text + "\n" + dsmail.Tbl_Draft[CmbDrafts.SelectedIndex].Draft_Text;
}
catch { }
}
public OCA.Common.DataSets.Kartabl.MailBox GetAllMails()
{
try
{
dsmail.Clear();
dsmail = mailclass.GetAllMails();
return(dsmail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.Kartabl.MailBox SearchMailProgress(string SearchWord)
{
try
{
dsmail.Clear();
dsmail = mailclass.SearchMailProgress(SearchWord);
return(dsmail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.Kartabl.MailBox GetReportMailByMailNum(string Mail_Num)
{
try
{
dsmail.Clear();
dsmail = mailclass.GetReportMailByMailNum(Mail_Num);
return(dsmail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.Kartabl.MailBox SearchArchivedMail(string SearchKind, string Username, string SearchWord)
{
try
{
dsmail.Clear();
dsmail = mailclass.SearchArchivedMail(SearchKind, Username, SearchWord);
return(dsmail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.Kartabl.MailBox GetDrafts(string Username)
{
try
{
dsmail.Clear();
dsmail = mailclass.GetDrafts(Username);
return(dsmail);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void lst_Mails_DoubleClick(object sender, EventArgs e)
{
try
{
string Mail_Number = lst_Mails.SelectedItems[0].ToString().Trim().Substring(0, lst_Mails.Items[0].ToString().Trim().IndexOf("#"));
dsmail = mailclass.GetReportMailByMailNum(Mail_Number);
if (dsmail.Tbl_MailBox.Rows.Count == 0)
{
throw new Exception("نامه مورد نظر یافت نشد!");
}
OCA.WinUI.BaseForms.BaseReportForm reportform = new OCA.WinUI.BaseForms.BaseReportForm();
OCA.WinUI.Kartabl.Report.MailReport reportfile = new OCA.WinUI.Kartabl.Report.MailReport();
reportfile.SetParameterValue("Mail_Text", dsmail.Tbl_MailBox[0].Mail_Text.Trim());
reportfile.SetParameterValue("Mail_Name", dsmail.Tbl_MailBox[0].Mail_Name.Trim());
try
{
reportfile.SetParameterValue("Mail_Date", dsmail.Tbl_MailBox[0].Mail_Date.Trim());
}
catch
{
reportfile.SetParameterValue("Mail_Date", " ");
}
try
{
reportfile.SetParameterValue("Mail_Refer", dsmail.Tbl_MailBox[0].Refer_Description.Trim());
}
catch
{
reportfile.SetParameterValue("Mail_Refer", " ");
}
reportform.crystalReportViewer1.ReportSource = reportfile;
reportform.Show();
}
catch (Exception ex)
{
if (ex.Message != "Index was outside the bounds of the array.")
{
mesg.Error("خطا", ex.Message);
}
}
dsmail = mailclass.GetSendedDabirkhanehMails();
}
public void Load_DataGridView()
{
try
{
dsmail = mailclass.GetReceivedDabirkhanehMails();
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_MailBox;
txtName.Clear();
txt_Search.Clear();
lst_Files.Items.Clear();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
public void Load_DataGridView()
{
try
{
dsmail = mailclass.GetDrafts(online_Username);
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_Draft;
txtDraftName.Clear();
richTextBox1.Clear();
txtSearch.Clear();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void lst_Files_DoubleClick(object sender, EventArgs e)
{
string temp = Directory.GetCurrentDirectory();
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[0];
try
{
string Attach_FileName = lst_Files.SelectedItems[0].ToString().Trim();
try
{
dsattach = mailclass.GetAttachesByName(Attach_FileName, DataGridView.SelectedRows[0].Cells["Mail_Num"].Value.ToString().Trim());
}
catch { throw new Exception("لطفا ابتدا نامه ای که پیوست مربوط به آن است را انتخاب کنید!"); }
saveFileDialog1.Filter = "فایل پیوست|*" + Attach_FileName.Substring(Attach_FileName.LastIndexOf("."));
saveFileDialog1.FileName = Attach_FileName;
saveFileDialog1.ShowDialog();
if (saveFileDialog1.FileName != Attach_FileName)
{
if (File.Exists(saveFileDialog1.FileName))
{
if (mesg.Question("توجه", "فایل " + Attach_FileName + " موجود است ، آیا می خواهید روی آن بازنویسی کنید؟"))
{
File.WriteAllBytes(saveFileDialog1.FileName, dsattach.Tbl_Attach[0].Attach_File);
}
}
else
{
File.WriteAllBytes(saveFileDialog1.FileName, dsattach.Tbl_Attach[0].Attach_File);
}
}
}
catch (Exception ex)
{
if (ex.Message != "Index was outside the bounds of the array.")
{
mesg.Error("خطا", ex.Message);
}
}
InputLanguage.CurrentInputLanguage = InputLanguage.InstalledInputLanguages[1];
Directory.SetCurrentDirectory(temp);
dsmail = mailclass.GetReceivedDabirkhanehMails();
}
public void Load_DataGridView()
{
try
{
dsmail = mailclass.GetSendedMails(online_Username);
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_MailBox;
PicSign.Image = global::OCA.WinUI.Properties.Resources.ArenaWarsMonitor;
txtName.Clear();
txtSignerName.Clear();
txtSignerName.Clear();
lst_Files.Items.Clear();
lst_Mails.Items.Clear();
}
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 BtnAddMail_Click(object sender, EventArgs e)
{
dsmail = mailclass.GetMails(online_Username);
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
if (CmbMails.Text.Trim() == dsmail.Tbl_MailBox[i - 1].Mail_Num + "#" + dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim())
{
int j;
for (j = 1; j <= lst_AttachMail.Items.Count; j++)
{
if (CmbMails.Text.Trim() == lst_AttachMail.Items[j - 1].ToString().Trim())
{
break;
}
}
if (j == lst_AttachMail.Items.Count + 1)
{
lst_AttachMail.Items.Add(CmbMails.Text.Trim());
}
}
}
}
private void InsertExportMail_Load(object sender, EventArgs e)
{
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());
}
CmbName.Items.Clear();
dsmail = mailclass.GetSendedDabirkhanehMails();
for (int i = 1; i <= dsmail.Tbl_MailBox.Rows.Count; i++)
{
CmbName.Items.Add(dsmail.Tbl_MailBox[i - 1].Mail_Name.Trim());
}
}
private void MailHistory_Load(object sender, EventArgs e)
{
dsmail = mailclass.SearchMailProgress(txtName.Text.Trim());
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_MailBox;
}
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 txtName_TextChanged(object sender, EventArgs e)
{
txtName.Text = pubclass.SqlInjection(txtName.Text);
dsmail = mailclass.SearchMailProgress(txtName.Text.Trim());
}
