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