private void Load_Chart()
{
try
{
TreeNode baseNode = new TreeNode("");
dspub.Clear();
dspub = puclass.GetCompanyInfo();
baseNode.Text = dspub.Tbl_Organiztion[0].OrganiztionName;
CmbUpUnit.Items.Clear();
CmbUpUnit.Items.Add(dspub.Tbl_Organiztion[0].OrganiztionName);
txtUnitName.Clear();
dsunit.Clear();
dsunit = unitclass.GetUnits();
for (int i = 1; i <= dsunit.Tbl_Unit.Rows.Count; i++)
{
InsertTree(baseNode, dsunit.Tbl_Unit[i - 1].UnitName.Trim(), dsunit.Tbl_Unit[i - 1].UpperUnit.Trim());
CmbUpUnit.Items.Add(dsunit.Tbl_Unit[i - 1].UnitName.Trim());
}
treeView1.Nodes.Clear();
treeView1.Nodes.Add(baseNode);
treeView1.ExpandAll();
CmbUpUnit.SelectedIndex = 0;
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnInsert_Click(object sender, EventArgs e)
{
try
{
if (txtPriorityName.Text.Trim() != "")
{
if (BtnEdit.Enabled == true) //Insert
{
mPriorityclass.InsertMailPriority(txtPriorityName.Text.Trim());
}
else if (BtnEdit.Enabled == false) //Update
{
mPriorityclass.EditMailPriority(DataGridView.SelectedRows[0].Cells["PriorityName"].Value.ToString(), txtPriorityName.Text.Trim());
}
}
else
{
mesg.Warning("خطا", "لطفا نوع اولویت نامه را وارد کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
Load_DataGridView();
BtnEdit.Enabled = true;
BtnRemove.Enabled = true;
}
private void BtnRemove_Click(object sender, EventArgs e)
{
try
{
if (DataGridView.SelectedRows.Count == 1)
{
if (DataGridView.SelectedRows[0].Cells["AccessName"].Value.ToString().Trim() != "مدير ارشد")
{
accessclass.RemoveAccess(DataGridView.SelectedRows[0].Cells["AccessName"].Value.ToString());
}
else
{
mesg.Warning("خطا", "سطح دسترسی مدیر ارشد قابل حذف نمی باشد!");
}
}
else
{
mesg.Warning("خطا", "لطفا سطح دسترسی مورد نظر را انتخاب کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
Load_DataGridView();
}
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 void Load_DataGridView()
{
try
{
dsmessage = messageclass.GetSendedMessages(online_Username);
dsmessage.AcceptChanges();
DataGridView.DataSource = dsmessage.Tbl_MessageBox;
txtMsgName.Clear();
txtMsgText.Clear();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (txtOrganiztionName.Text.Trim() != "")
{
if (ImageDialog.FileName == "openFileDialog1")
{
ImageDialog.FileName = "";
}
pubclass.UpdateCompanyInfo(txtOrganiztionName.Text.Trim(), txtTel1.Text.Trim(), txtTel2.Text.Trim(),
txtTel3.Text.Trim(), txtFax1.Text.Trim(), txtFax2.Text.Trim(), txtAddress1.Text.Trim(),
txtAddress2.Text.Trim(), ImageDialog.FileName);
mesg.Information("توجه", "اطلاعات سازمان با موفقیت ذخیره شد. ");
}
else
{
mesg.Warning("توجه", "لطفا نام سازمان را وارد کنید.");
}
}
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 BtnView_Click(object sender, EventArgs e)
{
try
{
if (DataGridView.SelectedRows.Count == 1)
{
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_Date", DataGridView.SelectedRows[0].Cells["Mail_Date"].Value.ToString().Trim());
reportfile.SetParameterValue("Mail_Text", DataGridView.SelectedRows[0].Cells["Mail_Text"].Value.ToString().Trim());
reportfile.SetParameterValue("Mail_Refer", DataGridView.SelectedRows[0].Cells["Refer_Description"].Value.ToString().Trim());
reportfile.SetParameterValue("Mail_Name", DataGridView.SelectedRows[0].Cells["Mail_Name"].Value.ToString().Trim());
reportform.crystalReportViewer1.ReportSource = reportfile;
reportform.Show();
}
else
{
mesg.Warning("خطا", "لطفا نامه مورد نظر را انتخاب کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
richTextBox1.Text = pubclass.SqlInjection(richTextBox1.Text);
str_MailNumber = dsmail.Tbl_MailBox[CmbName.SelectedIndex].Mail_Num.ToString().Trim();
if (CmbName.Text == "")
{
throw new Exception("لطفا عنوان نامه را وارد کنید!");
}
if (CmbName.SelectedIndex == -1)
{
throw new Exception("لطفا عنوان نامه را درست وارد کنید!");
}
if (richTextBox1.Text == "")
{
throw new Exception("متن ارجاع خالی است!");
}
mailclass.Update_Mail(str_MailNumber, txtDate.Text.Trim(), CmbTopic.Text.Trim(), CmbPriority.Text.Trim(),
CmbSecurity.Text.Trim(), CmbCondition.Text.Trim(), richTextBox1.Text.Trim(), txtSingerName.Text.Trim(),
str_PicSign);
mesg.Information("توجه", "نامه " + CmbName.Text.Trim() + " با موفقیت ذخیره شد.");
this.Close();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
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);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
richTextBox1.Text = pubclass.SqlInjection(richTextBox1.Text);
if (txtAttachName.Text == "")
{
mesg.Warning("توجه", "لطفا نام پیش نویس را وارد کنید!");
txtAttachName.Focus();
}
else if (richTextBox1.Text == "")
{
mesg.Warning("توجه", "متن پیش نویس خالی است!");
richTextBox1.Focus();
}
else
{
mailclass.InsertDraft(online_Username, txtAttachName.Text.Trim(), richTextBox1.Text.Trim());
mesg.Information("موفقیت", "پیش نویس با موفقیت ذخیره شد.");
richTextBox1.Clear();
txtAttachName.Clear();
txtAttachName.Focus();
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
try
{
if (pubclass.IsUserValid(txt_Username.Text.Trim(), txt_Password.Text.Trim()))
{
ValidUser = true;
MainForm mfrm = new MainForm();
mfrm.Online_Username = txt_Username.Text.Trim();
Close();
}
}
catch (Exception ex)
{
OCA.WinUI.BaseForms.BaseMessageBox mesg = new OCA.WinUI.BaseForms.BaseMessageBox();
mesg.Error("خطا", ex.Message);
if (LoginFailed == 3)
{
this.Close();
}
LoginFailed++;
txt_Username.Clear();
txt_Password.Clear();
txt_Username.Focus();
}
}
private void BtnSend_Click(object sender, EventArgs e)
{
try
{
txtMsgText.Text = pubclass.SqlInjection(txtMsgText.Text);
if (txtMsgName.Text.Trim() == "")
{
throw new Exception("لطفا نام پیام را وارد کنید!");
}
string Receiver_User;
string Receiver_Name;
try
{
Receiver_Name = dsclerk.Tbl_Clerk[CmbClerks.SelectedIndex].Name_.Trim() + " " +
dsclerk.Tbl_Clerk[CmbClerks.SelectedIndex].Family.Trim();
Receiver_User = dsclerk.Tbl_Clerk[CmbClerks.SelectedIndex].Username.Trim();
}
catch { throw new Exception("لطفا گیرنده پیام را انتخاب کنید!"); }
if (Receiver_User == online_Username)
{
throw new Exception("شما می خواهید به خودتان پیام بزنید؟!!");
}
if (txtMsgText.Text.Trim() == "")
{
throw new Exception("لطفا متن پیام را وارد کنید!");
}
string Online_Name = "";
for (int i = 1; i <= dsclerk.Tbl_Clerk.Rows.Count; i++)
{
if (online_Username == dsclerk.Tbl_Clerk[i - 1].Username.Trim())
{
Online_Name = dsclerk.Tbl_Clerk[i - 1].Name_.Trim() + " " + dsclerk.Tbl_Clerk[i - 1].Family.Trim();
}
}
//for Sender
messageclass.InsertMessage(Persia.Calendar.ConvertToPersian(DateTime.Now).Simple.ToString().Trim(),
txtMsgName.Text.Trim(), online_Username, online_Username, Online_Name, Receiver_User, Receiver_Name,
txtMsgText.Text.Trim());
//for Receiver
messageclass.InsertMessage(Persia.Calendar.ConvertToPersian(DateTime.Now).Simple.ToString().Trim(),
txtMsgName.Text.Trim(), Receiver_User, online_Username, Online_Name, Receiver_User, Receiver_Name,
txtMsgText.Text.Trim());
mesg.Information("توجه", "پیام مورد نظر با موفقیت ارسال شد.");
txtMsgText.Clear();
CmbClerks.Text = "";
txtMsgName.Clear();
txtMsgName.Focus();
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
txtMsgName.Focus();
}
}
private void Load_Chart()
{
try
{
dssemat = sematclass.GetSemats();
TreeNode baseNode = new TreeNode("");
baseNode.Text = dssemat.Tbl_Semat[0].SematName.Trim();
CmbUpSemat.Items.Clear();
for (int i = 2; i <= dssemat.Tbl_Semat.Rows.Count; i++)
{
InsertTree(baseNode, dssemat.Tbl_Semat[i - 1].SematName.Trim(), dssemat.Tbl_Semat[i - 1].UpperSemat.Trim());
}
for (int i = 1; i <= dssemat.Tbl_Semat.Rows.Count; i++)
{
CmbUpSemat.Items.Add(dssemat.Tbl_Semat[i - 1].SematName.Trim());
}
treeView1.Nodes.Clear();
treeView1.Nodes.Add(baseNode);
treeView1.ExpandAll();
txtSematName.Clear();
if (CmbUpSemat.Items.Count != 0)
{
CmbUpSemat.SelectedIndex = 0;
}
CmbSematGroup.Text = "";
dssemat = sematclass.GetSematGroups();
CmbSematGroup.Items.Clear();
for (int i = 1; i <= dssemat.Tbl_SematGroup.Rows.Count; i++)
{
CmbSematGroup.Items.Add(dssemat.Tbl_SematGroup[i - 1].GroupName.Trim());
}
}
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 BtnRemove_Click(object sender, EventArgs e)
{
try
{
if (DataGridView.SelectedRows.Count == 1)
{
parvandehclass.RemoveParvandeh(DataGridView.SelectedRows[0].Cells["ParvandehName"].Value.ToString());
}
else
{
mesg.Warning("خطا", "لطفا پرونده مورد نظر را انتخاب کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
Load_DataGridView();
}
private void BtnEdit_Click(object sender, EventArgs e)
{
try
{
if (DataGridView.SelectedRows.Count == 1)
{
txtSematGroup.Text = DataGridView.SelectedRows[0].Cells["GroupName"].Value.ToString().Trim();
BtnEdit.Enabled = false;
BtnRemove.Enabled = false;
}
else
{
mesg.Warning("خطا", "لطفا گروه سمت مورد نظر را انتخاب کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnRemove_Click(object sender, EventArgs e)
{
try
{
if (DataGridView.SelectedRows.Count == 1)
{
clerkclass.RemoveClerkGroup(DataGridView.SelectedRows[0].Cells["GroupName"].Value.ToString());
}
else
{
mesg.Warning("خطا", "لطفا گروه کارمند مورد نظر را انتخاب کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
Load_DataGridView();
}
public void Load_DataGridView()
{
try
{
dsmail = mailclass.GetInternalMails();
dsmail.AcceptChanges();
DataGridView.DataSource = dsmail.Tbl_MailBox;
PicSign.Image = global::OCA.WinUI.Properties.Resources.ArenaWarsMonitor;
txtName.Clear();
txtSignerName.Clear();
txt_Search.Clear();
lst_Files.Items.Clear();
lst_Mails.Items.Clear();
CmbSearchKind.SelectedIndex = 0;
}
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);
}
}
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 BtnInsert_Click(object sender, EventArgs e)
{
try
{
if (txtParvandehName.Text.Trim() != "")
{
parvandehclass.InsertParvandeh(txtParvandehName.Text.Trim());
}
else
{
mesg.Warning("خطا", "لطفا نام پرونده را وارد کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
Load_DataGridView();
}
private void BtnInsert_Click(object sender, EventArgs e)
{
try
{
if (txtAccessName.Text.Trim() != "")
{
accessclass.InsertAccess(txtAccessName.Text.Trim(), GetCheckBox(chkCreateMail), GetCheckBox(chkEditMail),
GetCheckBox(chkDraft), GetCheckBox(chkMailInbox), GetCheckBox(chkMailOutbox), GetCheckBox(chkReferMail),
GetCheckBox(chkArchiveMail), GetCheckBox(chkMailHistory), GetCheckBox(chkSearchMail),
GetCheckBox(chkInsertParvandeh), GetCheckBox(chkViewParvandeh), GetCheckBox(chkMsgInbox),
GetCheckBox(chkMsgOutbox), GetCheckBox(chkSendMessage), GetCheckBox(chkDeletedMessage),
GetCheckBox(chkInsertImportMail), GetCheckBox(chkViewImportMail), GetCheckBox(chkInsertExportMail),
GetCheckBox(chkViewExportMail), GetCheckBox(chkViewInternalMail), GetCheckBox(chkDefineChart),
GetCheckBox(chkViewChart), GetCheckBox(chkCompanyInfo), GetCheckBox(chkNewSemat), GetCheckBox(chkEditSemat),
GetCheckBox(chkSematGroup), GetCheckBox(chkNewAccess), GetCheckBox(chkEditAccess2),
GetCheckBox(chkEditAccess), GetCheckBox(chkNewClerk), GetCheckBox(chkEditClerk), GetCheckBox(chkClerkGroup),
GetCheckBox(chkNewExOffice), GetCheckBox(chkEditExOffice), GetCheckBox(chkNewAddress),
GetCheckBox(chkEditAddress), GetCheckBox(chkMailNumber), GetCheckBox(chkMailTopic),
GetCheckBox(chkMailCondition), GetCheckBox(chkMailPriority), GetCheckBox(chkMailSecurity),
GetCheckBox(chkReferenceDescription), GetCheckBox(chkColorSetting), GetCheckBox(chkFaxSetting),
GetCheckBox(chkPrinterSetting), GetCheckBox(chkScanerSetting), GetCheckBox(chkEmailSetting),
GetCheckBox(chkBackUp), GetCheckBox(chkNewReminder), GetCheckBox(chkEditReminder), GetCheckBox(chkNewNews),
GetCheckBox(chkEditNews), GetCheckBox(chkTextComm), GetCheckBox(chkVoiceComm), GetCheckBox(chkVideoComm));
ClearCheckBoxes();
txtAccessName.Clear();
mesg.Information("توجه", "سطح دسترسی مورد نظر با موفقیت ثبت شد.");
}
else
{
mesg.Warning("توجه", "لطفا نام سطح دسترسی را وارد کنید!");
}
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (txtPassword.Text.Trim().Length >= 4)
{
if (CmbSex.Text != "")
{
if (CmbSex.Text != "مرد" && CmbSex.Text != "زن")
{
throw new Exception("لطفا جنسیت را درست انتخاب کنید!");
}
}
if (str_PicSign == "openFileDialog1")
{
str_PicSign = "";
}
if (str_PicImage == "openFileDialog1")
{
str_PicImage = "";
}
clerkclass.UpdateClerkAcount(online_Username, txtPassword.Text.Trim(), CmbSex.Text.Trim(),
txtAge.Text.Trim(), txtTel.Text.Trim(), txtMobile.Text.Trim(), txtExpert.Text.Trim(),
txtEmail.Text.Trim(), txtAddress.Text.Trim(), str_PicSign, str_PicImage);
mesg.Information("توجه", "اطلاعات کاربر با موفقیت ذخیره شد.");
txtPassword.Clear();
}
else
{
mesg.Warning("توجه", "طول کلمه عبور نباید کمتر از 4 کاراکتر باشد!");
}
}
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);
}
}
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 CmbAccessName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dsaccess = accessclass.GetAccess();
chkCreateMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].CreateMail.ToString().Trim());
chkEditMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditMail.ToString().Trim());
chkDraft.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].Draft.ToString().Trim());
chkMailInbox.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailInbox.ToString().Trim());
chkMailOutbox.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailOutbox.ToString().Trim());
chkReferMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ReferMail.ToString().Trim());
chkArchiveMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ArchiveMail.ToString().Trim());
chkMailHistory.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailHistory.ToString().Trim());
chkSearchMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].SearchMail.ToString().Trim());
chkInsertParvandeh.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].InsertParvandeh.ToString().Trim());
chkViewParvandeh.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ViewParvandeh.ToString().Trim());
chkMsgInbox.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MsgInbox.ToString().Trim());
chkMsgOutbox.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MsgOutbox.ToString().Trim());
chkSendMessage.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].SendMessage.ToString().Trim());
chkDeletedMessage.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].DeletedMessage.ToString().Trim());
chkInsertImportMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].InsertImportMail.ToString().Trim());
chkViewImportMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ViewImportMail.ToString().Trim());
chkInsertExportMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].InsertExportMail.ToString().Trim());
chkViewExportMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].VeiwExportMail.ToString().Trim());
chkViewInternalMail.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ViewInternalMail.ToString().Trim());
chkDefineChart.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].DefineChart.ToString().Trim());
chkViewChart.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ViewChart.ToString().Trim());
chkCompanyInfo.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].CompanyInfo.ToString().Trim());
chkNewSemat.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewSemat.ToString().Trim());
chkEditSemat.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditSemat.ToString().Trim());
chkSematGroup.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].SematGroup.ToString().Trim());
chkNewAccess.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewAccess.ToString().Trim());
chkEditAccess2.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditAccess2.ToString().Trim());
chkEditAccess.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditAccess.ToString().Trim());
chkNewClerk.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewClerk.ToString().Trim());
chkEditClerk.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditClerk.ToString().Trim());
chkClerkGroup.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ClerkGroup.ToString().Trim());
chkNewExOffice.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewExOffice.ToString().Trim());
chkEditExOffice.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditExOffice.ToString().Trim());
chkNewAddress.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewAddress.ToString().Trim());
chkEditAddress.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditAddress.ToString().Trim());
chkMailNumber.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailNumber.ToString().Trim());
chkMailTopic.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailTopic.ToString().Trim());
chkMailCondition.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailCondition.ToString().Trim());
chkMailPriority.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailPriority.ToString().Trim());
chkMailSecurity.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].MailSecurity.ToString().Trim());
chkReferenceDescription.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ReferenceDescription.ToString().Trim());
chkColorSetting.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ColorSetting.ToString().Trim());
chkFaxSetting.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].FaxSetting.ToString().Trim());
chkPrinterSetting.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].PrinterSetting.ToString().Trim());
chkScanerSetting.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].ScanerSetting.ToString().Trim());
chkEmailSetting.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EmailSetting.ToString().Trim());
chkBackUp.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].Back_Up.ToString().Trim());
chkNewReminder.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewReminder.ToString().Trim());
chkEditReminder.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditReminder.ToString().Trim());
chkNewNews.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].NewNews.ToString().Trim());
chkEditNews.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].EditNews.ToString().Trim());
chkTextComm.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].TextComm.ToString().Trim());
chkVoiceComm.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].VoiceComm.ToString().Trim());
chkVideoComm.Checked = SetCheckBox(dsaccess.Tbl_Access[CmbAccessName.SelectedIndex].VideoComm.ToString().Trim());
}
catch (Exception ex)
{
mesg.Error("خطا", ex.Message);
}
}