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