protected void Btn_Sodor_Click(object sender, EventArgs e) { if (Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.Tb_InquiryType.xInqType.Contains("بانک") && n.xDedId_fk == Tb_Dead1.xDedId_pk) != null) { Lbl_Msg.Text = "!استعلام صادر گردیده است"; Lbl_Msg.Visible = true; Lbl_Msg.ForeColor = System.Drawing.Color.Red; return; } Tb_InquiryType Tb_InquiryType1 = Lts_Inherited.Tb_InquiryTypes.SingleOrDefault(n => n.xInqType.Contains("بانک")); Tb_Inquiry Tb_Inquiry1 = new Tb_Inquiry(); Tb_Inquiry1.Tb_Dead = Tb_Dead1; //Tb_Inquiry1.xInqDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString(); Tb_Inquiry1.xInqDate = Tdp_InqDate.Date; Tb_Inquiry1.xInqRegNo = Txt_InqNo.Text; Tb_Inquiry1.Tb_InquiryType = Tb_InquiryType1; Lts_Inherited.Tb_Inquiries.InsertOnSubmit(Tb_Inquiry1); try { Lts_Inherited.SubmitChanges(); Session["Bank_DeadId"] = Tb_Dead1.xDedId_pk.ToString(); Session["Bank_InqDate"] = Tb_Inquiry1.xInqDate; Session["Bank_InqNo"] = Tb_Inquiry1.xInqRegNo; Session["Bank_Name"] = Txt_BankName.Text; Response.Redirect("~/Int_Inquiries/Bank/Rpt_Bank.aspx", true); } catch { Alarm.ShowMesseage("!خطا", this.Page); } }
protected void Btn_Sodor_Click(object sender, EventArgs e) { if (Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.Tb_InquiryType.xInqType.Contains("مالیات") && n.xDedId_fk == Tb_Dead1.xDedId_pk) != null) { Lbl_Msg.Text = "!استعلام صادر گردیده است"; Lbl_Msg.Visible = true; Lbl_Msg.ForeColor = System.Drawing.Color.Red; return; } Tb_InquiryType Tb_InquiryType1 = Lts_Inherited.Tb_InquiryTypes.SingleOrDefault(n => n.xInqType.Contains("مالیات")); Tb_Inquiry Tb_Inquiry1 = new Tb_Inquiry(); Tb_Inquiry1.Tb_Dead = Tb_Dead1; //Tb_Inquiry1.xInqDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString(); Tb_Inquiry1.xInqDate = Tdp_InqDate.Date; Tb_Inquiry1.xInqRegNo = Txt_InqNo.Text; Tb_Inquiry1.Tb_InquiryType = Tb_InquiryType1; Lts_Inherited.Tb_Inquiries.InsertOnSubmit(Tb_Inquiry1); foreach (ListItem EstItem in Chk_Estates.Items) { if (EstItem.Selected) { Tb_InqEstate Tb_InqEstate1 = new Tb_InqEstate(); Tb_InqEstate1.Tb_Inquiry = Tb_Inquiry1; Tb_InqEstate1.xEstId_fk = int.Parse(EstItem.Value); Lts_Inherited.Tb_InqEstates.InsertOnSubmit(Tb_InqEstate1); } } try { Lts_Inherited.SubmitChanges(); Session["Office_DeadId"] = Tb_Dead1.xDedId_pk.ToString(); Session["Office_InqDate"] = Tb_Inquiry1.xInqDate; Session["Office_InqNo"] = Tb_Inquiry1.xInqRegNo; Session["Office_Name"] = Txt_Office.Text; Session["Office_EstateId"] = null; foreach (ListItem EstItem in Chk_Estates.Items) { if (EstItem.Selected) { Session["Office_EstateId"] += EstItem.Value + "&"; } } Response.Redirect("~/Int_Inquiries/TaxOffice/Rpt_TaxOffice.aspx", true); } catch { Alarm.ShowMesseage("!خطا", this.Page); } }
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_Sodor_Click(object sender, EventArgs e) { if (Lts_Inherited.Tb_Inquiries.SingleOrDefault(n => n.Tb_InquiryType.xInqType.Contains("اسناد") && n.xDedId_fk == Tb_Dead1.xDedId_pk) != null) { Lbl_Msg.Text = "!استعلام صادر گردیده است"; Lbl_Msg.Visible = true; Lbl_Msg.ForeColor = System.Drawing.Color.Red; return; } Tb_InquiryType Tb_InquiryType1 = Lts_Inherited.Tb_InquiryTypes.SingleOrDefault(n => n.xInqType.Contains("اسناد")); Tb_Inquiry Tb_Inquiry1 = new Tb_Inquiry(); Tb_Inquiry1.Tb_Dead = Tb_Dead1; //Tb_Inquiry1.xInqDate = Class_ShamsiDateTime.MilladiToShamsi(DateTime.Now.Date).ToString(); Tb_Inquiry1.xInqDate = Tdp_InqDate.Date; Tb_Inquiry1.xInqRegNo = Txt_InqNo.Text; Tb_Inquiry1.Tb_InquiryType = Tb_InquiryType1; Lts_Inherited.Tb_Inquiries.InsertOnSubmit(Tb_Inquiry1); foreach (ListItem EstItem in Chk_Estates.Items) { if (EstItem.Selected) { Tb_InqEstate Tb_InqEstate1 = new Tb_InqEstate(); Tb_InqEstate1.Tb_Inquiry = Tb_Inquiry1; Tb_InqEstate1.xEstId_fk = int.Parse(EstItem.Value); Lts_Inherited.Tb_InqEstates.InsertOnSubmit(Tb_InqEstate1); } } try { Lts_Inherited.SubmitChanges(); Session["Asnad_DeadId"] = Tb_Dead1.xDedId_pk.ToString(); Session["Asnad_EstateId"] = null; Session["Asnad_InqDate"] = Tdp_InqDate.Date; Session["Asnad_InqNo"] = Txt_InqNo.Text; foreach (ListItem EstItem in Chk_Estates.Items) { if (EstItem.Selected) { Session["Asnad_EstateId"] += EstItem.Value + "&"; } } } catch { Alarm.ShowMesseage("!خطا", this.Page); } 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; Lbl_Msg.Text = "استعلام صادر گردید "; Lbl_Msg.Visible = true; Lbl_Msg.ForeColor = System.Drawing.Color.Green; Txt_InqNo.Text = ""; Tdp_InqDate.Text = ""; foreach (ListItem item in Chk_Estates.Items) { item.Selected = false; } }