public ActionResult Edit(decimal id)
{
BusinessLayer.QSSellerDetail fooditem = dbset.SellerDetails.Single(emp => emp.SellerId == id);
if (fooditem == null)
{
return(HttpNotFound());
}
ViewBag.BankId = new SelectList(dbset.BankDetails.OrderBy(x => x.BankName), "BankId", "BankName", fooditem.BankId);
return(View(fooditem));
}
public void SaveChangesQSSellerDetailToDB(QSSellerDetail employee)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spSaveChangesSellerDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramFoodName = new SqlParameter();
paramFoodName.ParameterName = "@SellerName";
paramFoodName.Value = employee.SellerName;
cmd.Parameters.Add(paramFoodName);
SqlParameter paramId = new SqlParameter();
paramId.ParameterName = "@SellerId";
paramId.Value = employee.SellerId;
cmd.Parameters.Add(paramId);
SqlParameter paramSellerState = new SqlParameter();
paramSellerState.ParameterName = "@SellerState";
paramSellerState.Value = employee.SellerState;
cmd.Parameters.Add(paramSellerState);
SqlParameter paramSellerAddress = new SqlParameter();
paramSellerAddress.ParameterName = "@SellerAddress";
paramSellerAddress.Value = employee.SellerAddress;
cmd.Parameters.Add(paramSellerAddress);
SqlParameter paramSellerPhoneNumber = new SqlParameter();
paramSellerPhoneNumber.ParameterName = "@SellerPhoneNumber";
paramSellerPhoneNumber.Value = employee.SellerPhoneNumber;
cmd.Parameters.Add(paramSellerPhoneNumber);
SqlParameter paramSellerEmail = new SqlParameter();
paramSellerEmail.ParameterName = "@SellerEmail";
paramSellerEmail.Value = employee.SellerEmail;
cmd.Parameters.Add(paramSellerEmail);
SqlParameter paramSellerAccountNumber = new SqlParameter();
paramSellerAccountNumber.ParameterName = "@SellerAccountNumber";
paramSellerAccountNumber.Value = employee.SellerAccountNumber;
cmd.Parameters.Add(paramSellerAccountNumber);
SqlParameter paramBankId = new SqlParameter();
paramBankId.ParameterName = "@BankId";
paramBankId.Value = employee.BankId;
cmd.Parameters.Add(paramBankId);
SqlParameter paramSellerAccountName = new SqlParameter();
paramSellerAccountName.ParameterName = "@SellerAccountName";
paramSellerAccountName.Value = employee.SellerAccountName;
cmd.Parameters.Add(paramSellerAccountName);
con.Open();
cmd.ExecuteNonQuery();
}
}
//[ValidateAntiForgeryToken]
public ActionResult Edit(BusinessLayer.QSSellerDetail fooditem)
{
if (ModelState.IsValid)
{
dbset.SaveChangesQSSellerDetailToDB(fooditem);
//db.Entry(fooditem).State = EntityState.Modified;
//db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BankId = new SelectList(dbset.BankDetails.OrderBy(x => x.BankName), "BankId", "BankName", fooditem.BankId);
return(View(fooditem));
}
//[ActionName("Create")]
//[ValidateAntiForgeryToken]
public ActionResult Create(BusinessLayer.QSSellerDetail fooditem)//Create(FormCollection formCollection)
{
if (ModelState.IsValid)
{
dbset.AddQSSellerDetailToDB(fooditem);
return(RedirectToAction("Index"));
}
ViewBag.BankId = new SelectList(dbset.BankDetails.OrderBy(x => x.BankName), "BankId", "BankName");
return(View());
}
