Beispiel #1
0
 public void Load_DataGridView()
 {
     dsaccess = accessclass.GetAccess();
     dsaccess.AcceptChanges();
     DataGridView.DataSource = dsaccess.Tbl_Access;
     txtAccessName.Clear();
 }
Beispiel #2
0
 private void EditAccess2_Load(object sender, EventArgs e)
 {
     CmbAccessName.Items.Clear();
     dsaccess = accessclass.GetAccess();
     for (int i = 1; i <= dsaccess.Tbl_Access.Rows.Count; i++)
     {
         CmbAccessName.Items.Add(dsaccess.Tbl_Access[i - 1].AccessName.Trim());
     }
 }
Beispiel #3
0
 public OCA.Common.DataSets.BaseInformation.Access GetAccess()
 {
     try
     {
         dsaccess.Clear();
         dsaccess = accessclass.GetAccess();
         return(dsaccess);
     }
     catch (Exception ex)
     {
         throw new Exception(ex.Message);
     }
 }
Beispiel #4
0
        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);
            }
        }
Beispiel #5
0
        public OCA.Common.DataSets.BaseInformation.Access GetAccessByUsername(string Username)
        {
            try
            {
                dsaccess.Clear();

                string AccessName = clerkclass.GetAccessNameByUsername(Username);

                dsaccess = accessclass.GetAccessByAccessname(AccessName);

                return(dsaccess);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
Beispiel #6
0
        public void ShowSelectedAccess()
        {
            try
            {
                dsaccess = accessclass.GetAccess();

                int Selected_Index = 0;

                for (int i = 0; i <= dsaccess.Tbl_Access.Rows.Count - 1; i++)
                {
                    if (dsaccess.Tbl_Access[i].AccessName.Trim() == CmbAccessName.Text.Trim())
                    {
                        Selected_Index = i;
                        break;
                    }
                }

                chkCreateMail.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].CreateMail.ToString().Trim());
                chkEditMail.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditMail.ToString().Trim());
                chkDraft.Checked                = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].Draft.ToString().Trim());
                chkMailInbox.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailInbox.ToString().Trim());
                chkMailOutbox.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailOutbox.ToString().Trim());
                chkReferMail.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ReferMail.ToString().Trim());
                chkArchiveMail.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ArchiveMail.ToString().Trim());
                chkMailHistory.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailHistory.ToString().Trim());
                chkSearchMail.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].SearchMail.ToString().Trim());
                chkInsertParvandeh.Checked      = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].InsertParvandeh.ToString().Trim());
                chkViewParvandeh.Checked        = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ViewParvandeh.ToString().Trim());
                chkMsgInbox.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MsgInbox.ToString().Trim());
                chkMsgOutbox.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MsgOutbox.ToString().Trim());
                chkSendMessage.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].SendMessage.ToString().Trim());
                chkDeletedMessage.Checked       = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].DeletedMessage.ToString().Trim());
                chkInsertImportMail.Checked     = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].InsertImportMail.ToString().Trim());
                chkViewImportMail.Checked       = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ViewImportMail.ToString().Trim());
                chkInsertExportMail.Checked     = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].InsertExportMail.ToString().Trim());
                chkViewExportMail.Checked       = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].VeiwExportMail.ToString().Trim());
                chkViewInternalMail.Checked     = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ViewInternalMail.ToString().Trim());
                chkDefineChart.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].DefineChart.ToString().Trim());
                chkViewChart.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ViewChart.ToString().Trim());
                chkCompanyInfo.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].CompanyInfo.ToString().Trim());
                chkNewSemat.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewSemat.ToString().Trim());
                chkEditSemat.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditSemat.ToString().Trim());
                chkSematGroup.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].SematGroup.ToString().Trim());
                chkNewAccess.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewAccess.ToString().Trim());
                chkEditAccess2.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditAccess2.ToString().Trim());
                chkEditAccess.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditAccess.ToString().Trim());
                chkNewClerk.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewClerk.ToString().Trim());
                chkEditClerk.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditClerk.ToString().Trim());
                chkClerkGroup.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ClerkGroup.ToString().Trim());
                chkNewExOffice.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewExOffice.ToString().Trim());
                chkEditExOffice.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditExOffice.ToString().Trim());
                chkNewAddress.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewAddress.ToString().Trim());
                chkEditAddress.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditAddress.ToString().Trim());
                chkMailNumber.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailNumber.ToString().Trim());
                chkMailTopic.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailTopic.ToString().Trim());
                chkMailCondition.Checked        = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailCondition.ToString().Trim());
                chkMailPriority.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailPriority.ToString().Trim());
                chkMailSecurity.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].MailSecurity.ToString().Trim());
                chkReferenceDescription.Checked = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ReferenceDescription.ToString().Trim());
                chkColorSetting.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ColorSetting.ToString().Trim());
                chkFaxSetting.Checked           = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].FaxSetting.ToString().Trim());
                chkPrinterSetting.Checked       = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].PrinterSetting.ToString().Trim());
                chkScanerSetting.Checked        = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].ScanerSetting.ToString().Trim());
                chkEmailSetting.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EmailSetting.ToString().Trim());
                chkBackUp.Checked               = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].Back_Up.ToString().Trim());
                chkNewReminder.Checked          = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewReminder.ToString().Trim());
                chkEditReminder.Checked         = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditReminder.ToString().Trim());
                chkNewNews.Checked              = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].NewNews.ToString().Trim());
                chkEditNews.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].EditNews.ToString().Trim());
                chkTextComm.Checked             = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].TextComm.ToString().Trim());
                chkVoiceComm.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].VoiceComm.ToString().Trim());
                chkVideoComm.Checked            = SetCheckBox(dsaccess.Tbl_Access[Selected_Index].VideoComm.ToString().Trim());
            }
            catch (Exception ex)
            {
                mesg.Error("خطا", ex.Message);
            }
        }