protected void Btn_Search_Click(object sender, EventArgs e)
{
ResetControls();
if (TxtNationalcode.Text.Trim() == "")
{
Lbl_Msg.Text = "کد ملی را وارد نمایید!";
Lbl_Msg.ForeColor = System.Drawing.Color.Red;
Lbl_Msg.Visible = Visible;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
Tb_Dead2 = Lts_Inherited.Tb_Deads.SingleOrDefault(d => d.xDedNationalCode == TxtNationalcode.Text);
if (Tb_Dead2 == null)
{
Lbl_Msg.Text = "کد ملی وجود ندارد!";
Lbl_Msg.ForeColor = System.Drawing.Color.Red;
Lbl_Msg.Visible = Visible;
return;
}
List <Tb_Heir> Lst_Tb_Heir = Lts_Inherited.Tb_Heirs.Where(n => n.xDedId_fk == Tb_Dead2.xDedId_pk).ToList();
foreach (Tb_Heir item in Lst_Tb_Heir)
{
Tb_Person Tb_Person1 = Lts_Inherited.Tb_Persons.Single(n => n.xPrsId_pk == item.xPrsId_fk);
Chk_Heirs.Items.Add(new ListItem(Tb_Person1.xPrsName + " " + Tb_Person1.xPrsFamily, Tb_Person1.xPrsId_pk.ToString()));
}
List <Tb_Estate> Lst_Estates = Lts_Inherited.Tb_Estates.Where(n => n.xDedId_fk == Tb_Dead2.xDedId_pk).ToList();
foreach (Tb_Estate item in Lst_Estates)
{
Chk_Estates.Items.Add(new ListItem(item.xEstType, item.xEstId_pk.ToString()));
}
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
if (Txt_BirthDate.Text == "__/__/____")
{
Alarm1.ShowMesseage("!تاریخ را صحیح وارد نمایید", this.Page);
return;
}
int int_Year = int.Parse(Txt_BirthDate.Text.Substring(0, 4));
int int_Mounth = int.Parse(Txt_BirthDate.Text.Substring(5, 2));
int int_Day = int.Parse(Txt_BirthDate.Text.Substring(8, 2));
if (int_Year < 1300 || int_Year > 1400 || int_Mounth == 00 || int_Mounth > 12 || int_Day == 00 || int_Day > 31)
{
Alarm1.ShowMesseage("!تاریخ را صحیح وارد نمایید", this.Page);
return;
}
if (Txt_Klasse.Text.Trim() == "")
{
RequiredFieldValidator9.Validate();
return;
}
if (Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xClass == Txt_Klasse.Text & n.xHozeh == Txt_Hozeh.Text) != null)
{
DedId = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xHozeh == Txt_Hozeh.Text & n.xClass == Txt_Klasse.Text).xDedId_fk;
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId);
Tb_PersonExist = Lts_Inherited.Tb_Persons.SingleOrDefault(n => n.xPrsNationalCode == Txt_PNationalCode.Text.Trim());
if (Hfld_Command.Value == "Save")
{
try
{
Tb_Person1 = new Tb_Person();
if (Tb_PersonExist != null)
{
////کنترل شخص ثبت شده
Tb_Heir1 = Lts_Inherited.Tb_Heirs.SingleOrDefault(n => n.xDedId_fk == DedId && n.xPrsId_fk == Tb_PersonExist.xPrsId_pk);
if (Tb_Heir1 != null)
{
Alarm1.ShowMesseage("این شخص قبلا بعنوان وارث در این پرونده ثبت گردیده است!", this.Page);
return;
}
Tb_Person1 = Tb_PersonExist;
Tb_Person1.xPrsIsDeleted_ = false;
}
else
{
Tb_Person1.xPrsFName = Txt_PFirsName.Text;
Tb_Person1.xPrsLName = Txt_PLastName.Text;
Tb_Person1.xPrsFatherName = TxtPFatherName.Text;
Tb_Person1.xPrsBirthDate = Txt_BirthDate.Text;
Tb_Person1.xPrsBirthPlace = Txt_PBirthPlace.Text;
Tb_Person1.xPrsIdNo = Txt_PIdNo.Text;
Tb_Person1.xPrsIssuancePalce = Txt_PSoodorPlace.Text;
Tb_Person1.xPrsNationalCode = Txt_PNationalCode.Text;
Tb_Person1.xPrsPostalCode = Txt_PCodPosti.Text;
Tb_Person1.xPrsTel = Txt_PTel.Text;
if (Rbtn_Sex.SelectedValue == "male")
{
Tb_Person1.xPrsSex = "male";
}
else
{
Tb_Person1.xPrsSex = "fmale";
}
Tb_Person1.xPrsAddrress = Txt_PAddrress.Text;
Lts_Inherited.Tb_Persons.InsertOnSubmit(Tb_Person1);
}
Tb_Heir1 = new Tb_Heir();
Tb_Heir1.Tb_Dead = Tb_Dead1;
Tb_Heir1.Tb_Person = Tb_Person1;
Tb_Heir1.xRtoId_fk = int.Parse(Ddl_Ratio.SelectedValue);
Tb_Heir1.xIsApplicant_ = false;
Lts_Inherited.Tb_Heirs.InsertOnSubmit(Tb_Heir1);
Lts_Inherited.SubmitChanges();
Alarm1.ShowMesseage("!عملیات ذخیره با موفقیت انجام شد", this.Page);
//Btn_New.Visible = true;
NewReg();
Lst_Heris = Lts_Inherited.Tb_Heirs.Where(n => n.xDedId_fk == DedId).Select(n => n.Tb_Person).ToList();
Gvw_Heris.DataSource = Lst_Heris;
Gvw_Heris.DataBind();
Gvw_Heris.Visible = true;
}
catch
{
Alarm1.ShowMesseage("!خطا", this.Page);
}
}
else if (Hfld_Command.Value == "Edit")
{
try
{
if (Tb_Person1.xPrsNationalCode != Txt_PNationalCode.Text && Tb_PersonExist != null)
{
Tb_Heir1 = Lts_Inherited.Tb_Heirs.SingleOrDefault(n => n.xDedId_fk == DedId && n.xPrsId_fk == Tb_PersonExist.xPrsId_pk);
if (Tb_Heir1 != null)
{
Alarm1.ShowMesseage("این شخص قبلا بعنوان وارث در این پرونده ثبت گردیده است!", this.Page);
return;
}
}
Tb_Person1.xPrsFName = Txt_PFirsName.Text;
Tb_Person1.xPrsLName = Txt_PLastName.Text;
Tb_Person1.xPrsFatherName = TxtPFatherName.Text;
Tb_Person1.xPrsBirthDate = Txt_BirthDate.Text;
Tb_Person1.xPrsBirthPlace = Txt_PBirthPlace.Text;
Tb_Person1.xPrsIdNo = Txt_PIdNo.Text;
Tb_Person1.xPrsIssuancePalce = Txt_PSoodorPlace.Text;
Tb_Person1.xPrsNationalCode = Txt_PNationalCode.Text;
Tb_Person1.xPrsPostalCode = Txt_PCodPosti.Text;
Tb_Person1.xPrsTel = Txt_PTel.Text;
if (Rbtn_Sex.SelectedValue == "male")
{
Tb_Person1.xPrsSex = "male";
}
else
{
Tb_Person1.xPrsSex = "fmale";
}
Tb_Person1.xPrsAddrress = Txt_PAddrress.Text;
Tb_Heir1.xRtoId_fk = int.Parse(Ddl_Ratio.SelectedValue);
Lts_Inherited.SubmitChanges();
Alarm1.ShowMesseage("!عملیات ویرایش با موفقیت انجام شد", this.Page);
Lst_Heris = Lts_Inherited.Tb_Heirs.Where(n => n.xDedId_fk == DedId).Select(n => n.Tb_Person).ToList();
Gvw_Heris.DataSource = Lst_Heris;
Gvw_Heris.DataBind();
Gvw_Heris.Visible = true;
NewReg();
Gvw_Heris.Visible = true;
}
catch
{
Alarm1.ShowMesseage("!خطا", this.Page);
}
}
}
else
{
Alarm1.ShowMesseage("پرونده ای وجود ندارد!", this.Page);
}
}
