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);
}
