public TBLWarasaDlg(DataSources.dsRetirementCenter.TBLWarasaDataTable TBLWarasa, DataSources.dsRetirementCenter.TBLNoSarfWarsaDataTable TBLNoSarfWarsa , DataSources.dsRetirementCenter.tblvisawarsaactiveDataTable tblvisawarsaactive, DataSources.dsRetirementCenter.TBLEdafatWarsaDataTable TBLEdafatWarsa, OpenReason openReason) { InitializeComponent(); LSMSCDWarasaType.QueryableSource = new DataSources.Linq.dsTeachersUnionViewsDataContext().CDWarasaTypes; LSMSCDMashHala.QueryableSource = dsLinq.CDMashHalas; LSMSTBLDofatSarf.QueryableSource = dsLinq.TBLDofatSarfs; LSMSTBLDofatSarf2.QueryableSource = from q in dsLinq.TBLDofatSarfs where q.resarfd == true select q; LSMSCdDofaatAmanat.QueryableSource = dsLinq.CdDofaatAmanats; LSMSCDSyndicate.QueryableSource = dsLinq.CDSyndicates; LSMSCDSubCommitte.QueryableSource = dsLinq.CDSubCommittes; LSMSCDnationalty.QueryableSource = dsLinq.CDnationalties; LSMSsarfresonid.QueryableSource = dsLinq.cd_sarfresons; LSMSUsers.QueryableSource = dsLinq.Users; LSMSTBLWarasa.QueryableSource = LSMSTBLWarasa.QueryableSource = from q in dsLinq.vTBLWarasas where q.MMashatId == TBLWarasa[0].MMashatId select q; _TBLWarasa = TBLWarasa; _TBLNoSarfWarsa = TBLNoSarfWarsa; _tblvisawarsaactive = tblvisawarsaactive; _TBLEdafatWarsa = TBLEdafatWarsa; switch (openReason) { case OpenReason.Remark: gcCommands.Visible = false; tabMain.PageVisible = false; tabExtra.PageVisible = false; tabSarfExpetion.PageVisible = false; tabResarf.PageVisible = false; ReloadRemark(); return; case OpenReason.Edit: tabRemark.PageVisible = false; break; } if (TBLWarasa[0].PersonId == -1) { xtraTabPageTBLWarasaMadunea.PageVisible = false; } tbpersonName.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personName", true)); lueWarasaTypeId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "WarasaTypeId", true)); luenationaltyId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "nationaltyId", true)); tbpersonNID.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personNID", true)); depersonbirth.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personbirth", true)); tbpersonmobile.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personmobile", true)); tbpersonAddres.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personAddres", true)); ceyasref.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "yasref", true)); LUESyndicateId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "SyndicateId", true)); LUESubCommitteId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "SubCommitteId", true)); ceresponsiblesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "responsiblesarf", true)); LUEresponsiblesarfId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "responsiblesarfId", true)); tbvisa.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "visa", true)); ceActivate.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "Activate", true)); luesarfresonid.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "sarfresonid", true)); tbCode60.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "code60", true)); cewcompletesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "wcompletesarf", true)); tbwmony.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "wmony", true)); tbwestktaat.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "westktaat", true)); tbwelrasm.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "welrasm", true)); luesarfTypeId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "sarfTypeId", true)); tbestktaa.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "estktaa", true)); lueDofatSarfId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "DofatSarfId", true)); dedatesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "datesarf", true)); //edit visa for admin only tbvisa.Visible = lblvisa .Visible = Program.UserInfo.IsAdmin; ceActivate.Visible = lblActivate.Visible = Program.UserInfo.IsAdmin; tbCode60.Visible = tbCode60.Visible = Program.UserInfo.IsAdmin; if (_TBLEdafatWarsa.Count > 0) ceEnableEdafat.Checked = true; if (_TBLWarasa[0].RowState == DataRowState.Added) { tabResarf.PageVisible = false; tabSarfExpetion.PageVisible = false; } else { this.tBLReSarfWarasaTableAdapter.FillBy(this.dsRetirementCenter.TBLReSarfWarasa, _TBLWarasa[0].PersonId); if ((bool)SQLProvider.adpQry.TBLMashat_GetSarfExpetion(_TBLWarasa[0].MMashatId)) this.tBLSarfExpetionTableAdapter.FillByPersonId(this.dsRetirementCenter.TBLSarfExpetion, _TBLWarasa[0].PersonId); else tabSarfExpetion.PageVisible = false; } if (TBLWarasa[0].yasref == false && (TBLWarasa[0].IspersonNIDNull() || TBLWarasa[0].personNID.ToString() == string.Empty)) { ceyasref.Enabled = false; } //if (ceyasref.Checked) //{ // DataSources.dsQueriesTableAdapters.QueriesTableAdapter adpQ = new DataSources.dsQueriesTableAdapters.QueriesTableAdapter(); // if (adpQ.ResponsibleCount(_TBLWarasa[0].PersonId) > 0) // { // ceyasref.Enabled = false; // ceyasref.Text = "تم منع التعديل نظرا لان هذا الوريث مسئول عن ورثة اخرين"; // ceyasref.ForeColor = Color.Red; // } //} }
public TBLWarasaDlg(DataSources.dsRetirementCenter.TBLWarasaDataTable TBLWarasa, DataSources.dsRetirementCenter.TBLNoSarfWarsaDataTable TBLNoSarfWarsa, DataSources.dsRetirementCenter.TBLEdafatWarsaDataTable TBLEdafatWarsa, OpenReason openReason) { InitializeComponent(); LSMSCDWarasaType.QueryableSource = new DataSources.Linq.dsTeachersUnionViewsDataContext().CDWarasaTypes; LSMSCDMashHala.QueryableSource = dsLinq.CDMashHalas; LSMSTBLDofatSarf.QueryableSource = dsLinq.TBLDofatSarfs; LSMSCDSyndicate.QueryableSource = dsLinq.CDSyndicates; LSMSCDSubCommitte.QueryableSource = dsLinq.CDSubCommittes; LSMSTBLWarasa.QueryableSource = LSMSTBLWarasa.QueryableSource = from q in dsLinq.vTBLWarasas where q.MMashatId == TBLWarasa[0].MMashatId select q; _TBLWarasa = TBLWarasa; _TBLNoSarfWarsa = TBLNoSarfWarsa; _TBLEdafatWarsa = TBLEdafatWarsa; switch (openReason) { case OpenReason.Remark: gcCommands.Visible = false; tabMain.PageVisible = false; tabExtra.PageVisible = false; tabSarfExpetion.PageVisible = false; tabResarf.PageVisible = false; LSMSUsers.QueryableSource = dsLinq.Users; ReloadRemark(); return; case OpenReason.Edit: tabRemark.PageVisible = false; break; } tbpersonName.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personName", true)); lueWarasaTypeId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "WarasaTypeId", true)); tbpersonNID.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personNID", true)); depersonbirth.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personbirth", true)); tbpersonmobile.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personmobile", true)); tbpersonAddres.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "personAddres", true)); ceyasref.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "yasref", true)); LUESyndicateId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "SyndicateId", true)); LUESubCommitteId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "SubCommitteId", true)); ceresponsiblesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "responsiblesarf", true)); LUEresponsiblesarfId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "responsiblesarfId", true)); cewcompletesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "wcompletesarf", true)); tbwmony.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "wmony", true)); tbwestktaat.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "westktaat", true)); tbwelrasm.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLWarasa, "welrasm", true)); luesarfTypeId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "sarfTypeId", true)); tbestktaa.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "estktaa", true)); lueDofatSarfId.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "DofatSarfId", true)); dedatesarf.DataBindings.Add(new System.Windows.Forms.Binding("EditValue", _TBLEdafatWarsa, "datesarf", true)); if (_TBLEdafatWarsa.Count > 0) ceEnableEdafat.Checked = true; if (_TBLWarasa[0].RowState == DataRowState.Added) { tabResarf.PageVisible = false; tabSarfExpetion.PageVisible = false; } else { this.tBLReSarfWarasaTableAdapter.FillBy(this.dsRetirementCenter.TBLReSarfWarasa, _TBLWarasa[0].PersonId); if ((bool)SQLProvider.adpQry.TBLMashat_GetSarfExpetion(_TBLWarasa[0].MMashatId)) this.tBLSarfExpetionTableAdapter.FillByPersonId(this.dsRetirementCenter.TBLSarfExpetion, _TBLWarasa[0].PersonId); else tabSarfExpetion.PageVisible = false; } }