public ActionResult ViewOnePurchaseOrder(string InquiryNo)
{
ssmtbl_Quotation_PoModel objQuotPO = new ssmtbl_Quotation_PoModel();
var modelFeasibility = objFeasiData.GetOneFeasibility(Convert.ToInt32(InquiryNo));
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureOfWork"] = modelFeasibility.FeasibilityNatureofWork; // Sharad
}
//ssmtbl_PurchaseOrderModel objPOModel = new ssmtbl_PurchaseOrderModel();
objQuotPO.ssmtbl_PurchaseOrderModel = objPOData.GetOnePurchaseOrder(InquiryNo);
objQuotPO.ssmtbl_QuotationModel = objQuotAppData.GetOneQuotationForApproval(objQuotPO.ssmtbl_PurchaseOrderModel.QuotationId.ToString());
return(View(objQuotPO));
}
public ActionResult NewPurchaseOrder(string QuotationId)
{
ssmtbl_Quotation_PoModel objQuotPO = new ssmtbl_Quotation_PoModel();
objQuotPO.ssmtbl_QuotationModel = objQuotAppData.GetOneQuotationForApproval(QuotationId);
var modelFeasibility = objFeasiData.GetOneFeasibility(objQuotPO.ssmtbl_QuotationModel.InquiryNo);
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureOfWork"] = modelFeasibility.FeasibilityNatureofWork; // Sharad
ViewData["sectionName"] = modelFeasibility.SectionName;
}
ViewData["maxInqNo"] = objInqData.GetMaxInquiryNo();
ViewData["RawMaterial"] = objDrop.FeasibilityMaterialGrade();
ViewData["Section"] = objDrop.CuutingCalculation();
return(View(objQuotPO));
}
public PartialViewResult PurchaseOrderForApproval(string PO_Id, string QuotationId)
{
ssmtbl_Quotation_PoModel objQuotPO = new ssmtbl_Quotation_PoModel();
objQuotPO.ssmtbl_QuotationModel = objQuotAppData.GetOneQuotationForApproval(QuotationId);
var modelFeasibility = objFeasiData.GetOneFeasibility(objQuotPO.ssmtbl_QuotationModel.InquiryNo);
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureOfWork"] = modelFeasibility.FeasibilityNatureofWork; // Sharad
}
if (PO_Id == null || PO_Id == "")
{
PO_Id = "0";
}
objQuotPO.ssmtbl_PurchaseOrderModel = objPOAppData.GetOnePurchaseOrder(PO_Id);
return(PartialView(objQuotPO));
}
public ActionResult NewPurchaseOrder(ssmtbl_Quotation_PoModel objPO, HttpPostedFileBase filename1)
{
try
{
string Result = "";
if (objPO.ssmtbl_PurchaseOrderModel.QtymentionedinPO == null)
{
objPO.ssmtbl_PurchaseOrderModel.QtymentionedinPO = "";
}
if (objPO.ssmtbl_PurchaseOrderModel.POQty_Open == false && objPO.ssmtbl_PurchaseOrderModel.QtymentionedinPO == "")
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = "PO Qty can't be Blank as it is not Open!";
}
else
{
if (filename1 != null && filename1.ContentLength > 0)
{
objPO.ssmtbl_PurchaseOrderModel.Filepath = filename1.ToString(); //getting complete url
var fileName = Path.GetFileName(filename1.FileName); //getting only file name(ex-ganesh.jpg)
var ext = Path.GetExtension(filename1.FileName); //getting the extension(ex-.jpg)
string name = Path.GetFileNameWithoutExtension(fileName); //getting file name without extension
string myfile = name + ext; //appending the name with id
var path = Path.Combine(Server.MapPath("/PDFFiles/PODocs"), myfile);
var path1 = "/PDFFiles/PODocs/" + myfile;
objPO.ssmtbl_PurchaseOrderModel.Filepath = path1;
filename1.SaveAs(path);
}
Result = objPOData.InsertPurchaseOrder(objPO);
if (Result == "Purchase Order Created Successfully!")
{
@ViewBag.HideClass = "alert alert-success";
@ViewBag.Message = Result;
}
else
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = Result;
}
}
if (ModelState.IsValid)
{
}
else
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = "Enter Mandatory Fields!";
}
ssmtbl_Quotation_PoModel objQuotPO = new ssmtbl_Quotation_PoModel();
objQuotPO.ssmtbl_QuotationModel = objQuotAppData.GetOneQuotationForApproval(objPO.ssmtbl_QuotationModel.id.ToString());
var modelFeasibility = objFeasiData.GetOneFeasibility(objQuotPO.ssmtbl_QuotationModel.InquiryNo);
if (modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel != null)
{
ViewData["OperationsInvolved"] = modelFeasibility.ssmtbl_Feasibility_OperationsInvolvedModel;
ViewData["NatureOfWork"] = modelFeasibility.FeasibilityNatureofWork; // Sharad
}
//// return View(objQuotPO); //objQuotPO
Response.Write("<script>alert('PO Send For Approval Successfully')</script>");
return(RedirectToAction("AllInquiry", "Inquiry"));
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
// return View();
return(RedirectToAction("AllInquiry", "Inquiry"));
}
public string InsertPurchaseOrder(ssmtbl_Quotation_PoModel objPOMod)
{
string result = "Error Creating Purchase Order";
try
{
if (objPOMod.ssmtbl_PurchaseOrderModel.Filepath == null)
{
objPOMod.ssmtbl_PurchaseOrderModel.Filepath = "";
}
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Insert_PurchaseOrder";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InquiryNo", objPOMod.ssmtbl_QuotationModel.InquiryNo);
cmd.Parameters.AddWithValue("@customerName", objPOMod.ssmtbl_QuotationModel.CustomerName.Trim());
cmd.Parameters.AddWithValue("@QuotationNo", objPOMod.ssmtbl_QuotationModel.QuotationNo.Trim());
cmd.Parameters.AddWithValue("@QuotationId", objPOMod.ssmtbl_QuotationModel.id);
cmd.Parameters.AddWithValue("@CustomerPONo", objPOMod.ssmtbl_PurchaseOrderModel.CustomerPONo.Trim());
cmd.Parameters.AddWithValue("@POValidity", StandardDateTime.GetDateTime());
cmd.Parameters.AddWithValue("@QtymentionedinPO", objPOMod.ssmtbl_PurchaseOrderModel.QtymentionedinPO.Trim());
cmd.Parameters.AddWithValue("@DieNumber", objPOMod.ssmtbl_PurchaseOrderModel.DieNumber.Trim());
cmd.Parameters.AddWithValue("@HSNCode", "");
cmd.Parameters.AddWithValue("@SteelCost", objPOMod.ssmtbl_PurchaseOrderModel.SteelCost);
cmd.Parameters.AddWithValue("@Transportation", objPOMod.ssmtbl_PurchaseOrderModel.Transportation);
cmd.Parameters.AddWithValue("@Total", objPOMod.ssmtbl_PurchaseOrderModel.Total);
cmd.Parameters.AddWithValue("@TotalRowMaterialCost", objPOMod.ssmtbl_PurchaseOrderModel.TotalRowMaterialCost);
cmd.Parameters.AddWithValue("@CuttingSquare1", objPOMod.ssmtbl_PurchaseOrderModel.CuttingSquare1);
cmd.Parameters.AddWithValue("@CuttingSquare2", objPOMod.ssmtbl_PurchaseOrderModel.CuttingSquare2);
cmd.Parameters.AddWithValue("@Forging1", objPOMod.ssmtbl_PurchaseOrderModel.Forging1);
cmd.Parameters.AddWithValue("@Forging2", objPOMod.ssmtbl_PurchaseOrderModel.Forging2);
cmd.Parameters.AddWithValue("@HeatTreatment1", objPOMod.ssmtbl_PurchaseOrderModel.HeatTreatment1);
cmd.Parameters.AddWithValue("@HeatTreatment2", objPOMod.ssmtbl_PurchaseOrderModel.HeatTreatment2);
cmd.Parameters.AddWithValue("@ShotBlasting1", objPOMod.ssmtbl_PurchaseOrderModel.ShotBlasting1);
cmd.Parameters.AddWithValue("@ShotBlasting2", objPOMod.ssmtbl_PurchaseOrderModel.ShotBlasting2);
cmd.Parameters.AddWithValue("@MPI1", objPOMod.ssmtbl_PurchaseOrderModel.MPI1);
cmd.Parameters.AddWithValue("@MPI2", objPOMod.ssmtbl_PurchaseOrderModel.MPI2);
cmd.Parameters.AddWithValue("@Grinding1", objPOMod.ssmtbl_PurchaseOrderModel.Grinding1);
cmd.Parameters.AddWithValue("@Grinding2", objPOMod.ssmtbl_PurchaseOrderModel.Grinding2);
cmd.Parameters.AddWithValue("@ColdCoining1", objPOMod.ssmtbl_PurchaseOrderModel.ColdCoining1);
cmd.Parameters.AddWithValue("@ColdCoining2", objPOMod.ssmtbl_PurchaseOrderModel.ColdCoining2);
cmd.Parameters.AddWithValue("@Machining1", objPOMod.ssmtbl_PurchaseOrderModel.Machining1);
cmd.Parameters.AddWithValue("@Machining2", objPOMod.ssmtbl_PurchaseOrderModel.Machining2);
cmd.Parameters.AddWithValue("@DieMaintenance1", objPOMod.ssmtbl_PurchaseOrderModel.DieMaintenance1);
cmd.Parameters.AddWithValue("@DieMaintenance2", objPOMod.ssmtbl_PurchaseOrderModel.DieMaintenance2);
cmd.Parameters.AddWithValue("@TotalConverstionCost", objPOMod.ssmtbl_PurchaseOrderModel.TotalConverstionCost);
cmd.Parameters.AddWithValue("@TotalComponentCost", objPOMod.ssmtbl_PurchaseOrderModel.TotalComponentCost);
cmd.Parameters.AddWithValue("@InitialDieCost", objPOMod.ssmtbl_PurchaseOrderModel.InitialDieCost);
cmd.Parameters.AddWithValue("@Filepath", objPOMod.ssmtbl_PurchaseOrderModel.Filepath);
cmd.Parameters.AddWithValue("@Status", InquiryStatus.POPendingForApproval);
cmd.Parameters.AddWithValue("@CGST", objPOMod.ssmtbl_PurchaseOrderModel.CGST);
cmd.Parameters.AddWithValue("@IGST", objPOMod.ssmtbl_PurchaseOrderModel.IGST);
cmd.Parameters.AddWithValue("@SGST", objPOMod.ssmtbl_PurchaseOrderModel.SGST);
cmd.Parameters.AddWithValue("@createdby", "Test");
//cmd.Parameters.AddWithValue("@createdby", Session["UserId"].ToString());
cmd.Parameters.AddWithValue("@POQty_Open", objPOMod.ssmtbl_PurchaseOrderModel.POQty_Open);
cmd.Parameters.AddWithValue("@saq", objPOMod.ssmtbl_PurchaseOrderModel.sameasquotation);
cmd.Parameters.AddWithValue("@createddate", StandardDateTime.GetDateTime());
cmd.ExecuteNonQuery();
connection.Close();
result = "Purchase Order Created Successfully!";
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
}
return(result);
}
