private void btnSave_Click(object sender, EventArgs e)
{
if (lueDofatSarfAId.EditValue == null || lueMMashatId.EditValue == null)
return;
//Get Information About Warasa
DataSources.dsRetirementCenter.TBLWarasaDataTable tbl = adpWarasa.GetDataByMMashatId(Convert.ToInt32(lueMMashatId.EditValue));
DataSources.dsRetirementCenter.TBLNoSarfWarsaDataTable NoSarfTbl = new DataSources.dsRetirementCenter.TBLNoSarfWarsaDataTable();
DateTime ServerDate = SQLProvider.ServerDateTime();
foreach (DataSources.dsRetirementCenter.TBLBeanWarsaRow row in dsRetirementCenter.TBLBeanWarsa)
{
row.datein = ServerDate;
row.userin = Program.UserInfo.UserId;
if (!row.deleted)
continue;
//Check if Yasref need to update or not
DataSources.dsRetirementCenter.TBLWarasaRow Person = tbl.FindByPersonId(row.PersonId);
if (Person.yasref == false)
continue;
// Change Yasref in TBLNoSarfWarsa Table
DataSources.dsRetirementCenter.TBLNoSarfWarsaRow ChangeSarfInfo = NoSarfTbl.NewTBLNoSarfWarsaRow();
ChangeSarfInfo.datehala = row.Beandate;
ChangeSarfInfo.datein = ServerDate;
string remak = string.Empty;
if (row.deleted)
remak = "ايقاف طبقا لبيان معاش بتاريخ " + row.Beandate.ToShortDateString();
else
remak = "تفعيل طبقا لبيان معاش بتاريخ " + row.Beandate.ToShortDateString();
ChangeSarfInfo.halarem = remak;
ChangeSarfInfo.PersonId = row.PersonId;
ChangeSarfInfo.userin = Program.UserInfo.UserId;
ChangeSarfInfo.yasref = !row.deleted;
NoSarfTbl.AddTBLNoSarfWarsaRow(ChangeSarfInfo);
adpUpdateNoSarf.Update(ChangeSarfInfo);
//Update Yaster in TBLWarasa Table
adpWarasa.UpdateQueryYasrefByPersonId(ChangeSarfInfo.yasref, ChangeSarfInfo.PersonId);
}
try
{
tBLBeanWarsaTableAdapter.Update(dsRetirementCenter.TBLBeanWarsa);
Program.ShowMsg("تم الحفظ", false, this, true);
New();
}
catch (Exception ex)
{
msgDlg.Show("لم يتم الحفظ " + Environment.NewLine + ex.Message, msgDlg.msgButtons.Close);
}
}
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;
}
}
