public ActionResult CreateFeasibility(string InquiryNo)
{
ssmtbl_FeasibilityModel objFea = new ssmtbl_FeasibilityModel();
try
{
ViewData["FeasibilityCOS"] = objDrop.FeasibilityConditionOfSupply();
ViewData["FeasibilityHR"] = objDrop.FeasibilityHammerrequired();
ViewData["FeasibilityNOW"] = objDrop.FeasibilityNatureofwork();
ViewData["FeasibilityTOJ"] = objDrop.FeasibilityTypeofjob();
ViewData["FeasibilityLP"] = objDrop.FeasibilityLubricantPreferred();
ViewData["FeasibilityHT"] = objDrop.FeasibilityHeatTreatment();
ViewData["FeasibilitySA"] = objDrop.FeasibilityStandardApplicable();
ViewData["FeasibilityMG"] = objDrop.FeasibilityMaterialGrade();
ViewData["Section"] = objDrop.CuutingCalculation();
if (InquiryNo != "" || InquiryNo != null)
{
objFea.InquiryNo = Convert.ToInt32(InquiryNo);
objFea = objFData.GetOneFeasibility(Convert.ToInt32(InquiryNo));
if (objFea.FeasibilityId > 0)
{
//objFea.ssmtbl_Feasibility_OperationsInvolvedModel = objFData.GetOperationInvolvedByFeasId(Convert.ToInt32(objFea.FeasibilityId));
//objFea.ssmtbl_Feasibility_RawMaterialTestModel = objFData.GetFeasibilityRawMaterialByFeasId(Convert.ToInt32(objFea.FeasibilityId));
objFea.ssmtbl_Feasibility_OperationsInvolvedModel = objGFunc.FeasibilityOperationsInvolved();
objFea.ssmtbl_Feasibility_RawMaterialTestModel = objGFunc.FeasibilityRawMaterial();
objFea.ssmtbl_Feasibility_MultiVendorModel = objGFunc.FeasibilityRMVendors();
ViewData["Fisibilityprferedvendor"] = objFData.Fisibilityprferedvendor(objFea.FeasibilityId);
}
else
{
objFea.ssmtbl_Feasibility_RawMaterialTestModel = objGFunc.FeasibilityRawMaterial();
objFea.ssmtbl_Feasibility_OperationsInvolvedModel = objGFunc.FeasibilityOperationsInvolved();
objFea.ssmtbl_Feasibility_MultiVendorModel = objGFunc.FeasibilityRMVendors();
}
}
ViewData["recommVendor"] = objFData.GetRecommendedVendorByFeasId(objFea.FeasibilityId);
ViewData["rmtest"] = objFData.GetFeasibilityRawMaterialByFeasId(objFea.FeasibilityId);
ViewData["opsInvolved"] = objFData.GetOperationInvolvedByFeasId(objFea.FeasibilityId);
ViewData["opsInvolvedgetsequentially"] = objFData.opsInvolvedgetsequentially(objFea.FeasibilityId);
ViewData["opsInvolvedIDgetsequentially"] = objFData.opsInvolvedIDgetsequentially(objFea.FeasibilityId);
ViewData["FisibilityRawmaterialtestsequentially"] = objFData.FisibilityRawmaterialtestsequentially(objFea.FeasibilityId);
ViewData["FisibilityRawmaterialtestIDsequentially"] = objFData.FisibilityRawmaterialtestIDsequentially(objFea.FeasibilityId);
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(View(objFea));
}
// GET: Quotation
public ActionResult NewQuotation(string id)
{
ssmtbl_QuotationModel modelQuotation = new ssmtbl_QuotationModel();
ssmtbl_InquiryModel modelInquiry = new ssmtbl_InquiryModel();
ssmtbl_FeasibilityModel modelFeasibility = new ssmtbl_FeasibilityModel();
ssmtbl_QuotationModel latestQuotation = objQuotation.GetLetestQuotationID(Convert.ToInt32(id));
try
{
if (id == "" || ModelState.IsValid == false)
{
return(View(modelQuotation));
}
modelInquiry = objInqData.GetOneInquiry(Convert.ToInt32(id));
if (latestQuotation.id == 0 || modelInquiry.Status == "Feasibility Done")
{
if (modelInquiry != null)
{
modelQuotation.InquiryNo = modelInquiry.InquiryNo;
//modelQuotation.QuotationNo = "Q-" + modelInquiry.InquiryNo;
modelQuotation.QuotationNo = "SSM_" + StandardDateTime.GetDateTime().ToString("yy") + StandardDateTime.GetDateTime().ToString("MM") + "_" + modelInquiry.InquiryNo;
modelQuotation.PartDescription = modelInquiry.PartName;
modelQuotation.PartNo = modelInquiry.PartNo;
modelQuotation.CustomerName = modelInquiry.customerName;
modelQuotation.FileStatus = modelInquiry.Status;
}
modelFeasibility = objFesiData.GetOneFeasibility(Convert.ToInt32(id));
if (modelFeasibility != null)
{
modelQuotation.CutWeight = modelFeasibility.cutweight;
modelQuotation.NetWeight = modelFeasibility.netweight;
modelQuotation.GrossWeight = modelFeasibility.grossweight;
modelQuotation.MachainedWeight = modelFeasibility.materialweights.ToString();
modelQuotation.SectionId = Convert.ToInt64(modelFeasibility.Section); // Sharad
modelQuotation.Section = objQuotation.getSectionNane(modelFeasibility.Section); // Sharad
ViewData["fistotal"] = modelFeasibility.fisdiatotal;
string MaterialID = modelFeasibility.FeasibilityMaterialGrade.ToString();
var getMaterialGrad = objDrop.FeasibilityMaterialGrade().FirstOrDefault(m => m.Value == MaterialID);
if (getMaterialGrad != null)
{
modelQuotation.Material = getMaterialGrad.Text;
}
if (modelFeasibility.ssmtbl_Feasibility_MultiVendorModel != null)
{
ViewData["MultiVendors"] = modelFeasibility.ssmtbl_Feasibility_MultiVendorModel;
}
string HeattreatmentlID = modelFeasibility.FeasibilityHeattreatment.ToString();
var getHeattreatment = objDrop.FeasibilityHeatTreatment().FirstOrDefault(m => m.Value == HeattreatmentlID);
if (getHeattreatment != null)
{
modelQuotation.HeatTreatmentID = getHeattreatment.Value;
modelQuotation.HeatTreatmentText = getHeattreatment.Text;
}
}
}
else
{
modelQuotation = latestQuotation;
modelQuotation.PerPieceRate = modelInquiry.Qty;
modelQuotation.CuttingRate = objQuotation.GetOneCutingCalculation(Convert.ToInt32(modelQuotation.Section)).cuttingrateperpc;
// ViewData["QuotaionTermsAndCondition"] = GlobalFunction.GetSelectedQuotaionTermsAndCondition(modelQuotation.id);
modelFeasibility = objFesiData.GetOneFeasibility(Convert.ToInt32(latestQuotation.InquiryNo));
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureofWork"] = modelFeasibility.FeasibilityNatureofWork;// Sharad
}
ViewData["QuotaionTermsAndCondition"] = GlobalFunction.GetLKP_QuotaionTermsAndCondition(modelInquiry.InquiryNo);
ViewData["Allversion"] = objQuotation.GetAllversion(modelQuotation.InquiryNo);
modelQuotation.Material = objQuotation.GetMaterialGradeByID(modelFeasibility.FeasibilityMaterialGrade); // Sharad
modelQuotation.SectionId = Convert.ToInt64(modelFeasibility.Section); // Sharad
modelQuotation.Section = objQuotation.getSectionNane(modelFeasibility.Section); // Sharad
string HeattreatmentlID = modelFeasibility.FeasibilityHeattreatment.ToString();
var getHeattreatment = objDrop.FeasibilityHeatTreatment().FirstOrDefault(m => m.Value == HeattreatmentlID);
if (getHeattreatment != null)
{
modelQuotation.HeatTreatmentID = getHeattreatment.Value;
modelQuotation.HeatTreatmentText = getHeattreatment.Text;
}
ViewData["fistotal"] = modelFeasibility.fisdiatotal;
ViewData["MultiVendors"] = modelFeasibility.ssmtbl_Feasibility_MultiVendorModel;
return(View(modelQuotation));
}
modelQuotation.PerPieceRate = modelInquiry.Qty;
modelFeasibility = objFesiData.GetOneFeasibility(Convert.ToInt32(id));
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureofWork"] = modelFeasibility.FeasibilityNatureofWork;// Sharad
}
ViewData["QuotaionTermsAndCondition"] = GlobalFunction.GetLKP_QuotaionTermsAndCondition(modelInquiry.InquiryNo);
ViewData["NatureofWork"] = modelFeasibility.FeasibilityNatureofWork;// Sharad
ViewData["Allversion"] = objQuotation.GetAllversion(modelQuotation.InquiryNo);
ViewData["MultiVendors"] = modelFeasibility.ssmtbl_Feasibility_MultiVendorModel;
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(View(modelQuotation));
}
// public ActionResult QuotationPDF(string QuotationId)
public FileResult QuotationPDF(string QuotationId)
{
string filenm = "";
var fpath = "";
string contentType = "";
try
{
//string QuotationId = frm["id"].ToString();
fpath = HttpContext.Server.MapPath("~/PDFFiles/Quotation/");
ssmtbl_QuotationModel objQuot = new ssmtbl_QuotationModel();
objQuot = objQuotAppData.GetOneQuotationForApproval(QuotationId);
ssmtbl_FeasibilityModel modelFeasibility = new ssmtbl_FeasibilityModel();
modelFeasibility = objFesiData.GetOneFeasibility(Convert.ToInt32(objQuot.InquiryNo));
string str = objQuot.QuotationNo.Substring(0, 8);
filenm = str + "_" + objQuot.CustomerName + "_" + objQuot.InquiryNo + "_" + objQuot.new_Version_No + ".pdf";
Document doc = new Document(PageSize.A4, 25, 25, 10, 20);
PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(fpath + filenm, FileMode.Create));
doc.Open();
iTextSharp.text.html.simpleparser.StyleSheet styles = new iTextSharp.text.html.simpleparser.StyleSheet();
iTextSharp.text.html.simpleparser.HTMLWorker hw = new iTextSharp.text.html.simpleparser.HTMLWorker(doc);
iTextSharp.text.Image image1 = iTextSharp.text.Image.GetInstance(HttpContext.Server.MapPath("~/NewCssAndTheme/img/ssmlogo.jpg"));
image1.Alignment = iTextSharp.text.Image.ALIGN_CENTER;
image1.SetAbsolutePosition(20, 780);
image1.ScaleToFit(80f, 80f);
doc.Add(image1);
string pdfbody = "<div style='font: 10px; border= 1'>";
pdfbody += "<div style='text-align:center'>";
pdfbody += "<font size='3'>SHREE SIDDHESHWARI METAL FORGING PRIVATE LIMITED</font>";
pdfbody += "</div>";
pdfbody += "<div style='text-align:center;>";
pdfbody += "<font size='medium'>J-489/490,M.I.D.C BHOSARI, PUNE-26</font>";
pdfbody += "</div>";
pdfbody += "<div style='text-align:center;>";
pdfbody += "<font size='medium'>Email - [email protected] Tel: 020-27130120</font>";
pdfbody += "</div>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<div style='text-align:center;'>";
pdfbody += "<font size='3' font-weight='bold'>QUOTATION</font>";
pdfbody += "</div>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<div style='text-align:right; font-size: medium'>";
pdfbody += "<h4 style='text-align:right'>Quotation # " + objQuot.QuotationNo;
pdfbody += "</h4>";
//pdfbody += "<small> Revision Number:" + objQuot.new_Version_No;
pdfbody += "<small> Date: " + objQuot.CreatedOn.Date.ToString("dd-MMM-yyyy");
pdfbody += "</small>";
pdfbody += "</div>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<div style='text-align:Left; font-size: medium'>";
pdfbody += "To, <br/>" + objQuot.CustomerName;
pdfbody += "<br/>" + objQuot.address;
pdfbody += "</div>";
// pdfbody += "<table border='0' cellpadding='5' cellspacing='0'>";
//pdfbody += "<tbody >";
//pdfbody += "<tr>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Quotation Number:- " + objQuot.QuotationNo;
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Revision Number:- " + objQuot.new_Version_No;
//pdfbody += "</th>";
//pdfbody += "</tr>";
//pdfbody += "<tr>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += " ";
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Date:- " + objQuot.CreatedOn.Date.ToString("dd-MMM-yyyy");
//pdfbody += "</th>";
//pdfbody += "</tr>";
//pdfbody += "</tbody>";
//pdfbody += "</table>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<br/> <table border='0' cellpadding='3' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
//pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
//pdfbody += "<b>I</b>";
//pdfbody += "</th>";
pdfbody += "<th>";
pdfbody += "Part Description: " + objQuot.PartDescription;
pdfbody += " | Material: " + objQuot.Material + " | Customer Part No:" + objQuot.PartNo;
pdfbody += "<br/> Heat Treatment: " + objQuot.HeatTreatmentText + " | Hardness: Min: " + modelFeasibility.hardnessmin;
pdfbody += " Max: " + modelFeasibility.hardnessmax + " " + modelFeasibility.hardnessunits;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
//pdfbody = "<table border='1' cellpadding='3' cellspacing='0'>";
//pdfbody += "<tbody >";
//pdfbody += "<tr>";
//pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
//pdfbody += "<b>I</b>";
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Part Description:- " + objQuot.PartDescription + "<br />";
//pdfbody += "Material:- " + objQuot.Material + "<br />";
//pdfbody += "Customer:- " + objQuot.CustomerName + "<br />";
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Part No:- " + objQuot.PartNo + "<br />";
//pdfbody += "Heat Treatment:- " + objQuot.HeatTreatmentText + "<br />";
//pdfbody += "Min:- " + modelFeasibility.hardnessmin + " Max:- " + modelFeasibility.hardnessmax+" "+modelFeasibility.hardnessunits+"" ;
//pdfbody += "</th>";
//pdfbody += "</tr>";
//pdfbody += "</tbody>";
//pdfbody += "</table>";
pdfbody += "<table border='1' cellpadding='2' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody>";
pdfbody += "<tr>";
pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
pdfbody += "<b> I</b>";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Component Weight Details <br />";
//pdfbody += "<br />";
pdfbody += "Gross Weight (kg): " + objQuot.GrossWeight;
pdfbody += " Cut Weight (kg): " + objQuot.CutWeight;
pdfbody += " Forged Net Weight(kg): " + objQuot.NetWeight;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
pdfbody += "<table border='1' cellpadding='5' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
pdfbody += "<b>II</b>";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Raw Material Cost Details";
// table inside th
pdfbody += "<table border='1' cellpadding='2' cellspacing='0'>";
pdfbody += "<tbody>";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1' width='50%'>";
pdfbody += "Particulars";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1'>";
pdfbody += "Basic Rate (Rs/kg)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1'>";
pdfbody += "Net Cost (Rs)";
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Steel Cost";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.SteelCost;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += Convert.ToDecimal(objQuot.SteelCost * objQuot.GrossWeight).ToString("0.00");
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Transportation";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Transportation;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += Convert.ToDecimal(objQuot.Transportation * objQuot.GrossWeight).ToString("0.00");
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Total";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += Convert.ToDecimal(objQuot.SteelCost + objQuot.Transportation).ToString("0.00");
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.TotalRowMaterialCost;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
// **************
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<table border='1' cellpadding='5' cellspacing='0'style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
pdfbody += "<b>III</b>";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Conversion Rate Details <br />";
// table inside th
pdfbody += "<table border='1' cellpadding='2' cellspacing='0'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1' width='50%'>";
pdfbody += "Particulars";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1'>";
pdfbody += "Basic Rate (Rs/kg)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left' bgcolor='#f1f1f1'>";
pdfbody += "Net Cost (Rs)";
pdfbody += "</th>";
pdfbody += "</tr>";
foreach (var item in modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel)
{
if (item.Operations_Involved == 1 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Cutting (Sq In)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.CuttingSquare1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.CuttingSquare2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 2 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Forging";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Forging1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Forging1;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 3 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Heat Treatment Cost (Net Wt)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.HeatTreatment1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.HeatTreatment2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 4 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Shot Blasting (Net Wt)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.ShotBlasting1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.ShotBlasting2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 5 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "MPI";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.MPI1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.MPI2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 13 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Grinding (Per Piece)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Grinding1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Grinding2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 14 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Cold Coining (Per Piece)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.ColdCoining1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.ColdCoining2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
if (item.Operations_Involved == 15 && item.Operations_Involved_Select)
{
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Machining (Per Piece)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Machining1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.Machining2;
pdfbody += "</th>";
pdfbody += "</tr>";
}
}
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Die Maintaince Cost (Per Piece)";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.DieMaintenance1;
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.DieMaintenance2;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Total Coversion Cost";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
// pdfbody += Convert.ToDecimal(objQuot.DieMaintenance1+ objQuot.Machining1+ objQuot.ColdCoining1+ objQuot.Grinding1+ objQuot.MPI1+ objQuot.ShotBlasting1+ objQuot.HeatTreatment1 + objQuot.Forging1+ objQuot.CuttingSquare1).ToString("0.00");
pdfbody += "";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += objQuot.TotalConverstionCost;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
// **************
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<table border='1' cellpadding='5' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
pdfbody += "<b>IV</b>";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Total Component Cost (II+III) ";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += +objQuot.TotalComponentCost;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<table border='1' cellpadding='5' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
pdfbody += "<b>V</b>";
pdfbody += "</th>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Initial Die Cost ";
pdfbody += "</th>";
pdfbody += "<th style='text-align:right'>";
pdfbody += +objQuot.InitialDieCost;
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
//if (objQuot.totallycost!="")
//{
// pdfbody += "<table border='1' cellpadding='5' cellspacing='0' style='font-size: medium'>";
// pdfbody += "<tbody >";
// pdfbody += "<tr>";
// pdfbody += "<th width='5%' style='text-align:left; width:5%'>";
// pdfbody += "<b>VI</b>";
// pdfbody += "</th>";
// pdfbody += "<th style='text-align:left'>";
// pdfbody += "Total Other Cost ";
// pdfbody += "</th>";
// pdfbody += "<th style='text-align:right'>";
// pdfbody += objQuot.totallycost;
// pdfbody += "</th>";
// pdfbody += "</tr>";
// pdfbody += "</tbody>";
// pdfbody += "</table>";
//}
//
//
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
pdfbody += "<table border='1' cellpadding='2' cellspacing='0' style='font-size: medium'>";
pdfbody += "<tbody >";
pdfbody += "<tr>";
pdfbody += "<th style='text-align:left'>";
pdfbody += "Terms And Conditions: ";
pdfbody += "</th>";
pdfbody += "</tr>";
pdfbody += "<tr>";
var i = 1;
foreach (var item in objQuot.ssmtbl_TermsNCondtionModel)
{
pdfbody += "<th style='text-align:left'>";
pdfbody += +i + ". " + item.TermsNConditionContent;
pdfbody += "</th>";
i++;
}
pdfbody += "</tr>";
pdfbody += "</tbody>";
pdfbody += "</table>";
//doc.Add(Chunk.NEWLINE);
//hw.Parse(new StringReader(pdfbody));
//pdfbody += "<table border='1' cellpadding='2' cellspacing='0'>";
//pdfbody += "<tbody >";
//pdfbody += "<tr>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Prepared By:- " + objQuot.Createdby;
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Approved By:- " + objQuot.ApprovedBy;
//pdfbody += "</th>";
//pdfbody += "</tr>";
//pdfbody += "<tr>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Prepared Date:- " + objQuot.CreatedOn.Date.ToString("dd-MMM-yyyy");
//pdfbody += "</th>";
//pdfbody += "<th style='text-align:left'>";
//pdfbody += "Approved Date:- " + objQuot.ApprovalDate.Date.ToString("dd-MMM-yyyy");
//pdfbody += "</th>";
//pdfbody += "</tr>";
//pdfbody += "</tbody>";
//pdfbody += "</table>";
pdfbody += "</div>";
doc.Add(Chunk.NEWLINE);
hw.Parse(new StringReader(pdfbody));
doc.Close();
contentType = "application/pdf";
return(File(HttpContext.Server.MapPath("~/PDFFiles/Quotation/") + filenm, contentType, filenm));
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
// return View();
return(File(HttpContext.Server.MapPath("~/PDFFiles/Quotation/") + filenm, contentType, filenm));
}
public ssmtbl_FeasibilityModel GetOneFeasibility(int InquiryNo)
{
ssmtbl_FeasibilityModel objFea = new ssmtbl_FeasibilityModel();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "uspFeasiblity";
SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "GetOneFeasiblity");
cmd.Parameters.AddWithValue("@InquiryNo", InquiryNo);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objFea.FeasibilityId = Convert.ToInt32(sdr["FeasibilityId"].ToString());
objFea.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString());
objFea.FeasibilityConditionSupply = Convert.ToInt32(sdr["FeasibilityConditionSupply"].ToString());
objFea.FeasibilityNatureofWork = Convert.ToInt32(sdr["FeasibilityNatureofWork"].ToString());
objFea.FeasibilityTypeofJob = Convert.ToInt32(sdr["FeasibilityTypeofJob"].ToString());
objFea.FeasibilityHammerRequired = Convert.ToInt32(sdr["FeasibilityHammerRequired"].ToString());
objFea.FeasibilityToolingRequirement = sdr["FeasibilityToolingRequirement"].ToString();
objFea.fisdiavalue = Convert.ToInt32(sdr["fisdiavalue"].ToString());
objFea.fisdialength = Convert.ToInt32(sdr["fisdialength"].ToString());
objFea.fisdiablocklength = Convert.ToInt32(sdr["fisdiablocklength"].ToString());
objFea.fisdiablockwidth = Convert.ToInt32(sdr["fisdiablockwidth"].ToString());
objFea.fisdiablockheight = Convert.ToInt32(sdr["fisdiablockheight"].ToString());
objFea.MillTC = sdr["MillTC"].ToString();
objFea.DieDescription = sdr["DieDescription"].ToString();
objFea.grossweight = Convert.ToDecimal(sdr["grossweight"].ToString());
objFea.cutweight = Convert.ToDecimal(sdr["cutweight"].ToString());
objFea.cutlength = Convert.ToDecimal(sdr["cutlength"].ToString());
objFea.netweight = Convert.ToDecimal(sdr["netweight"].ToString());
objFea.materialweights = Convert.ToDecimal(sdr["materialweights"].ToString());
objFea.FeasibilityLubricantPreferred = Convert.ToInt32(sdr["FeasibilityLubricantPreferred"].ToString());
objFea.FeasibilityMaterialGrade = Convert.ToInt32(sdr["FeasibilityMaterialGrade"].ToString());
objFea.FeasibilityHeattreatment = Convert.ToInt32(sdr["FeasibilityHeattreatment"].ToString());
objFea.Feasibilitystandardapplicable = Convert.ToInt32(sdr["Feasibilitystandardapplicable"].ToString());
objFea.hardnessmin = sdr["hardnessmin"].ToString();
objFea.hardnessmax = sdr["hardnessmax"].ToString();
objFea.hardnessunits = sdr["hardnessunits"].ToString();
objFea.micro = sdr["micro"].ToString();
objFea.FeasibilityStatutoryandregulatoryrequirement = sdr["FeasibilityStatutoryandregulatoryrequirement"].ToString();
objFea.FeasibilityRemark = sdr["FeasibilityRemark"].ToString();
objFea.Section = Convert.ToInt32(sdr["Section"].ToString());
objFea.SectionName = sdr["SectionName"].ToString();
objFea.fisdiatotal = Convert.ToDecimal(sdr["fistotal"]);
}
sdr.Close();
List <ssmtbl_Feasibility_RawMaterialTestModel> objListRM = new List <ssmtbl_Feasibility_RawMaterialTestModel>();
sqlstr = "select Isnull(id,0) as id,Isnull(type,'') as type, Isnull(F.auto_id,0) as auto_id from LKP_RawMaterialTestFis RM "
+ " Left Join ssmtbl_Feasibility_RawMaterialTest F On RM.id=F.Raw_Material_Test and FeasibilityId=@FeasibilityId";
cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@FeasibilityId", objFea.FeasibilityId);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_Feasibility_RawMaterialTestModel tempobj = new ssmtbl_Feasibility_RawMaterialTestModel();
tempobj.auto_id = Convert.ToInt32(sdr["auto_id"].ToString());
if (tempobj.auto_id > 0)
{
tempobj.Raw_Material_Test_Select = true;
}
else
{
tempobj.Raw_Material_Test_Select = false;
}
tempobj.Raw_Material_Test = Convert.ToInt32(sdr["id"].ToString());
tempobj.Raw_Material_Test_Text = sdr["type"].ToString();
objListRM.Add(tempobj);
}
sdr.Close();
objFea.ssmtbl_Feasibility_RawMaterialTestModel = objListRM;
List <ssmtbl_Feasibility_OperationsInvolvedModel> objListOI = new List <ssmtbl_Feasibility_OperationsInvolvedModel>();
sqlstr = "select Isnull(ID,0) As ID, Isnull(operationinvolvedname,'') As Options, Isnull(F.auto_id,0) as auto_id from [LKP_Quotationoperationinvolved] OI "
+ " Left Join ssmtbl_Feasibility_OperationsInvolved F On OI.ID=F.Operations_Involved And F.FeasibilityId=@FeasibilityId "
+ " where Type='Quotation' order by F.auto_id";
cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@FeasibilityId", objFea.FeasibilityId);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
ssmtbl_Feasibility_OperationsInvolvedModel tempobj = new ssmtbl_Feasibility_OperationsInvolvedModel();
tempobj.auto_id = Convert.ToInt32(sdr["auto_id"].ToString());
if (tempobj.auto_id > 0)
{
tempobj.Operations_Involved_Select = true;
}
else
{
tempobj.Operations_Involved_Select = false;
}
tempobj.Operations_Involved = Convert.ToInt32(sdr["ID"].ToString());
tempobj.Operations_Involved_Text = sdr["Options"].ToString();
objListOI.Add(tempobj);
}
objFea.ssmtbl_Feasibility_OperationsInvolvedModel = objListOI;
sdr.Close();
List <ssmtbl_Feasibility_MultiVendorModel> objListVend = new List <ssmtbl_Feasibility_MultiVendorModel>();
string sqlstr1 = "uspInsertPrefferedVendor";
SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn);
cmd1.CommandType = System.Data.CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Action", "Select");
cmd1.Parameters.AddWithValue("@FeasiblityId", objFea.FeasibilityId);
SqlDataReader sdr1 = cmd1.ExecuteReader();
while (sdr1.Read())
{
ssmtbl_Feasibility_MultiVendorModel tempobj = new ssmtbl_Feasibility_MultiVendorModel();
tempobj.auto_id = Convert.ToInt32(sdr1["Id"].ToString());
if (tempobj.auto_id > 0)
{
tempobj.VendorNameSelect = true;
}
else
{
tempobj.VendorNameSelect = false;
}
tempobj.VendorID = Convert.ToInt32(sdr1["ID"].ToString());
tempobj.VendorName = sdr1["Name"].ToString();
objListVend.Add(tempobj);
}
sdr1.Close();
objFea.ssmtbl_Feasibility_MultiVendorModel = objListVend;
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objFea);
}
public ssmtbl_QuotationModel GetLetestQuotationID(long id)
{
var connection = gConnection.Connection();
ssmtbl_QuotationModel model = new ssmtbl_QuotationModel();
ssmtbl_FeasibilityModel fismodel = new ssmtbl_FeasibilityModel();
try
{
sqlstr = "select * from ssmtbl_Quotation where CreatedOn=(select max(CreatedOn) FROM ssmtbl_Quotation where InquiryNo=@InquiryNo )";
//sqlstr = "SELECT TOP 1 * FROM QuotationVersion where InquiryNo=77 order by Qid desc";
connection.Open();
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.Parameters.AddWithValue("@InquiryNo", id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
model.id = Convert.ToInt32(sdr["id"]);
model.QuotationId = Convert.ToInt32(sdr["id"]);
model.InquiryNo = Convert.ToInt32(sdr["InquiryNo"].ToString());
model.QuotationNo = sdr["QuotationNo"].ToString();
model.CustomerName = sdr["CustomerName"].ToString();
model.PartDescription = sdr["PartDescription"].ToString();
model.PartNo = sdr["PartNo"].ToString();
var getMaterialGrad = objDrop.FeasibilityMaterialGrade().FirstOrDefault(m => m.Value == sdr["Material"].ToString());
if (getMaterialGrad != null)
{
model.Material = getMaterialGrad.Text;
}
var getHeattreatment = objDrop.FeasibilityHeatTreatment().FirstOrDefault(m => m.Value == sdr["HeatTreatment"].ToString());
if (getHeattreatment != null)
{
model.HeatTreatmentID = getHeattreatment.Value;
model.HeatTreatmentText = getHeattreatment.Text;
}
model.VersionNo = sdr["VersionNo"].ToString();
model.Section = sdr["Section"].ToString();
model.MachainedWeight = sdr["MachainedWeight"].ToString();
model.GrossWeight = Convert.ToDecimal(sdr["GrossWeight"].ToString());
model.CutWeight = Convert.ToDecimal(sdr["CutWeight"].ToString());
model.NetWeight = Convert.ToDecimal(sdr["NetWeight"].ToString());
model.ForgingCostBased = sdr["ForgingCostBased"].ToString();
model.MPICostBasedOn = sdr["MPICostBasedOn"].ToString();
model.SteelCost = Convert.ToDecimal(sdr["SteelCost"].ToString());
model.Transportation = Convert.ToDecimal(sdr["Transportation"].ToString());
model.Total = Convert.ToDecimal(sdr["Total"].ToString());
model.TotalRowMaterialCost = Convert.ToDecimal(sdr["TotalRowMaterialCost"].ToString());
model.CuttingSquare1 = (sdr["CuttingSquare1"].ToString());
model.CuttingSquare2 = (sdr["CuttingSquare2"].ToString());
model.Forging1 = (sdr["Forging1"].ToString());
model.Forging2 = (sdr["Forging2"].ToString());
model.HeatTreatment1 = (sdr["HeatTreatment1"].ToString());
model.HeatTreatment2 = (sdr["HeatTreatment2"].ToString());
model.ShotBlasting1 = (sdr["ShotBlasting1"].ToString());
model.ShotBlasting2 = (sdr["ShotBlasting2"].ToString());
model.MPI1 = (sdr["MPI1"].ToString());
model.MPI2 = (sdr["MPI2"].ToString());
model.Grinding1 = (sdr["Grinding1"].ToString());
model.Grinding2 = (sdr["Grinding2"].ToString());
model.ColdCoining1 = (sdr["ColdCoining1"].ToString());
model.ColdCoining2 = (sdr["ColdCoining2"].ToString());
model.Machining1 = (sdr["Machining1"].ToString());
model.Machining2 = (sdr["Machining2"].ToString());
model.DieMaintenance1 = (sdr["DieMaintenance1"].ToString());
model.DieMaintenance2 = (sdr["DieMaintenance2"].ToString());
model.TotalConverstionCost = Convert.ToDecimal(sdr["TotalConverstionCost"].ToString());
model.TotalComponentCost = Convert.ToDecimal(sdr["TotalComponentCost"].ToString());
model.InitialDieCost = Convert.ToDecimal(sdr["InitialDieCost"].ToString());
model.PoNo = sdr["PoNo"].ToString();
model.FileStatus = sdr["FileStatus"].ToString();
model.Comment = sdr["Comment"].ToString();
model.ApprovalDate = (string.IsNullOrEmpty(sdr["ApprovalDate"].ToString())) ? default(DateTime) : Convert.ToDateTime(sdr["ApprovalDate"].ToString());
model.ApprovedBy = sdr["ApprovedBy"].ToString();
model.CreatedOn = Convert.ToDateTime(sdr["CreatedOn"].ToString());
model.Createdby = sdr["Createdby"].ToString();
model.UpdatedOn = (string.IsNullOrEmpty(sdr["UpdatedOn"].ToString())) ? default(DateTime) : Convert.ToDateTime(sdr["UpdatedOn"].ToString());
model.UpdatedBy = sdr["UpdatedBy"].ToString();
model.VersionNo = sdr["VersionNo"].ToString();
model.new_Version_No = Convert.ToInt32(sdr["new_Version_No"].ToString());
model.UserComment = sdr["UserComment"].ToString();
model.iccoverhadrm = sdr["Iccoverhead"].ToString();
// sdr["Iccoverhead"] as decimal? ?? default(decimal);
model.totaliccoverhadrm = sdr["Iccoverheadtotal"].ToString();
//Convert.ToDecimal(sdr["Iccoverheadtotal"].ToString());
model.profitonconversion = sdr["Profitconversion"].ToString();
//Convert.ToDecimal(sdr["Profitconversion"].ToString());
model.totalprofitonconversion = sdr["TotalProfitconversion"].ToString();
//Convert.ToDecimal(sdr["TotalProfitconversion"].ToString());
model.rejection = sdr["Rejection"].ToString();
//Convert.ToDecimal(sdr["Rejection"].ToString());
model.totalrejection = sdr["TotalRejection"].ToString();
//Convert.ToDecimal(sdr["TotalRejection"].ToString());
model.packingtransport = sdr["Packing"].ToString();
//Convert.ToDecimal(sdr["Packing"].ToString());
model.totalpackingtransport = sdr["TotalPacking"].ToString();
//Convert.ToDecimal(sdr["TotalPacking"].ToString());
model.totallycost = sdr["TotallyCost"].ToString();
}
connection.Close();
////////////////
//sqlstr1 = "select * from ssmtbl_Feasibility where InquiryNo=@InquiryNo";
//connection.Open();
//SqlCommand cmd1 = new SqlCommand(sqlstr1, connection);
//cmd1.Parameters.AddWithValue("@InquiryNo", id);
//SqlDataReader sdr1 = cmd1.ExecuteReader();
//while (sdr1.Read())
//{
// fismodel.hardnessmin = sdr1["hardnessmin"].ToString();
// fismodel.hardnessmax = sdr1["hardnessmax"].ToString();
// fismodel.hardnessunits = sdr1["hardnessunits"].ToString();
//}
//connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
connection.Close();
}
return(model);
}
