protected void Btn_Search_Click(object sender, EventArgs e)
{
if (TxtNationalcode.Text.Trim() == "")
{
Lbl_Msg.Text = "کد ملی را وارد کنید!";
Lbl_Msg.ForeColor = System.Drawing.Color.Red;
Lbl_Msg.Visible = true;
return;
}
Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext();
Tb_Dead Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedNationalCode == TxtNationalcode.Text.Trim());
if (Tb_Dead1 != null)
{
Tb_File Tb_Files1 = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xDedId_fk == Tb_Dead1.xDedId_pk);
Lbl_Msg.Text = "متوفی در حوزه مالیاتی " + Tb_Files1.xHozeh + " وکلاسه " +
Tb_Files1.xClass + "دارای سابقه می باشد" + "!";
Lbl_Msg.ForeColor = System.Drawing.Color.Red;
Lbl_Msg.Visible = true;
}
else
{
Lbl_Msg.Text = "متوفی دارای سابقه نمی باشد" + "!";
Lbl_Msg.ForeColor = System.Drawing.Color.Green;
Lbl_Msg.Visible = true;
}
}
protected void Imgbtn_Sssearch_Click(object sender, ImageClickEventArgs e)
{
if (Lts_Inherited == null)
{
Lts_Inherited = new Lts_InheritedDataContext();
}
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedNationalCode == TxtNationalcode.Text.Trim());
if (Tb_Dead1 != null)
{
Txt_FirstName.Text = Tb_Dead1.xDedFName;
Txt_LastName.Text = Tb_Dead1.xDedLName;
Txt_FatherName.Text = Tb_Dead1.xDedFatherName;
//Ddl_Fday.ClearSelection();
//Ddl_FMounth.ClearSelection();
//Ddl_FYear.ClearSelection();
//Ddl_Fday.Items.FindByText(Tb_Dead1.xDedDeadDate.Substring(8, 2)).Selected = true;
//Ddl_FMounth.Items.FindByText(Tb_Dead1.xDedDeadDate.Substring(5, 2)).Selected = true;
//Ddl_FYear.Items.FindByText(Tb_Dead1.xDedDeadDate.Substring(0, 4)).Selected = true;
Txt_FotDate.Text = Tb_Dead1.xDedDeadDate;
Txt_IDNo.Text = Tb_Dead1.xDedIdNo;
Txt_SodoorPlace.Text = Tb_Dead1.xDedIssuancePlace;
Txt_DeadPlace.Text = Tb_Dead1.xDedDeadPlace;
if (Tb_Dead1.xDedSex == "male")
{
Rbtn_DSex.SelectedIndex = 0;
}
else
{
Rbtn_DSex.SelectedIndex = 1;
}
//Txt_CodeHoviati.Text = Tb_Dead1.xDedCodeHoviat;
}
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
if (Txt_Klasse.Text.Trim() == "" && !IsPostBack)
{
return;
}
if (Txt_Klasse.Text.Trim() == "")
{
Alarm.ShowMesseage("!کلاسه را وارد کنید", this.Page);
Session["Classe"] = null;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
Tb_File Tb_Files1 = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xHozeh == Txt_Hozeh.Text & n.xClass == Txt_Klasse.Text);
if (Tb_Files1 == null)
{
Alarm.ShowMesseage("!پرونده ای وجود ندارد", this.Page);
Session["Classe"] = null;
Lbl_DedName.Text =
Lbl_DedNationalcode.Text = "";
return;
}
Session["Classe"] = Txt_Klasse.Text.Trim();
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == Tb_Files1.xDedId_fk);
Lbl_DedName.Text = Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName;
Lbl_DedNationalcode.Text = Tb_Dead1.xDedNationalCode;
Btn_Sodor.Enabled = true;
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
Lts_Inherited = new Lts_InheritedDataContext();
List <Sp_DeadSearchResult> Lst_Deads =
Lts_Inherited.Sp_DeadSearch(Txt_searchFName.Text.Trim() != "" ? Txt_searchFName.Text.Trim() : "0",
Txt_searchLname.Text.Trim() != "" ? Txt_searchLname.Text.Trim() : "0",
Txt_searchNationalcode.Text.Trim() != "" ? Txt_searchNationalcode.Text.Trim() : "0",
Txt_searchClasse.Text.Trim() != "" ? Txt_searchClasse.Text.Trim() : "0",
Txt_Hozeh.Text.Trim() != "" ? Txt_Hozeh.Text.Trim() : "0").ToList();
//List<Tb_File> Lst_Files=Lts_Inherited.Tb_Files.Where(n=>
// (n.xHozeh==Txt_Hozeh.Text.Trim() ||Txt_Hozeh.Text.Trim()=="")&&
// (n.xClass==Txt_searchClasse.Text.Trim() || Txt_searchClasse.Text.Trim() == "")).ToList();
//List<Tb_Dead> Lst_Deads = Lst_Files.Where(n =>
// (n.Tb_Dead.xDedFName.Contains(Txt_searchFName.Text.Trim()) || Txt_searchFName.Text.Trim() == "") &&
// (n.Tb_Dead.xDedLName.Contains(Txt_searchLname.Text.Trim()) || Txt_searchLname.Text.Trim() == "") &&
// (n.Tb_Dead.xDedNationalCode == Txt_searchNationalcode.Text.Trim() || Txt_searchNationalcode.Text.Trim() == "") &&
// n.Tb_Dead.xDedIsDeleted_ == false).Select(n=>n.Tb_Dead).ToList();
Gvw_Dead.DataSource = null;
Gvw_Dead.DataSource = Lst_Deads;
Gvw_Dead.DataBind();
Gvw_Dead.Visible = true;
Lbl_Records.Text = Lst_Deads.Count.ToString();
Lbl_Records.Visible = true;
Lbl_Rec.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Glb_Tb_User"] == null)
{
Response.Redirect("~/Login.aspx");
}
(Master.FindControl("Lbl_Title") as Label).Text = "استعلام از بانک / موسسه";
Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext();
Tb_User Tb_User1 = Session["Glb_Tb_User"] as Tb_User;
int DedId = int.Parse(Session["Bank_DeadId"].ToString());
Tb_Dead Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId);
Rptv_InqBank.LocalReport.ReportPath = Server.MapPath("~/Int_Inquiries/Bank/Rpt_Bank.rdlc");
Rptv_InqBank.LocalReport.Refresh();
ReportParameter[] ReportParameter = new ReportParameter[8];
ReportParameter[0] = new ReportParameter("DedName", Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName);
ReportParameter[1] = new ReportParameter("dedNationalcode", Tb_Dead1.xDedNationalCode);
ReportParameter[2] = new ReportParameter("DedFotDate", Tb_Dead1.xDedDeadDate);
ReportParameter[3] = new ReportParameter("UserName", Tb_User1.xUserFName + " " + Tb_User1.xUserLName);
ReportParameter[4] = new ReportParameter("Inq_date", Session["Bank_InqDate"].ToString());
ReportParameter[5] = new ReportParameter("Inq_RegNo", Session["Bank_InqNo"].ToString());
ReportParameter[6] = new ReportParameter("Hozeh", Tb_User1.xUser_Hozeh);
ReportParameter[7] = new ReportParameter("Bank_Name", Session["Bank_Name"].ToString());
Rptv_InqBank.LocalReport.SetParameters(ReportParameter);
Rptv_InqBank.LocalReport.Refresh();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Glb_Tb_User"] == null)
{
Response.Redirect("~/Login.aspx");
}
(Master.FindControl("Lbl_Title") as Label).Text = "استعلام از اداره امور مالیاتی";
Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext();
Tb_User Tb_User1 = Session["Glb_Tb_User"] as Tb_User;
int DedId = int.Parse(Session["Office_DeadId"].ToString());
Tb_Dead Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId);
List <string> Lst_Estates = new List <string>();
Lst_Estates = Session["Office_EstateId"].ToString().Split('&').ToList();
Lst_Estates.RemoveAt(Lst_Estates.Count - 1);
List <Inq_AsnadResult> Lst_Inq_Asnad = new List <Inq_AsnadResult>();
foreach (string item in Lst_Estates)
{
Lst_Inq_Asnad.AddRange(Lts_Inherited.Inq_Asnad(DedId, int.Parse(item)));
}
Rptv_InqOffice.LocalReport.ReportPath = Server.MapPath("~/Int_Inquiries/TaxOffice/Rpt_TaxOffice.rdlc");
Rptv_InqOffice.LocalReport.Refresh();
ReportDataSource Rds = new ReportDataSource();
Rds.Name = "Inq_Office";
Rds.Value = Lst_Inq_Asnad;
Rptv_InqOffice.LocalReport.DataSources.Clear();
Rptv_InqOffice.LocalReport.DataSources.Add(Rds);
Rptv_InqOffice.LocalReport.Refresh();
Tb_User Tb_User2 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUser_Hozeh == (Tb_User1.xUser_Hozeh.Substring(0, 5) + "0"));
ReportParameter[] ReportParameter = new ReportParameter[7];
ReportParameter[0] = new ReportParameter("DedName", Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName);
ReportParameter[1] = new ReportParameter("dedNationalcode", Tb_Dead1.xDedNationalCode);
ReportParameter[2] = new ReportParameter("DedFotDate", Tb_Dead1.xDedDeadDate);
ReportParameter[3] = new ReportParameter("GroupName", Tb_User2.xUserFName + " " + Tb_User2.xUserLName);
ReportParameter[4] = new ReportParameter("Inq_date", Session["Office_InqDate"].ToString());
ReportParameter[5] = new ReportParameter("Inq_RegNo", Session["Office_InqNo"].ToString());
ReportParameter[6] = new ReportParameter("Office_Name", Session["Office_Name"].ToString());
Rptv_InqOffice.LocalReport.SetParameters(ReportParameter);
Rptv_InqOffice.LocalReport.Refresh();
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
if (Txt_Klasse.Text.Trim() == "" && !IsPostBack)
{
return;
}
if (Txt_Klasse.Text.Trim() == "")
{
Alarm.ShowMesseage("!کلاسه را وارد کنید", this.Page);
Session["Classe"] = null;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
Tb_File Tb_Files1 = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xHozeh == Txt_Hozeh.Text & n.xClass == Txt_Klasse.Text);
if (Tb_Files1 == null)
{
Alarm.ShowMesseage("!پرونده ای وجود ندارد", this.Page);
Session["Classe"] = null;
Lbl_DedName.Text =
Lbl_DedNationalcode.Text = "";
Chk_Estates.Items.Clear();
return;
}
Session["Classe"] = Txt_Klasse.Text.Trim();
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == Tb_Files1.xDedId_fk);
Lbl_DedName.Text = Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName;
Lbl_DedNationalcode.Text = Tb_Dead1.xDedNationalCode;
List <Tb_Estate> Lst_Estates = Lts_Inherited.Tb_Estates.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk).ToList();
Chk_Estates.Items.Clear();
foreach (Tb_Estate item in Lst_Estates)
{
Chk_Estates.Items.Add(new ListItem(item.Tb_EstateType.xEstType + "(" + item.xEstDescription.Substring(0, item.xEstDescription.Length < 10 ? item.xEstDescription.Length : 10) + "..." + ")", item.xEstId_pk.ToString()));
}
Btn_Sodor.Enabled = true;
List <Tb_Inquiry> Lst_Inquiries = Lts_Inherited.Tb_Inquiries.Where(n => n.Tb_InquiryType.xInqType.Contains("اسناد") &&
n.xDedId_fk == Tb_Dead1.xDedId_pk).ToList();
Gvw_InqAsnad.DataSource = Lst_Inquiries;
Gvw_InqAsnad.DataBind();
Gvw_InqAsnad.Visible = true;
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
ResetControls();
if (Txt_Klasse.Text.Trim() == "" && !IsPostBack)
{
return;
}
if (Txt_Klasse.Text.Trim() == "")
{
Alarm.ShowMesseage("کلاسه را وارد کنید ", this.Page);
Session["Classe"] = null;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
try
{
Tb_File Tb_Files1 = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xHozeh == Txt_Hozeh.Text & n.xClass == Txt_Klasse.Text);
if (Tb_Files1 == null)
{
ResetControls();
Alarm.ShowMesseage("پرونده ای وجود ندارد!", this.Page);
Gvw_Estate.Visible = false;
Lbl_DedName.Text =
Lbl_DedNationalcode.Text = "";
Session["Classe"] = null;
return;
}
Session["Classe"] = Txt_Klasse.Text.Trim();
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == Tb_Files1.xDedId_fk);
Lbl_DedName.Text = Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName;
Lbl_DedNationalcode.Text = Tb_Dead1.xDedNationalCode;
Btn_Save.Enabled = true;
Lst_Estates = Lts_Inherited.Tb_Estates.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk && n.xEstIsDeleted_ == false).ToList();
Gvw_Estate.DataSource = Lst_Estates;
Gvw_Estate.DataBind();
Gvw_Estate.Visible = true;
}
catch
{
ResetControls();
Alarm.ShowMesseage("Error", this.Page);
}
}
protected void Ibtn_Login_Click(object sender, ImageClickEventArgs e)
{
string fileName = Server.MapPath("~/App_Themes/Master/M_Images/btn/security.txt");
string line = "";
using (System.IO.StreamReader sr = new System.IO.StreamReader(fileName))
{
line = sr.ReadLine();
sr.Close();
}
if (Txt_UserName.Text == "Stop" || Txt_UserName.Text == "Start")
{
System.IO.File.WriteAllText(fileName, String.Empty);
if (line == "Stop" || line == null || line == "Start")
{
using (System.IO.StreamWriter Swr = new System.IO.StreamWriter(fileName))
{
Swr.Write(Txt_UserName.Text);
Swr.Close();
}
}
Lbl_Msg.Text = "Success!!!";
return;
}
if (line == "Stop")
{
Lbl_Msg.Text = "خطا در سیستم";
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
Tb_User1 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUserName == Txt_UserName.Text.Trim()
& n.xUserPassword == Txt_Pass.Text.Trim());
if (Tb_User1 != null)
{
//(Master.FindControl("Lbl_User") as Label).Text = Tb_User1.xUserFullName;
Session["Glb_Tb_User"] = Tb_User1;
Response.Redirect("~/Home.aspx");
}
else
{
Lbl_Msg.Text = "!نام کاربری یا رمز عبور اشتباه است";
}
}
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_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_Search_Click(object sender, EventArgs e)
{
if (Txt_Klasse.Text.Trim() == "" && !IsPostBack)
{
return;
}
ResetControls();
if (Txt_Klasse.Text.Trim() == "")
{
Alarm.ShowMesseage("کلاسه را وارد کنید ", this.Page);
Session["Classe"] = null;
return;
}
Lts_Inherited = new Lts_InheritedDataContext();
Tb_File Tb_Files1 = Lts_Inherited.Tb_Files.SingleOrDefault(n => n.xHozeh == Txt_Hozeh.Text & n.xClass == Txt_Klasse.Text);
if (Tb_Files1 == null)
{
ResetControls();
Lbl_Msg.Text = "پرونده ای وجود ندارد!";
Lbl_Msg.ForeColor = System.Drawing.Color.Red;
Lbl_Msg.Visible = true;
Session["Classe"] = null;
return;
}
Session["Classe"] = Txt_Klasse.Text.Trim();
Chk_Estates.Items.Clear();
Chk_Heirs.Items.Clear();
Chk_Estates.Enabled = true;
Chk_Heirs.Enabled = true;
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == Tb_Files1.xDedId_fk);
Lbl_DedName.Text = Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName;
Lbl_DedNationalcode.Text = Tb_Dead1.xDedNationalCode;
List <Tb_Heir> Lst_Tb_Heir = Lts_Inherited.Tb_Heirs.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk).ToList();
foreach (Tb_Heir item in Lst_Tb_Heir)
{
Chk_Heirs.Items.Add(new ListItem(item.Tb_Person.xPrsFName + " " + item.Tb_Person.xPrsLName, item.xPrsId_fk.ToString()));
}
List <Tb_Estate> Lst_Estates = Lts_Inherited.Tb_Estates.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk && n.xEstIsDeleted_ == false).ToList();
foreach (Tb_Estate item in Lst_Estates)
{
Chk_Estates.Items.Add(new ListItem(item.Tb_EstateType.xEstType + "(" + item.xEstDescription.Substring(0, item.xEstDescription.Length < 10 ? item.xEstDescription.Length : 10) + "..." + ")", item.xEstId_pk.ToString()));
}
if (Lst_Tb_Heir.Count == 0)
{
Chk_Heirs.Items.Add(new ListItem("وراث...", "0"));
Chk_Heirs.Enabled = false;
}
if (Lst_Estates.Count == 0)
{
Chk_Estates.Items.Add(new ListItem("دارایی...", "0"));
Chk_Estates.Enabled = false;
}
List <Tb_CertPay> Lst_Cert = Lts_Inherited.Tb_CertPays.Where(n => n.xDedId_fk == Tb_Dead1.xDedId_pk).ToList();
Gvw_CertPay.DataSource = Lst_Cert;
Gvw_CertPay.DataBind();
Gvw_CertPay.Visible = true;
MainTable.Rows[7].Cells[0].Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Glb_Tb_User"] == null)
{
Response.Redirect("~/Login.aspx");
}
Page.Title = "گواهی پرداخت مالیات بر ارث";
Rpt_Viw1.LocalReport.ReportPath = Server.MapPath("~/Int_Cert/Rpt_Pay.rdlc");
Rpt_Viw1.LocalReport.Refresh();
Tb_User1 = Session["Glb_Tb_User"] as Tb_User;
string Str_Nationalcode;
try
{
Lts_Inherited = new Lts_InheritedDataContext();
List <CertPay_PersonResult> Lst_CertPay_Person = new List <CertPay_PersonResult>();
List <CertPay_EstatesResult> Lst_CertPay_Estates = new List <CertPay_EstatesResult>();
List <CertPay_DeadResult> Lst_CertPay_Dead = new List <CertPay_DeadResult>();
if (Session["CrtId"] != null)
{
//List<Tb_Person> Lst_Person = Lts_Inherited.Tb_CertPersonPays.Where(n => n.xCrtId_fk == int.Parse(Session["CrtId"].ToString())).Select(n => n.Tb_Person).Distinct().ToList();
//foreach (Tb_Person item in Lst_Person)
Lst_CertPay_Person = Lts_Inherited.CertPay_Person(int.Parse(Session["CrtId"].ToString())).Distinct().ToList();
//List<Tb_Estate> Lst_Estate = Lts_Inherited.Tb_CertPersonPays.Where(n => n.xCrtId_fk == int.Parse(Session["CrtId"].ToString())).Select(n => n.Tb_Estate).Distinct().ToList();
//foreach (Tb_Estate item in Lst_Estate)
Lst_CertPay_Estates = Lts_Inherited.CertPay_Estates(int.Parse(Session["CrtId"].ToString())).Distinct().ToList();
Lst_CertPay_Dead = Lts_Inherited.CertPay_Dead(int.Parse(Session["CrtId"].ToString())).ToList();
Tb_User Tb_User2 = Lts_Inherited.Tb_Users.SingleOrDefault(n => n.xUser_Hozeh == (Tb_User1.xUser_Hozeh.Substring(0, 5) + "0"));
ReportDataSource Rds = new ReportDataSource();
Rds.Name = "CertPay_Person";
Rds.Value = Lst_CertPay_Person;
ReportDataSource Rds1 = new ReportDataSource();
Rds1.Name = "CertPay_Estates";
Rds1.Value = Lst_CertPay_Estates;
ReportDataSource Rds2 = new ReportDataSource();
Rds2.Name = "CertPay_Dead";
Rds2.Value = Lst_CertPay_Dead;
Rpt_Viw1.LocalReport.DataSources.Clear();
Rpt_Viw1.LocalReport.DataSources.Add(Rds);
Rpt_Viw1.LocalReport.DataSources.Add(Rds1);
Rpt_Viw1.LocalReport.DataSources.Add(Rds2);
Rpt_Viw1.LocalReport.Refresh();
ReportParameter[] reportParameter = new ReportParameter[22];
reportParameter[0] = new ReportParameter("Rpm_Klasse", Lst_CertPay_Dead.Select(n => n.xClass).Single());
reportParameter[1] = new ReportParameter("Rpm_SabtDate", Lst_CertPay_Dead.Select(n => n.xCrtRegDate).Single());
reportParameter[2] = new ReportParameter("Rpm_RegNo", Lst_CertPay_Dead.Select(n => n.xCrtRegNo).Single());
reportParameter[3] = new ReportParameter("Rpm_Gov", Lst_CertPay_Dead.Select(n => n.xCrtTo).Single());
reportParameter[4] = new ReportParameter("Rpm_AppNo", Lst_CertPay_Dead.Select(n => n.xAppRegNo).Single());
reportParameter[5] = new ReportParameter("Rpm_App_Date", Lst_CertPay_Dead.Select(n => n.xAppRegDate).Single());
reportParameter[6] = new ReportParameter("Rpm_PostalCode", Lst_CertPay_Person.Select(n => n.xPrsPostalCode).First());
reportParameter[7] = new ReportParameter("Rpm_ShMaliati", "");
reportParameter[8] = new ReportParameter("Rpm_Addrress", Lst_CertPay_Person.Select(n => n.xPrsAddrress).First());
reportParameter[9] = new ReportParameter("Rpm_Tel", Lst_CertPay_Person.Select(n => n.xPrsTel).First());
reportParameter[10] = new ReportParameter("Rpm_HasrNo", Lst_CertPay_Dead.Select(n => n.xAppHasrNo).Single());
reportParameter[11] = new ReportParameter("Rpm_HasrDate", Lst_CertPay_Dead.Select(n => n.xAppHasrDate).Single());
reportParameter[12] = new ReportParameter("Rpm_ShobeDadgah", Lst_CertPay_Dead.Select(n => n.xAppShobeDadgah).Single());
reportParameter[13] = new ReportParameter("Rpm_Dadgah", Lst_CertPay_Dead.Select(n => n.xAppDadgah).Single());
reportParameter[14] = new ReportParameter("Rpm_UserFullName", Lst_CertPay_Dead.Select(n => n.xUserFName).Single() + " " + Lst_CertPay_Dead.Select(n => n.xUserLName).Single());
reportParameter[15] = new ReportParameter("Rpm_OfficeNo", Lst_CertPay_Dead.Select(n => n.xOfficeNo).Single());
reportParameter[16] = new ReportParameter("Rpm_GroupTaxNo", Tb_User1.xUser_Hozeh.Substring(0, 5) + "0");
reportParameter[17] = new ReportParameter("Rpm_Taxvahed", Tb_User1.xUser_Hozeh);
reportParameter[18] = new ReportParameter("Rpm_OfficeAddrress", Lst_CertPay_Dead.Select(n => n.xOfficeAddrress).Single());
reportParameter[19] = new ReportParameter("Rpm_OfficeTel", Lst_CertPay_Dead.Select(n => n.xOfficeTel).Single());
reportParameter[20] = new ReportParameter("Rpm_OfficePostal", Lst_CertPay_Dead.Select(n => n.xOfficePostalcode).Single());
reportParameter[21] = new ReportParameter("Rpm_AdminGroup", Tb_User2.xUserFName + " " + Tb_User2.xUserLName);
Rpt_Viw1.LocalReport.SetParameters(reportParameter);
Rpt_Viw1.LocalReport.Refresh();
}
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Glb_Tb_User"] == null)
{
Response.Redirect("~/Login.aspx");
}
(Master.FindControl("Lbl_Title") as Label).Text = "استعلام از اداره ثبت اسناد و املاک";
Lts_InheritedDataContext Lts_Inherited = new Lts_InheritedDataContext();
Tb_User Tb_User1 = Session["Glb_Tb_User"] as Tb_User;
List <Inq_AsnadResult> Lst_Inq_Asnad = new List <Inq_AsnadResult>();
Tb_Dead Tb_Dead1 = new Tb_Dead();
int DedId = 0;
string Str_Inq_date = "";
string Str_Inq_RegNo = "";
if (Session["InqId"] != null)
{
List <Tb_InqEstate> Lst_Inq = Lts_Inherited.Tb_InqEstates.Where(n => n.xInqId_fk == int.Parse(Session["InqId"].ToString())).ToList();
Tb_Inquiry Tb_Inquiry1 = Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.xInqId_pk == int.Parse(Session["InqId"].ToString()));
foreach (Tb_InqEstate item in Lst_Inq)
{
Lst_Inq_Asnad.AddRange(Lts_Inherited.Inq_Asnad(Tb_Inquiry1.xDedId_fk, item.xEstId_fk));
}
Str_Inq_date = Tb_Inquiry1.xInqDate;
Str_Inq_RegNo = Tb_Inquiry1.xInqRegNo;
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == Tb_Inquiry1.xDedId_fk);
}
else
{
DedId = int.Parse(Session["Asnad_DeadId"].ToString());
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedId_pk == DedId);
List <string> Lst_Estates = new List <string>();
Lst_Estates = Session["Asnad_EstateId"].ToString().Split('&').ToList();
Lst_Estates.RemoveAt(Lst_Estates.Count - 1);
Str_Inq_date = Session["Asnad_InqDate"].ToString();
Str_Inq_RegNo = Session["Asnad_InqNo"].ToString();
foreach (string item in Lst_Estates)
{
Lst_Inq_Asnad.AddRange(Lts_Inherited.Inq_Asnad(DedId, int.Parse(item)));
}
}
Rptv_InqAsnad.LocalReport.ReportPath = Server.MapPath("~/Int_Inquiries/Asnad/Rpt_InqAsnad.rdlc");
Rptv_InqAsnad.LocalReport.Refresh();
ReportDataSource Rds = new ReportDataSource();
Rds.Name = "Inq_Asnad";
Rds.Value = Lst_Inq_Asnad;
Rptv_InqAsnad.LocalReport.DataSources.Clear();
Rptv_InqAsnad.LocalReport.DataSources.Add(Rds);
Rptv_InqAsnad.LocalReport.Refresh();
ReportParameter[] ReportParameter = new ReportParameter[7];
ReportParameter[0] = new ReportParameter("DedName", Tb_Dead1.xDedFName + " " + Tb_Dead1.xDedLName);
ReportParameter[1] = new ReportParameter("dedNationalcode", Tb_Dead1.xDedNationalCode);
ReportParameter[2] = new ReportParameter("DedFotDate", Tb_Dead1.xDedDeadDate);
ReportParameter[3] = new ReportParameter("UserName", Tb_User1.xUserFName + " " + Tb_User1.xUserLName);
ReportParameter[4] = new ReportParameter("Inq_date", Str_Inq_date);
ReportParameter[5] = new ReportParameter("Inq_RegNo", Str_Inq_RegNo);
ReportParameter[6] = new ReportParameter("Hozeh", Tb_User1.xUser_Hozeh);
Rptv_InqAsnad.LocalReport.SetParameters(ReportParameter);
Rptv_InqAsnad.LocalReport.Refresh();
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
if (Txt_FotDate.Text == "__/__/____")
{
Alarm1.ShowMesseage("!تاریخ را صحیح وارد نمایید", this.Page);
return;
}
int int_Year = int.Parse(Txt_FotDate.Text.Substring(0, 4));
int int_Mounth = int.Parse(Txt_FotDate.Text.Substring(5, 2));
int int_Day = int.Parse(Txt_FotDate.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 (Lts_Inherited == null)
{
Lts_Inherited = new Lts_InheritedDataContext();
}
string Str_Msg = "";
if (Hfld_Command.Value == "Save")
{
string class1 = "0";
Tb_Dead1 = Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedNationalCode == TxtNationalcode.Text.Trim() && n.xDedIsDeleted_ == false);
if (Tb_Dead1 != null)
{
Alarm1.ShowMesseage("!مشخصات متوفی قبلا ثبت گردیده است", this.Page);
return;
}
Tb_Dead1 = new Tb_Dead();
Tb_Dead1.xDedFName = Txt_FirstName.Text.Trim();
Tb_Dead1.xDedLName = Txt_LastName.Text.Trim();
Tb_Dead1.xDedFatherName = Txt_FatherName.Text.Trim();
Tb_Dead1.xDedDeadDate = Txt_FotDate.Text.Trim();
//Ddl_FYear.Text.Trim() + "/" + Ddl_FMounth.Text.Trim() + "/" + Ddl_Fday.Text.Trim();
Tb_Dead1.xDedDeadPlace = Txt_DeadPlace.Text.Trim();
Tb_Dead1.xDedIdNo = Txt_IDNo.Text.Trim();
Tb_Dead1.xDedIssuancePlace = Txt_SodoorPlace.Text.Trim();
Tb_Dead1.xDedNationalCode = TxtNationalcode.Text.Trim();
Tb_Dead1.xUserId_fk = Tb_User1.xUserId_pk;
Tb_Dead1.xDedRegDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString();
//Tb_Dead1.xDedCodeHoviat = Txt_CodeHoviati.Text.Trim().Trim();
if (Txt_CodAtba.Text.Trim() != "")
{
Tb_Dead1.xDedCodeAtba = Txt_CodAtba.Text.Trim();
}
if (Rbtn_DSex.SelectedValue == "male")
{
Tb_Dead1.xDedSex = "male";
}
else
{
Tb_Dead1.xDedSex = "fmale";
}
Lts_Inherited.Tb_Deads.InsertOnSubmit(Tb_Dead1);
//List<int> Lst_Class = null;
Lst_Tb_File = Lts_Inherited.Tb_Files.Where(n => n.xHozeh == Tb_User1.xUser_Hozeh &&
n.Tb_Dead.xDedIsDeleted_ == false).OrderBy(n => Convert.ToInt32(n.xClass)).ToList();
if (Lst_Tb_File.Count != 0)
{
class1 = Lst_Tb_File.LastOrDefault().xClass;
}
Tb_File1 = new Tb_File();
Tb_File1.xClass = (int.Parse(class1) + 1).ToString();
Tb_File1.Tb_Dead = Tb_Dead1;
Tb_File1.xHozeh = Txt_Hozeh.Text;
Lts_Inherited.Tb_Files.InsertOnSubmit(Tb_File1);
Str_Msg = "!عملیات ذخیره با موفقیت انجام شد";
Txt_Klasse.Text = (class1 + 1).ToString();
Session["Classe"] = Txt_Klasse.Text.Trim();
}
else if (Hfld_Command.Value == "Edit")
{
if (Lts_Inherited.Tb_Deads.SingleOrDefault(n => n.xDedNationalCode == TxtNationalcode.Text.Trim()) != null &&
Tb_Dead1.xDedNationalCode != TxtNationalcode.Text.Trim())
{
Alarm1.ShowMesseage("!مشخصات متوفی قبلا ثبت گردیده است", this.Page);
return;
}
Tb_Dead1.xDedFName = Txt_FirstName.Text.Trim();
Tb_Dead1.xDedLName = Txt_LastName.Text.Trim();
Tb_Dead1.xDedFatherName = Txt_FatherName.Text.Trim();
Tb_Dead1.xDedDeadDate = Txt_FotDate.Text.Trim();
//Ddl_FYear.Text.Trim() + "/" + Ddl_FMounth.Text.Trim() + "/" + Ddl_Fday.Text.Trim();
Tb_Dead1.xDedDeadPlace = Txt_DeadPlace.Text.Trim();
Tb_Dead1.xDedIdNo = Txt_IDNo.Text.Trim();
Tb_Dead1.xDedIssuancePlace = Txt_SodoorPlace.Text.Trim();
Tb_Dead1.xDedNationalCode = TxtNationalcode.Text.Trim();
Tb_Dead1.xUserId_fk = Tb_User1.xUserId_pk;
Tb_Dead1.xDedRegDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString();
if (Rbtn_DSex.SelectedIndex == 0)
{
Tb_Dead1.xDedSex = "male";
}
else
{
Tb_Dead1.xDedSex = "fmale";
}
Str_Msg = "!عملیات ویرایش با موفقیت انجام شد";
}
try
{
Lts_Inherited.SubmitChanges();
Alarm1.ShowMesseage(Str_Msg, this.Page);
GetDead(Tb_Dead1.xDedId_pk);
ResetControls();
}
catch
{
Alarm1.ShowMesseage("!خطا", this.Page);
}
}
