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