private void LoadSoInvoiceNumber() { try { ddlSOInvoiceNumber.Items.Clear(); DataTable dt = ClsMaster.GetSONumberApproved(); ddlSOInvoiceNumber.DataSource = dt; ddlSOInvoiceNumber.DataTextField = "Invoice_Number"; ddlSOInvoiceNumber.DataValueField = "Invoice_ID"; ddlSOInvoiceNumber.DataBind(); ddlSOInvoiceNumber.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select SO Invoice NO--", "0")); } catch (Exception Ex) { } }
private void GetMasterList(string Type, DropDownList DrpList) { try { ClsMaster ClsMas = new ClsMaster(); DataTable DT = new DataTable(); DrpList.Items.Clear(); DT = ClsMas.GetMaster(Type, Session["Id"].ToString()); DrpList.DataSource = DT; DrpList.DataValueField = "ID"; DrpList.DataTextField = "NAME"; DrpList.DataBind(); DrpList.Items.Insert(0, new ListItem("--Select Purchase Type--", "0")); } catch (Exception Ex) { } }
// Binding Sales Type Dropdown public void bindSalesType() { try { // DataTable dt = BusinessServices.Imaging_GetSalesType(); DataTable dt = ClsMaster.GetMaster_purchasetype_dropdown(); ddlSalesType.Items.Clear(); ddlSalesType.DataSource = dt; ddlSalesType.DataTextField = "purchase_name"; ddlSalesType.DataValueField = "ID"; ddlSalesType.DataBind(); ddlSalesType.Items.Insert(0, new ListItem("--Select Sales Type--", "0")); } catch (Exception ex) { throw ex; } }
public void BindMainCategory() { try { ClsMaster ClsMas = new ClsMaster(); DataTable DT = ClsMas.GetMainCategoryforSPA(); if (DT.Rows.Count > 0) { ddlType.Items.Clear(); ddlType.DataSource = DT; ddlType.DataValueField = "M_categoryid"; ddlType.DataTextField = "M_CategoryName"; ddlType.DataBind(); ddlType.Items.Insert(0, new ListItem("Select Type", "0")); } } catch (Exception) { throw; } }
private void LoadGridIGSTDetails() { DataTable DtDetails = new DataTable(); try { DtDetails = ClsMaster.GetSalesInvoiceIGSTDetailsForPDF(value); int count = DtDetails.Rows.Count; double total = Convert.ToDouble(DtDetails.Rows[count - 1]["SO_TotalAmount"].ToString()); lblTotalinrs1.Text = lblTotalinrs1.Text + AmountInWords(Convert.ToDecimal(total)); GVSalesInvcDetIGST.DataSource = DtDetails; GVSalesInvcDetIGST.DataBind(); ViewState["IGSTData"] = DtDetails; DtDetails.Dispose(); //if (ViewState["PageINdex"] != null) // GvSalesInvcDet.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); //CreateTax(); } catch (Exception ex) { } }
private void LoadGridDetails() { DataTable DtDetails = new DataTable(); try { DtDetails = ClsMaster.Get_Salesdetails(value); int count = DtDetails.Rows.Count; double total = Convert.ToDouble(DtDetails.Rows[count - 1]["SO_TotalPrice"].ToString()); lblTotalinrs.Text = lblTotalinrs.Text + AmountInWords(Convert.ToDecimal(total)); GvwSaleseOrderDetails.DataSource = DtDetails; GvwSaleseOrderDetails.DataBind(); ViewState["Data"] = DtDetails; DtDetails.Dispose(); if (ViewState["PageINdex"] != null) { GvwSaleseOrderDetails.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString()); } //CreateTax(); } catch (Exception ex) { } }
//private void LoadTax() //{ // DataTable DtTaxDetails = new DataTable(); // try // { // DtTaxDetails = ClsMaster.Get_SalesTaxdetails(value); // TableRow objTableRow = new TableRow(); // TableCell objTableCell = new TableCell(); // if(DtTaxDetails.Rows.Count>0) // { // //Code TO Add Datas in Table // for (int iRow = 0; iRow < DtTaxDetails.Rows.Count; iRow++) // { // objTableRow = new TableRow(); // for (int iColumn = 0; iColumn < DtTaxDetails.Columns.Count; iColumn++) // { // objTableCell = new TableCell(); // objTableCell.Text = DtTaxDetails.Rows[iRow][iColumn].ToString(); // // objTableCell.Width = Unit.Pixel(120); // objTableCell.Wrap = false; // objTableCell.HorizontalAlign = HorizontalAlign.Right; // objTableRow.Cells.Add(objTableCell); // } // BooksTable.Rows.Add(objTableRow); // } // } // //Code to Create HtmlPage for the Report // StringWriter sw = new StringWriter(); // HtmlTextWriter htw = new HtmlTextWriter(sw); // StringBuilder strData = new StringBuilder(string.Empty); // StringBuilder strFunction = new StringBuilder(string.Empty); // string strHTMLpath = HttpContext.Current.Server.MapPath("HtmlFile/PrintPage.htm"); // BooksTable.RenderControl(htw); // StreamWriter strWriter = new StreamWriter(strHTMLpath, false, Encoding.Default); // strData.Append("<html><body>"); // strData.Append(htw.InnerWriter.ToString()); // strData.Append("</body></html>"); // strWriter.Write(strData.ToString()); // strWriter.Close(); // strWriter.Dispose(); // } // catch (Exception ex) // { // } //} protected void btnExport_Click(object sender, EventArgs e) { Panel1.Visible = true; TabScanner.Visible = false; TabService.Visible = false; TabSupport.Visible = false; value = Convert.ToInt32(ddlSONumber.SelectedValue.ToString()); if (value != 0) { DataTable dt = ClsMaster.Get_SalesSummary(value); if (dt.Rows[0]["M_ShortName"].ToString() == "SCN" || dt.Rows[0]["M_ShortName"].ToString() == "CON" || dt.Rows[0]["M_ShortName"].ToString() == "SOF" || dt.Rows[0]["M_ShortName"].ToString() == "RN") { TabScanner.Visible = true; lblInvoiceNo.Text = dt.Rows[0]["Invoice_Number"].ToString(); lblCustomerNo.Text = dt.Rows[0]["CusutomerOrderNO"].ToString(); lblInvoiceDate.Text = dt.Rows[0]["InvocieDate"].ToString(); lblCustomerdate.Text = dt.Rows[0]["CusutomerOrderdate"].ToString(); lblDCno.Text = dt.Rows[0]["DC_no"].ToString(); lblDCDate.Text = dt.Rows[0]["DC_Date"].ToString(); lblCreditPrediod.Text = dt.Rows[0]["CreditPeriod"].ToString(); lblWarranty.Text = dt.Rows[0]["Warranty"].ToString(); lblCustVAT.Text = dt.Rows[0]["VATCST"].ToString(); lblCustPan.Text = dt.Rows[0]["PAN"].ToString(); lblCustSerTax.Text = dt.Rows[0]["ServiceTaxNumber"].ToString(); } else if (dt.Rows[0]["M_ShortName"].ToString() == "SER") { TabService.Visible = true; lblSerInvoiceNo.Text = dt.Rows[0]["Invoice_Number"].ToString(); lblSerCustomerNo.Text = dt.Rows[0]["CusutomerOrderNO"].ToString(); lblSerInvoiceDate.Text = dt.Rows[0]["InvocieDate"].ToString(); lblSerContractDate.Text = dt.Rows[0]["CusutomerOrderdate"].ToString(); lblSerCreditPeriod.Text = dt.Rows[0]["CreditPeriod"].ToString(); lblSerCustVAT.Text = dt.Rows[0]["VATCST"].ToString(); lblSerCustPAN.Text = dt.Rows[0]["PAN"].ToString(); lblSerCustSerTax.Text = dt.Rows[0]["ServiceTaxNumber"].ToString(); } else if (dt.Rows[0]["M_ShortName"].ToString() == "SUP") { TabSupport.Visible = true; lblSupInvocieNO.Text = dt.Rows[0]["Invoice_Number"].ToString(); lblSupCustomerNo.Text = dt.Rows[0]["CusutomerOrderNO"].ToString(); lblSupInvoicedate.Text = dt.Rows[0]["InvocieDate"].ToString(); lblSupContractDate.Text = dt.Rows[0]["CusutomerOrderdate"].ToString(); lblSupCreditPeriod.Text = dt.Rows[0]["CreditPeriod"].ToString(); lblSupWarranty.Text = dt.Rows[0]["Warranty"].ToString(); lblSupVAT.Text = dt.Rows[0]["VATCST"].ToString(); lblSupPAN.Text = dt.Rows[0]["PAN"].ToString(); lblSupSerTax.Text = dt.Rows[0]["ServiceTaxNumber"].ToString(); } lbl_Ship_Address.Text = dt.Rows[0]["ShippingAddress"].ToString(); lbl_Bill_Address.Text = dt.Rows[0]["BillingAddress"].ToString(); LoadGridDetails(); // LoadTax(); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=SalesTaxInvoice.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); // GvwSaleseOrderDetails.HeaderRow.Style.Add("width", "10%"); GvwSaleseOrderDetails.HeaderRow.Style.Add("font-size", "10px"); GvwSaleseOrderDetails.Style.Add("font-size", "8px"); //for (int i = 0; i <= GvwSaleseOrderDetails.Rows.Count - 1; i++) //{ // if (GvwSaleseOrderDetails.Rows[i].Cells[0].Text == "") // { // GvwSaleseOrderDetails.Rows[i].BackColor = System.Drawing.Color.DarkRed; // } //} Panel1.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); // Response.End(); HttpContext.Current.Response.Flush(); HttpContext.Current.Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest(); Panel1.Visible = false; LoadSoNumber(); } else { Panel1.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select SO Number.');</script>", false); } //ddlPonumber.SelectedItem.Value = "-1"; }