public static IEnumerable <Product> GetProductByID(int ID)
{
Dictionary <string, object> param = new Dictionary <string, object>();
param.Add("@ID", ID);
DataTable dt = DBHelper.GetDataTable("GetProductByID", param, true);
if (dt != null && dt.Rows.Count > 0)
{
var products = DBHelper.ConvertToList <Product>(dt);
if (products != null)
{
foreach (var product in products)
{
var shades = ShadeLogic.GetShadeByProductID(product.ID);
if (shades != null)
{
product.Shades = shades.ToList();
}
var packings = PackingLogic.GetPackingByProductID(product.ID);
if (packings != null)
{
product.Packings = packings.ToList();
}
product.Parties = ProductPartyLogic.GetPartiesForProduct(product.ID);
}
}
return(products);
}
else
{
return(null);
}
}
public static string Print(int ID, string folderPath, string CreatedBy)
{
var dispatch = GetDispatchByID(ID).FirstOrDefault();
var order = OrderLogic.GetOrderByID(dispatch.OrderID).FirstOrDefault();
var address = PartyAddressLogic.GetAddressById(dispatch.DeliveryAddressID);
var dispatchDetail = GetDispatchDetailByDispatchID(ID);
bool exists = Directory.Exists(folderPath);
if (!exists)
{
Directory.CreateDirectory(folderPath);
}
DirectoryInfo info = new DirectoryInfo(folderPath);
FileInfo[] files = info.GetFiles().Where(p => p.CreationTime <= DateTime.Now.AddDays(-1)).ToArray();
foreach (var file in files)
{
file.Delete();
}
var document = new iTextSharp.text.Document(PageSize.A4, 30f, 30f, 0f, 250f);
var pdffilename = "Dispatch" + DateTime.Now.ToString("h:mm:ss").Replace(":", "");
var writer = PdfWriter.GetInstance(document, new FileStream(folderPath + "/" + pdffilename + ".PDF", FileMode.Create));
document.Open();
var widths = new float[] { 15f, 30f, 10f, 60f };
var table = new PdfPTable(4);
table.HeaderRows = 6;
table.HorizontalAlignment = 0;
table.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin;
table.LockedWidth = true;
table.SetWidths(widths);
table.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;
var cell = new PdfPCell(new Phrase("MEHUL ELECTRO INSULATING INDUSTRIES", CommonFunction.fontTitle17));
cell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("2610/A, Ph-4, G.I.D.C., Vatva, Ahmedabad 382 445", CommonFunction.font10));
cell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Phone : 2584 2331/2, Fax: 2584 0356", CommonFunction.font10));
cell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Email : [email protected], [email protected]", CommonFunction.font10));
cell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_CENTER;
cell.Border = iTextSharp.text.Rectangle.MARKED;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
if (dispatch != null)
{
cell = new PdfPCell(new Phrase(dispatch.PartyName, CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 2;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Challan No :" + dispatch.DONo, CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 2;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(address.Address1 + "," + address.Address2 + "," + address.Address3 + "," + address.City + "," + address.State, CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
cell.Colspan = 2;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Challan Date :" + dispatch.DODate.ToString("dd/MM/yyyy"), CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
cell.Colspan = 2;
table.AddCell(cell);
var detailTable = new PdfPTable(8);
detailTable.HorizontalAlignment = 0;
detailTable.TotalWidth = document.PageSize.Width - document.LeftMargin - document.RightMargin;
detailTable.LockedWidth = true;
var detailWidths = new[] { 5f, 35f, 16f, 10f, 8f, 8f, 10f, 8f };
detailTable.SetWidths(detailWidths);
detailTable.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell = new PdfPCell(new Phrase("Sr.", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Product", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Shade", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Packing", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Qty", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Ltr", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
//cell = new PdfPCell(new Phrase("Drum/Box", CommonFunction.font10));
//cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
//cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
//detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Rate", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Per", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER;
detailTable.AddCell(cell);
decimal i = 1, totalQty = 0, totalLtr = 0, totalRate = 0;
foreach (var detail in dispatchDetail)
{
var product = ProductLogic.GetProductByID(detail.ProductID).FirstOrDefault();
var packing = PackingLogic.GetPackingByID(detail.PackingID).FirstOrDefault();
cell = new PdfPCell(new Phrase(i.ToString(), CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(detail.ProductName + " (" + product.PrintName + ")", CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(detail.ShadeName, CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(detail.PackingName, CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(detail.Qty, CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(Convert.ToString(Convert.ToDecimal(detail.Qty) * Convert.ToDecimal(packing.ConversionFactorWithLtr)), CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
//decimal drumCount = 0;
//cell = new PdfPCell(new Phrase(drumCount.ToString(), CommonFunction.font10Normal));
//cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
//cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
//detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(detail.Rate, CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(product.ProuctUnitName, CommonFunction.font10Normal));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
detailTable.AddCell(cell);
i++;
totalQty += Convert.ToDecimal(detail.Qty);
totalLtr += Convert.ToDecimal(detail.Qty) * Convert.ToDecimal(packing.ConversionFactorWithLtr);
//totalDrum += drumCount;
totalRate += Convert.ToDecimal(detail.Rate);
}
writer.PageEvent = new DispatchFooter(dispatch.DONo, dispatch.DODate, totalQty.ToString(), totalLtr.ToString(), dispatch.PartyName, address.Address1);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 8;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 8;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Totals : ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
cell.Colspan = 4;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(totalQty.ToString(), CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(totalLtr.ToString(), CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
//cell = new PdfPCell(new Phrase(totalDrum.ToString(), CommonFunction.font10));
//cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
//cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
//detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase(totalRate.ToString(), CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(new Phrase("", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOTTOM_BORDER | iTextSharp.text.Rectangle.TOP_BORDER;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
detailTable.AddCell(cell);
cell = new PdfPCell(detailTable);
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 4;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 4;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = 4;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
table.AddCell(cell);
document.Add(table);
}
document.Close();
return(pdffilename + ".PDF");
}