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