// ***************** UPDATE JEWELLERS DETAILS ********************* public bool UpdateDetails(JewellerDetails jd) { connection(); SqlCommand cmd = new SqlCommand("UpdateJeweller", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username", jd.Username); cmd.Parameters.AddWithValue("@password", jd.Password); cmd.Parameters.AddWithValue("@name", jd.Name); cmd.Parameters.AddWithValue("@contact1", jd.Contact1); cmd.Parameters.AddWithValue("@contact2", jd.Contact2); cmd.Parameters.AddWithValue("@email", jd.Email); cmd.Parameters.AddWithValue("@address", jd.Address); cmd.Parameters.AddWithValue("@pincode", jd.Pincode); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return(true); } else { return(false); } }
public ActionResult Edit(JewellerDetails jd) { if (ModelState.IsValid) { jewellerhandle.UpdateDetails(jd); return(RedirectToAction("Home")); } ViewBag.error = "Model State not valid"; return(View()); }