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); } }