public ActionResult EditWebsiteData(Prob_Vs_price_matrix m)
{
m.UserId = CurrentUser.UserId;
using (var con = new SqlConnection(_connectionString))
{
var result = con.Query <int>("sp_insert_into_Probles_VS_Price_matrix",
new { m.Model_Id,
Problem_Id = m.Problem,
m.Market_Price,
m.estimated_Price,
m.Min_Price,
m.Max_Price,
action = "edit",
m.UserId,
CurrentUser.CompanyId },
commandType: CommandType.StoredProcedure).FirstOrDefault();
var response = new ResponseModel();
if (result == 2)
{
response.IsSuccess = true;
response.Response = "Successfully Updated";
TempData["response"] = response;
}
else
{
response.IsSuccess = true;
response.Response = "Not Updated Successfully";
TempData["response"] = response;
}
return(RedirectToAction("Probs_price_Matrix"));
}
}
public ActionResult AddWebsiteData()
{
var parts = new Prob_Vs_price_matrix();
parts.BrandList = new SelectList(dropdown.BindBrand(CurrentUser.CompanyId), "Value", "Text");
parts.ProblemList = new SelectList(dropdown.BindMstDeviceProblemAbhishek(), "Value", "Text");
parts.ModelList = new SelectList(dropdown.BindModelName(), "value", "text");
return(PartialView(parts));
}
public ActionResult EditWebsiteData(int websitePriceProblem, int ProblemId)
{
var result = new Prob_Vs_price_matrix();
using (var con = new SqlConnection(_connectionString))
{
result = con.Query <Prob_Vs_price_matrix>("sp_GetSingleRecord_Probles_VS_Price_Matrix ",
new { Problem_Id = ProblemId, model_ID = websitePriceProblem }, commandType: CommandType.StoredProcedure).FirstOrDefault();
ViewBag.Problem = new SelectList(dropdown.BindMstDeviceProblemAbhishek(), "Value", "Text");
ViewBag.BrandName = new SelectList(dropdown.BindBrand(CurrentUser.CompanyId), "Value", "Text");
if (result.Model_Id != null)
{
ViewBag.Model_Id = new SelectList(dropdown.BindProduct(Int32.Parse(result.BrandName)), "Value", "Text");
}
else
{
ViewBag.Model_Id = new SelectList(Enumerable.Empty <SelectListItem>());
}
}
result.Problem = result.Problem_Id;
return(PartialView("EditWebsiteData", result));
}
