protected void Page_Load(object sender, EventArgs e) { try { BLAddInvoice blAddCl = new BLAddInvoice(); txtDtInvce.Text = System.DateTime.Now.ToShortDateString(); if ((HttpContext.Current.Session["LoginId"]) == null) { Response.Redirect("~/Login.aspx"); } Session["SelectProject"] = 0; if (Page.IsPostBack) { Session["dtgetselectedRecords"] = null; } SqlDataReader dr = blAddCl.getClientInvce(); if (dr.HasRows == true) { while (dr.Read()) drpdwnClientNm.Items.Add(dr.GetString(0)); drpdwnClientNm.Items.Insert(0, new ListItem("--Select--", "-1")); dr.Close(); } if (!Page.IsPostBack) { if (Request.QueryString["Id"] == "1") { clnm = Session["ClNm"].ToString(); drpdwnClientNm.SelectedValue = clnm; txtAddInvce.Text = Session["Add"].ToString(); txtPanNo.Text = Session["PAN"].ToString(); txtBillNo.Text = Session["BillNo"].ToString(); string amt = txtAmtAddInvce.Text.ToString(); Session["TotalAmount"] = amt; string ClientName = drpdwnClientNm.SelectedValue.ToString(); Session["ClientName"] = ClientName; } DataTable dt = Session["dtgetselectedRecords"] as DataTable; double amt1 = Convert.ToDouble(Session["amt"]); if (dt != null) { GdVwAddInvce.DataSource = dt; GdVwAddInvce.DataBind(); } if (dt != null) { double amtNew = 0.0; for (int i = 0; i < dt.Rows.Count; i++) { amtNew += double.Parse(dt.Rows[i].Field<string>(4)); } Session["addedamt"] = amtNew.ToString(); txtAmtAddInvce.Text = amtNew.ToString(); } SelAllCheckbox(); if (Request.QueryString["InvoiceId"] != null) { InvoiceId = int.Parse(Request.QueryString["InvoiceId"]); Session["InvoiceId"] = InvoiceId; SqlDataReader drgetInv = blAddCl.getInvoiceForUpdate(InvoiceId); if (drgetInv.HasRows == true) { while (drgetInv.Read()) { DateTime indate = drgetInv.GetDateTime(2); txtDtInvce.Text = indate.ToString("dd/MM/yyyy"); int ClId = drgetInv.GetInt32(3); Session["ClId"] = ClId.ToString(); drpdwnClientNm.SelectedValue = Session["ClientName"].ToString(); GetClientInfo(); txtAmtAddInvce.Text = drgetInv.GetDecimal(4).ToString(); txtBillNo.Text = Session["InvoiceNo"].ToString(); txtRemrk.Text = drgetInv.GetString(7); if (drgetInv.GetInt32(9) == 1) chkbxisDel.Checked = true; else chkbxisDel.Checked = false; if (drgetInv.GetInt32(10) == 1) chkbxAppInv.Checked = true; else chkbxAppInv.Checked = false; } drgetInv.Close(); } DataTable dtgetInvDet = blAddCl.GetInvoiceDetailForUpdate(InvoiceId); GdVwAddInvce.DataSource = dtgetInvDet; GdVwAddInvce.DataBind(); Session["dtgetselectedRecordsUpdate"] = dtgetInvDet; SelAllCheckbox(); } } else { lblCatchError.Text = ""; lblSelProjectMessage.Text = ""; lblResult.Text = ""; } //if (!Page.IsPostBack) //{ // if (Request.QueryString["InvoiceId"] != null) // { // InvoiceId = int.Parse(Request.QueryString["InvoiceId"]); // Session["InvoiceId"] = InvoiceId; // SqlDataReader drgetInv = blAddCl.getInvoiceForUpdate(InvoiceId); // //SqlDataReader dr = blAddCl.getClientInvce(); // //if (dr.HasRows == true) // //{ // // while (dr.Read()) // // drpdwnClientNm.Items.Add(dr.GetString(0)); // // drpdwnClientNm.Items.Insert(0, new ListItem("--Select--", "-1")); // // dr.Close(); // //} // if (Request.QueryString["Id"] == "1") // { // clnm = Session["ClNm"].ToString(); // drpdwnClientNm.SelectedValue = clnm; // txtAddInvce.Text = Session["Add"].ToString(); // txtPanNo.Text = Session["PAN"].ToString(); // txtBillNo.Text = Session["BillNo"].ToString(); // string amt = txtAmtAddInvce.Text.ToString(); // Session["TotalAmount"] = amt; // string ClientName = drpdwnClientNm.SelectedValue.ToString(); // Session["ClientName"] = ClientName; // } // DataTable dt = Session["dtgetselectedRecords"] as DataTable; // double amt1 = Convert.ToDouble(Session["amt"]); // if (dt != null) // { // GdVwAddInvce.DataSource = dt; // GdVwAddInvce.DataBind(); // double amtNew = 0.0; // for (int i = 0; i < dt.Rows.Count; i++) // { // amtNew += double.Parse(dt.Rows[i].Field<string>(4)); // } // Session["addedamt"] = amtNew.ToString(); // txtAmtAddInvce.Text = amtNew.ToString(); // } // if (drgetInv.HasRows == true) // { // while (drgetInv.Read()) // { // DateTime indate = drgetInv.GetDateTime(2); // txtDtInvce.Text = indate.ToString("dd/MM/yyyy"); // int ClId = drgetInv.GetInt32(3); // Session["ClId"] = ClId.ToString(); // drpdwnClientNm.SelectedValue = Session["ClientName"].ToString(); // GetClientInfo(); // txtAmtAddInvce.Text = drgetInv.GetDecimal(4).ToString(); // txtBillNo.Text = Session["InvoiceNo"].ToString(); // txtRemrk.Text = drgetInv.GetString(7); // if (drgetInv.GetInt32(9) == 1) // chkbxisDel.Checked = true; // else // chkbxisDel.Checked = false; // if (drgetInv.GetInt32(10) == 1) // chkbxAppInv.Checked = true; // else // chkbxAppInv.Checked = false; // } // drgetInv.Close(); // } // DataTable dtgetInvDet = blAddCl.GetInvoiceDetailForUpdate(InvoiceId); // GdVwAddInvce.DataSource = dtgetInvDet; // GdVwAddInvce.DataBind(); // Session["dtgetselectedRecordsUpdate"] = dtgetInvDet; // } // SelAllCheckbox(); //} //else //{ // //Session["dtgetselectedRecords"] = null; // lblCatchError.Text = ""; // lblSelProjectMessage.Text = ""; // lblResult.Text = ""; //} } catch (Exception ex) { lblCatchError.Text = ex.Message.ToString(); } }