public Tuple <long, string> InsertFeasibility(ssmtbl_FeasibilityModel1 objFea)
{
string result = "Error Creating Feasibility";
int id = 0;
try
{
/////////////
//var connection1 = gConnection.Connection();
//string sqlstr1 = "InsertPreferedVendor";
//SqlCommand cmd1 = new SqlCommand(sqlstr1, GlobalVariables.gConn);
//cmd1.CommandType = System.Data.CommandType.StoredProcedure;
//cmd1.Parameters.AddWithValue("@Name", objFea.MillTC.Trim());
//cmd1.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
//connection1.Open();
//cmd1.ExecuteNonQuery();
//string prefid = cmd1.Parameters["@id"].Value.ToString();
//int preferedvendorid = Convert.ToInt32(prefid);
//connection1.Close();
////////////
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_Insert_Feasibility";
SqlCommand cmd = new SqlCommand(sqlstr, GlobalVariables.gConn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@InquiryNo", objFea.InquiryNo);
cmd.Parameters.AddWithValue("@FeasibilityConditionSupply", objFea.FeasibilityConditionSupply);
cmd.Parameters.AddWithValue("@FeasibilityNatureofWork", objFea.FeasibilityNatureofWork);
cmd.Parameters.AddWithValue("@FeasibilityTypeofJob", objFea.FeasibilityTypeofJob);
cmd.Parameters.AddWithValue("@FeasibilityHammerRequired", objFea.FeasibilityHammerRequired);
cmd.Parameters.AddWithValue("@FeasibilityToolingRequirement", objFea.FeasibilityToolingRequirement);
cmd.Parameters.AddWithValue("@fisdiavalue", objFea.fisdiavalue);
cmd.Parameters.AddWithValue("@fisdialength", objFea.fisdialength);
cmd.Parameters.AddWithValue("@fisdiablocklength", objFea.fisdiablocklength);
cmd.Parameters.AddWithValue("@fisdiablockwidth", objFea.fisdiablockwidth);
cmd.Parameters.AddWithValue("@fisdiablockheight", objFea.fisdiablockheight);
cmd.Parameters.AddWithValue("@MillTC", objFea.MillTC);
cmd.Parameters.AddWithValue("@DieDescription", objFea.DieDescription);
cmd.Parameters.AddWithValue("@grossweight", objFea.grossweight);
cmd.Parameters.AddWithValue("@cutweight", objFea.cutweight);
cmd.Parameters.AddWithValue("@Section", objFea.Section); // Sharad
cmd.Parameters.AddWithValue("@cutlength", objFea.cutlength);
cmd.Parameters.AddWithValue("@netweight", objFea.netweight);
cmd.Parameters.AddWithValue("@materialweights", objFea.materialweights);
cmd.Parameters.AddWithValue("@FeasibilityLubricantPreferred", objFea.FeasibilityLubricantPreferred);
cmd.Parameters.AddWithValue("@FeasibilityMaterialGrade", objFea.FeasibilityMaterialGrade);
cmd.Parameters.AddWithValue("@FeasibilityHeattreatment", objFea.FeasibilityHeattreatment);
cmd.Parameters.AddWithValue("@Feasibilitystandardapplicable", objFea.Feasibilitystandardapplicable);
cmd.Parameters.AddWithValue("@hardnessmin", objFea.hardnessmin);
cmd.Parameters.AddWithValue("@hardnessmax", objFea.hardnessmax);
cmd.Parameters.AddWithValue("@hardnessunits", objFea.hardnessunits);
cmd.Parameters.AddWithValue("@micro", objFea.micro);
cmd.Parameters.AddWithValue("@Status", InquiryStatus.FeasibilityDone);
cmd.Parameters.AddWithValue("@FeasibilityStatutoryandregulatoryrequirement", objFea.FeasibilityStatutoryandregulatoryrequirement);
cmd.Parameters.AddWithValue("@FeasibilityRemark", objFea.FeasibilityRemark);
cmd.Parameters.AddWithValue("@feasibilitycreatedby", HttpContext.Current.Session["userid"].ToString());
//cmd.Parameters.AddWithValue("@feasibilitycreatedby", Session["UserId"].ToString());
cmd.Parameters.AddWithValue("@feasibilitycreateddate", StandardDateTime.GetDateTime());
cmd.Parameters.AddWithValue("@fistotal", objFea.fisdiatotal);
cmd.Parameters.AddWithValue("@PreferedVendorID", 0);
cmd.Parameters.Add("@Feasid", SqlDbType.Int);
cmd.Parameters["@Feasid"].Direction = ParameterDirection.Output;
//DataTable dataTable1 = new DataTable("SampleDataType");
//dataTable1.Columns.Add("Operations_Involved", typeof(string));
//foreach (var data in objFea.ssmtbl_Feasibility_OperationsInvolvedModel)
//{
// if (data.Operations_Involved_Select == true)
// {
// dataTable1.Rows.Add(data.Operations_Involved);
// }
//}
//var pList = new SqlParameter("@ssmtbl_Feasibility_OperationsInvolved_", SqlDbType.Structured);
//pList.TypeName = "dbo.ssmtbl_Feasibility_OperationsInvolved";
//pList.Value = dataTable1;
//cmd.Parameters.Add(pList);
//DataTable dataTable2 = new DataTable("SampleDataType1");
//dataTable2.Columns.Add("Raw_Material_Test", typeof(string));
//foreach (var data in objFea.ssmtbl_Feasibility_RawMaterialTestModel)
//{
// if (data.Raw_Material_Test_Select == true)
// {
// dataTable2.Rows.Add(data.Raw_Material_Test);
// }
//}
//var pList1 = new SqlParameter("@ssmtbl_Feasibility_RawMaterialTest_", SqlDbType.Structured);
//pList1.TypeName = "dbo.ssmtbl_Feasibility_RawMaterialTest";
//pList1.Value = dataTable2;
//cmd.Parameters.Add(pList1);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
id = Convert.ToInt32(sdr[0].ToString());
}
connection.Close();
result = "Feasibility Created Successfully!";
}
catch (Exception ex)
{
Global.ErrorHandlerClass.LogError(ex);
}
return(new Tuple <long, string>(id, result));
}
public JsonResult CreateFeasibility(ssmtbl_FeasibilityModel1 objfea)
{
string Result = "";
long id = 0;
//if(ModelState.IsValid)
//{
if (objfea.FeasibilityId > 0)
{
var tuple = objFData.UpdateFeasibility(objfea);
id = tuple.Item1;
Result = tuple.Item2;
//Result = objFData.UpdateFeasibility(objFea);
if (Result == "Feasibility Updated Successfully!")
{
@ViewBag.HideClass = "alert alert-success";
@ViewBag.Message = Result;
}
else
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = Result;
}
}
else
{
var tuple = objFData.InsertFeasibility(objfea);
id = tuple.Item1;
Result = tuple.Item2;
if (Result == "Feasibility Created Successfully!")
{
@ViewBag.HideClass = "alert alert-success";
@ViewBag.Message = Result;
}
else
{
@ViewBag.HideClass = "alert alert-danger";
@ViewBag.Message = Result;
}
}
//return RedirectToAction("AllInquiry", "Inquiry");
//}
//else
//{
// @ViewBag.HideClass = "alert alert-danger";
// @ViewBag.Message = "Enter Mandatory Fields!";
//}
//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["Section1"] = objDrop.CuutingCalculation();
//objFea = new ssmtbl_FeasibilityModel();
//objFea.ssmtbl_Feasibility_RawMaterialTestModel = objGFunc.FeasibilityRawMaterial();
//objFea.ssmtbl_Feasibility_OperationsInvolvedModel = objGFunc.FeasibilityOperationsInvolved();
//return View(objFea);
return(Json(id, JsonRequestBehavior.AllowGet));
}
