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.ExOffice SearchExOffice(string PersonName)
{
try
{
dsexoffice.Clear();
dsexoffice = exofficeclass.SearchExOffice(PersonName);
return(dsexoffice);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public OCA.Common.DataSets.BaseInformation.ExOffice GetExOffice()
{
try
{
dsexoffice.Clear();
dsexoffice = exofficeclass.GetExOffice();
return(dsexoffice);
}
catch (Exception ex)
{
throw new Exception(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);
}
}
public void Load_DataGridView()
{
try
{
dsexoffice = exofficeclass.GetExOffice();
dsexoffice.AcceptChanges();
DataGridView.DataSource = dsexoffice.Tbl_ExOffice;
CmbPersonKind.SelectedIndex = 0;
txtPersonName.Clear();
txtTel.Clear();
txtFax.Clear();
txtEmail.Clear();
txtSite.Clear();
txtAddress.Clear();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
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);
}
}
