public static IEnumerable<BillOfMaterial> GetBillOfMaterialByID(int ID)
{
Dictionary<string, object> param = new Dictionary<string, object>();
param.Add("@ID", ID);
DataTable dt = DBHelper.GetDataTable("GetBillOfMaterialByID", param, true);
if (dt != null && dt.Rows.Count > 0)
{
var boms = DBHelper.ConvertToList<BillOfMaterial>(dt);
if (boms != null)
{
foreach (var bom in boms)
{
bom.details = BillOfMaterialDetailLogic.GetRawMaterialDetails(bom.ProductID, bom.ShadeID, "");
bom.labParameters = BillOfMaterialLabParametersLogic.GetLabParamaters(bom.ID);
}
}
return boms;
}
else
return null;
}
public static BillOfMaterial GetBillOfMaterialByPSR(int ProductID, int ShadeID, string RevisionNo)
{
Dictionary<string, object> param = new Dictionary<string, object>();
param.Add("@ProductID", ProductID);
param.Add("@ShadeID", ShadeID);
param.Add("@RevisionNo", RevisionNo);
DataTable dt = DBHelper.GetDataTable("GetBillOfMaterialByPSR", param, true);
if (dt != null && dt.Rows.Count > 0)
{
var boms = DBHelper.ConvertToList<BillOfMaterial>(dt);
if (boms != null)
{
foreach (var bom in boms)
{
//bom.details = BillOfMaterialDetailLogic.GetRawMaterialDetails(bom.ProductID, bom.ShadeID, "");
bom.labParameters = BillOfMaterialLabParametersLogic.GetLabParamaters(bom.ID);
}
}
return boms.FirstOrDefault();
}
else
return null;
}
public static string PrintQCSlip(List <BillOfMaterialLabParameters> labParam, string folderPath, int ID, string CreatedBy)
{
var batchDetail = BatchLogic.GetBatchByID(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, 40f);
var pdffilename = "LabApprovalSlip" + DateTime.Now.ToString("h:mm:ss").Replace(":", "");
var writer = PdfWriter.GetInstance(document, new FileStream(folderPath + "/" + pdffilename + ".PDF", FileMode.Create));
writer.PageEvent = new QCPDFFooter(CreatedBy);
document.Open();
var widths = new float[] { 30f, 30f };
var table = new PdfPTable(2);
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("Lab Approval Slip", CommonFunction.fontTitle13));
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 (batchDetail != null)
{
cell = new PdfPCell(new Phrase("L.T.R. No : " + batchDetail.BatchNo, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
cell.HorizontalAlignment = Rectangle.ALIGN_RIGHT;
cell.Colspan = 2;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Product : " + batchDetail.ProductName, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Code : " + batchDetail.PrintName, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Shade : " + batchDetail.ShadeName, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Batch No : " + batchDetail.BatchNo, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Party : ", CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
cell.Colspan = 2;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Batch Qty : " + batchDetail.ProductionQty + " " + batchDetail.BatchUnit, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
cell = new PdfPCell(new Phrase("Mfg. Date : " + DateTime.Now, CommonFunction.fontTitle13));
cell.Border = iTextSharp.text.Rectangle.BOX;
table.AddCell(cell);
}
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
cell = new PdfPCell(new Phrase(" ", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.NO_BORDER;
cell.Colspan = table.NumberOfColumns;
table.AddCell(cell);
document.Add(table);
var i = 0;
var batchParams = BillOfMaterialLabParametersLogic.GetLabParameterByProductAndShadeID(batchDetail.ProductID, batchDetail.ShadeID);
var paramTable = new PdfPTable(4);
if (batchParams != null)
{
paramTable.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_LEFT;
paramTable.TotalWidth = (document.PageSize.Width - document.LeftMargin - document.RightMargin);
paramTable.LockedWidth = true;
paramTable.SetWidths(new float[] { 5f, 55f, 20f, 20f });
cell = new PdfPCell(new Phrase("No.", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Perticular", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Standard", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(cell);
cell = new PdfPCell(new Phrase("Observed", CommonFunction.font10));
cell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(cell);
foreach (var param in batchParams)
{
i++;
var innercell = new PdfPCell(new Phrase(" ", CommonFunction.font8));
innercell = new PdfPCell(new Phrase(i.ToString(), CommonFunction.font10Normal));
innercell.PaddingBottom = 4;
innercell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(innercell);
innercell = new PdfPCell(new Phrase(param.LabParameterName, CommonFunction.font10Normal));
innercell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(innercell);
innercell = new PdfPCell(new Phrase(!string.IsNullOrEmpty(param.Standard) ? param.Standard : param.Min + " - " + param.Max + " " + param.Unit, CommonFunction.font10Normal));
innercell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_RIGHT;
innercell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(innercell);
var observed = labParam.FirstOrDefault(x => x.ParameterID == param.ParameterID);
innercell = new PdfPCell(new Phrase(observed.Standard + " " + param.Unit, CommonFunction.font10Normal));
innercell.HorizontalAlignment = iTextSharp.text.Rectangle.ALIGN_RIGHT;
innercell.Border = iTextSharp.text.Rectangle.BOX;
paramTable.AddCell(innercell);
}
}
document.Add(paramTable);
document.Close();
return(pdffilename + ".PDF");
}