public ActionResult NewInquiry(ssmtbl_InquiryModel objInqMod) { try { if (ModelState.IsValid) { string result = objInqData.InsertInquiry(objInqMod); if (result == "Inquiry Created Successfully!") { ModelState.Clear(); objInqMod = new ssmtbl_InquiryModel(); objInqMod.InquiryNo = objInqData.GetMaxInquiryNo(); objInqMod.InquiryDate = DateTime.Now; @ViewBag.HideClass = "alert alert-success"; @ViewBag.Message = result; } else { @ViewBag.HideClass = "alert alert-danger"; @ViewBag.Message = result; } return(RedirectToAction("AllInquiry", "Inquiry")); } } catch (Exception ex) { Global.ErrorHandlerClass.LogError(ex); @ViewBag.HideClass = "alert alert-danger"; @ViewBag.Message = "Inquiry Not Saved!"; } ViewData["FreqRepeatOrder"] = objDrop.FrqRepOrder(); return(View(objInqMod)); }
public ActionResult NewInquiry() { ssmtbl_InquiryModel objInqMod = new ssmtbl_InquiryModel(); objInqMod.InquiryNo = objInqData.GetMaxInquiryNo(); objInqMod.InquiryDate = DateTime.Now; ViewData["FreqRepeatOrder"] = objDrop.FrqRepOrder(); ViewData["DieNumber"] = objDrop.DieNumber(); return(View(objInqMod)); }
public ActionResult EditInquiry(string id) { ssmtbl_InquiryModel objInqMod = new ssmtbl_InquiryModel(); if (id == null || id == "") { id = "0"; } objInqMod = objInqData.GetOneInquiry(Convert.ToInt32(id)); ViewData["FreqRepeatOrder"] = objDrop.FrqRepOrder(); ViewData["DieNumber"] = objDrop.DieNumber(); return(View(objInqMod)); }
// 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 string InsertInquiry(ssmtbl_InquiryModel objInqMod) { string result = "Error Creating Inquiry"; try { int dieid = 0; if (objInqMod.DieID == 0) { var connection1 = gConnection.Connection(); string sqlstr1 = "InsertDieDescInInquiry"; SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn); cmd1.CommandType = System.Data.CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Action", "InsertDieDescInInquiry"); cmd1.Parameters.AddWithValue("@DieNo", objInqMod.DieNumber); cmd1.Parameters.AddWithValue("@customerName", objInqMod.customerName); cmd1.Parameters.AddWithValue("@PartName", objInqMod.PartName); cmd1.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output; connection1.Open(); cmd1.ExecuteNonQuery(); string id = cmd1.Parameters["@id"].Value.ToString(); dieid = Convert.ToInt32(id); connection1.Close(); } else { dieid = objInqMod.DieID; } var connection = gConnection.Connection(); connection.Open(); string sqlstr = "ssmsp_Insert_Inquiry"; SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@InquiryNo", objInqMod.InquiryNo); cmd.Parameters.AddWithValue("@customerName", objInqMod.customerName); cmd.Parameters.AddWithValue("@InquiryDate", objInqMod.InquiryDate); cmd.Parameters.AddWithValue("@PartName", objInqMod.PartName); cmd.Parameters.AddWithValue("@PartNo", objInqMod.PartNo); cmd.Parameters.AddWithValue("@CustomerDrgNo", objInqMod.CustomerDrgNo); cmd.Parameters.AddWithValue("@FrequencyRepearOrder", objInqMod.FrequencyRepearOrder); cmd.Parameters.AddWithValue("@Qty", objInqMod.Qty); cmd.Parameters.AddWithValue("@Status", InquiryStatus.InquiryNew); cmd.Parameters.AddWithValue("@createdby", 1); // cmd.Parameters.AddWithValue("@createdby", HttpContext.Current.Session["userid"].ToString()); cmd.Parameters.AddWithValue("@createddate", StandardDateTime.GetDateTime()); cmd.Parameters.AddWithValue("@hsncode", objInqMod.HSN); cmd.Parameters.AddWithValue("@dieid", dieid); cmd.Parameters.AddWithValue("@Remark", objInqMod.Remark); cmd.ExecuteNonQuery(); connection.Close(); result = "Inquiry Created Successfully!"; } catch (Exception ex) { Global.ErrorHandlerClass.LogError(ex); } return(result); }