public void Load_DataGridView() { dsaccess = accessclass.GetAccess(); dsaccess.AcceptChanges(); DataGridView.DataSource = dsaccess.Tbl_Access; txtAccessName.Clear(); }
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()); } }
public OCA.Common.DataSets.BaseInformation.Access GetAccess() { try { dsaccess.Clear(); dsaccess = accessclass.GetAccess(); return(dsaccess); } 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); } }
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); } }
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); } }