protected void Gvw_Heris_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Tb_Person1 = Lts_Inherited.Tb_Persons.SingleOrDefault(n => n.xPrsId_pk == int.Parse(Gvw_Heris.DataKeys[e.RowIndex].Value.ToString()));
Tb_Heir1 = Lts_Inherited.Tb_Heirs.SingleOrDefault(n => n.xDedId_fk == Tb_Dead1.xDedId_pk && n.xPrsId_fk == Tb_Person1.xPrsId_pk);
Lts_Inherited.Tb_Heirs.DeleteOnSubmit(Tb_Heir1);
try
{
Lts_Inherited.SubmitChanges();
Alarm1.ShowMesseage("!عملیات حذف با موفقیت انجام شد", this.Page);
Lst_Heris = Lts_Inherited.Tb_Heirs.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk).Select(n => n.Tb_Person).ToList();
Gvw_Heris.DataSource = Lst_Heris;
Gvw_Heris.DataBind();
Gvw_Heris.Visible = true;
}
catch
{
Alarm1.ShowMesseage("!خطا", this.Page);
}
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
ResetControls();
if (Txt_Klasse.Text.Trim() == "" && !IsPostBack)
{
return;
}
if (Txt_Klasse.Text.Trim() == "")
{
Alarm1.ShowMesseage("کلاسه را وارد کنید ", this.Page);
Session["Classe"] = null;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
try
{
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.Single(n => n.xDedId_pk == DedId);
Lbl_DedName.Text = Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName;
Lbl_DedNationalcode.Text = Tb_Dead1.xDedNationalCode;
Btn_Save.Enabled = true;
Imgbtn_Sssearch.Enabled = true;
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;
Session["Classe"] = Txt_Klasse.Text.Trim();
}
catch
{
Alarm1.ShowMesseage("پرونده ای وجود ندارد!", this.Page);
Session["Classe"] = null;
Gvw_Heris.Visible = false;
Lbl_DedName.Text =
Lbl_DedNationalcode.Text = "";
}
}
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);
}
}
