protected void BtnExport_Click(object sender, EventArgs e)
{
try
{
if (TxtFromDate.Text != string.Empty && TxtToDate.Text != string.Empty)
{
DateTime fromdate = Convert.ToDateTime(TxtFromDate.Text.ToString());
DateTime Todate = Convert.ToDateTime(TxtToDate.Text.ToString());
if (fromdate <= Todate)
{
DataSet ds = new DataSet();
DateTime StartDate = Convert.ToDateTime(TxtFromDate.Text);
DateTime EndDate = Convert.ToDateTime(TxtToDate.Text);
DataTable dt1 = ClsReportPurchaseOrder.Report_PurchaseOrderDetails(StartDate, EndDate);
if (dt1.Rows.Count > 0)
{
DataTable dt2 = ClsReportPurchaseOrder.Report_PurchaseOrderSummary(StartDate, EndDate);
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
ds.Tables[0].TableName = "Purchase Order Details";
ds.Tables[1].TableName = "Purchase Order Summary";
ExcelHelper.ToExcel(ds, "Purchase_Order_Register.xls", Page.Response);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('No Records Found...');</script>", false);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Todate Should be Greater than or equal to Fromdate');</script>", false);
}
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select Date...');</script>", false);
}
}
catch (Exception ex)
{ }
}
protected void btnReport_Click(object sender, EventArgs e)
{
int value = Convert.ToInt32(ddlPonumber.SelectedItem.Value.ToString());
DataRow dr = ClsReportPurchaseOrder.Report_PurchaseOrder(value).Rows[0];;
Document document = new Document(PageSize.A4, 88f, 88f, 10f, 10f);
Font NormalFont = FontFactory.GetFont("Arial", 12, Font.NORMAL, Color.BLACK);
using (System.IO.MemoryStream memoryStream = new System.IO.MemoryStream())
{
PdfWriter writer = PdfWriter.GetInstance(document, memoryStream);
Phrase phrase = null;
PdfPCell cell = null;
PdfPTable table = null;
Color color = null;
document.Open();
//Header Table
table = new PdfPTable(2);
table.TotalWidth = 500f;
table.LockedWidth = true;
table.SetWidths(new float[] { 0.3f, 0.7f });
//Company Logo
cell = ImageCell("~/img/INDECOMMIMG.bmp", 30f, PdfPCell.ALIGN_CENTER);
table.AddCell(cell);
//Company Name and Address
phrase = new Phrase();
phrase.Add(new Chunk("Microsoft Northwind Traders Company\n\n", FontFactory.GetFont("Arial", 16, Font.BOLD, Color.RED)));
phrase.Add(new Chunk("107, Park site,\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
phrase.Add(new Chunk("Salt Lake Road,\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
phrase.Add(new Chunk("Seattle, USA", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);
cell.VerticalAlignment = PdfCell.ALIGN_TOP;
table.AddCell(cell);
//Separater Line
color = new Color(System.Drawing.ColorTranslator.FromHtml("#A9A9A9"));
DrawLine(writer, 25f, document.Top - 79f, document.PageSize.Width - 25f, document.Top - 79f, color);
DrawLine(writer, 25f, document.Top - 80f, document.PageSize.Width - 25f, document.Top - 80f, color);
document.Add(table);
table = new PdfPTable(2);
table.HorizontalAlignment = Element.ALIGN_LEFT;
table.SetWidths(new float[] { 0.3f, 1f });
table.SpacingBefore = 20f;
//Employee Details
cell = PhraseCell(new Phrase("Purchase Order", FontFactory.GetFont("Arial", 12, Color.BLACK)), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
table.AddCell(cell);
cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
cell.PaddingBottom = 30f;
table.AddCell(cell);
////Photo
//cell = ImageCell(string.Format("~/photos/{0}.jpg", dr["EmployeeId"]), 25f, PdfPCell.ALIGN_CENTER);
//table.AddCell(cell);
////Name
//phrase = new Phrase();
//phrase.Add(new Chunk(dr["TitleOfCourtesy"] + " " + dr["FirstName"] + " " + dr["LastName"] + "\n", FontFactory.GetFont("Arial", 10, Font.BOLD, Color.BLACK)));
//phrase.Add(new Chunk("(" + dr["Title"].ToString() + ")", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)));
//cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);
//cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE;
//table.AddCell(cell);
//document.Add(table);
//DrawLine(writer, 160f, 80f, 160f, 690f, Color.BLACK);
//DrawLine(writer, 115f, document.Top - 200f, document.PageSize.Width - 100f, document.Top - 200f, Color.BLACK);
//table = new PdfPTable(2);
//table.SetWidths(new float[] { 0.5f, 2f });
//table.TotalWidth = 340f;
//table.LockedWidth = true;
//table.SpacingBefore = 20f;
//table.HorizontalAlignment = Element.ALIGN_RIGHT;
//Employee Id
table.AddCell(PhraseCell(new Phrase("Location:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));
table.AddCell(PhraseCell(new Phrase("000" + dr["Location"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));
cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
cell.PaddingBottom = 10f;
table.AddCell(cell);
//Address
table.AddCell(PhraseCell(new Phrase("Address:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));
phrase = new Phrase(new Chunk(dr["Location"] + "\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
phrase.Add(new Chunk(dr["Location"] + "\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
phrase.Add(new Chunk(dr["Location"] + " " + dr["Location"] + " " + dr["Location"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));
table.AddCell(PhraseCell(phrase, PdfPCell.ALIGN_LEFT));
cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
cell.PaddingBottom = 10f;
table.AddCell(cell);
//Date of Birth
table.AddCell(PhraseCell(new Phrase("Date of Birth:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));
table.AddCell(PhraseCell(new Phrase(Convert.ToDateTime(dr["PO Date"]).ToString("dd MMMM, yyyy"), FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));
cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
cell.PaddingBottom = 10f;
table.AddCell(cell);
//Phone
table.AddCell(PhraseCell(new Phrase("Phone Number:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));
table.AddCell(PhraseCell(new Phrase(dr["Location"] + " Ext: " + dr["Location"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));
cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);
cell.Colspan = 2;
cell.PaddingBottom = 10f;
table.AddCell(cell);
//Addtional Information
table.AddCell(PhraseCell(new Phrase("Addtional Information:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));
table.AddCell(PhraseCell(new Phrase(dr["Location"].ToString(), FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_JUSTIFIED));
document.Add(table);
document.Close();
byte[] bytes = memoryStream.ToArray();
memoryStream.Close();
Response.Clear();
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Disposition", "attachment; filename=PurchaseOrder.pdf");
Response.ContentType = "application/pdf";
Response.Buffer = true;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.BinaryWrite(bytes);
Response.End();
Response.Close();
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
if (ddlPonumber.SelectedIndex != 0)
{
string MainCategory = ClsPurchaseInvoice.Get_MainCategory_BasedOn_POID(Convert.ToInt64(ddlPonumber.SelectedValue.ToString()));
if (MainCategory != "Support")
{
Panel1.Visible = true;
value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString());
if (value != -1)
{
DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value);
lbl_Ponumber.Text = dt.Rows[0]["PO Number"].ToString();
lbl_PoDate.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy");
lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString();
lbl_Bill_Address.Text = dt.Rows[0]["BillingAddress"].ToString();
lbl_Ship_Address.Text = dt.Rows[0]["ShippingAddress"].ToString();
//lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString();
lbl_Term4.Text = "4. Warranty :" + dt.Rows[0]["Warranty"].ToString();
lblBillGST.Text = dt.Rows[0]["GST"].ToString();
lblBillPAN.Text = dt.Rows[0]["PAN"].ToString();
lblSPA.Text = dt.Rows[0]["SPANumber"].ToString();
// lblShipGST.Text= dt.Rows[0]["GST"].ToString();
lblShipPAN.Text = dt.Rows[0]["PAN"].ToString();
DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value);
int CategoryID = 0;
//foreach (DataRow row in DT1.Rows)
//{
//for (int i = 0; i < DT1.Rows.Count - 1; i++)
//{
// CategoryID = Convert.ToInt32(DT1.Rows[i]["catagoryid"].ToString());
//if (CategoryID == 33)
//{
//GetSalesManager();
GetSalesManagerAMC1();
//lbl_Term3.Text = "";
//}
//else
//{
// GetSalesManager();
//}
// }
//if (CategoryID == 33)
//{
//foreach (GridViewRow row in GridView1.Rows)
//{
// foreach (TableCell cell in row.Cells)
// {
// row.Cells[0].Width = 10;
// }
//}
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=PO.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.HeaderRow.Style.Add("width", "10%");
GridView1.HeaderRow.Style.Add("font-size", "10px");
GridView1.Style.Add("font-size", "8px");
Panel1.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 100f, 100f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfWriter.PageEvent = new Comman.ITextEvents();
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;
GetMasterList();
#region old code
//}
//else
//{
// Response.ContentType = "application/pdf";
// Response.AddHeader("content-disposition", "attachment;filename=PO.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");
// 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;
// GetMasterList();
//}
#endregion
}
else
{
Panel1.Visible = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false);
}
}
else
{
Panel2.Visible = true;
value = Convert.ToInt32(ddlPonumber.SelectedValue.ToString());
if (value != -1)
{
DataTable dt = ClsReportPurchaseOrder.Report_PurchaseOrder(value);
lbl_PonumberSupport.Text = dt.Rows[0]["PO Number"].ToString();
lbl_PoDateSupport.Text = Convert.ToDateTime(dt.Rows[0]["PO Date"]).ToString("dd-MM-yyyy");
lbl_PO_RaisedTO.Text = dt.Rows[0]["PO_Raise_TO"].ToString();
lbl_Bill_Address_Support.Text = dt.Rows[0]["BillingAddress"].ToString();
lbl_Ship_Address_Support.Text = dt.Rows[0]["ShippingAddress"].ToString();
lblSPA.Text = dt.Rows[0]["SPANumber"].ToString();
lblSupBilGST.Text = dt.Rows[0]["GST"].ToString();
lblSupBilPAN.Text = dt.Rows[0]["PAN"].ToString();
//lbl_Footer_Address1.Text = dt.Rows[0]["BillingAddress"].ToString();
DataTable DT1 = ClsPurchaseInvoice.Get_PurchaseOrderForInvoice(value);
foreach (DataRow row in DT1.Rows)
{
int CategoryID = Convert.ToInt32(DT1.Rows[0]["catagoryid"].ToString());
if (CategoryID == 5 || CategoryID == 20 || CategoryID == 30 || CategoryID == 31 || CategoryID == 32 || CategoryID == 33 || CategoryID == 42)
{
//GetSalesManagerSupport();
GetSalesManagerAMC();
lbl_Term3.Text = "";
}
else
{
GetSalesManagerSupport();
}
}
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=PO.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView3.HeaderRow.Style.Add("width", "10%");
GridView3.HeaderRow.Style.Add("font-size", "10px");
GridView3.Style.Add("font-size", "8px");
Panel2.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 130f, 100f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter pdfWriter = PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfWriter.PageEvent = new Comman.ITextEvents();
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();
Panel2.Visible = false;
GetMasterList();
}
else
{
Panel2.Visible = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false);
}
}
}
else
{
Panel1.Visible = false;
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('Please Select PO Number.');</script>", false);
}
}
catch (Exception ex)
{
}
//ddlPonumber.SelectedItem.Value = "-1";
}
