public bool UpdateDetails(RecurenceTypeModel smodel)
{
connection();
SqlCommand cmd = new SqlCommand("UpdateRecurenceType", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", smodel.id);
cmd.Parameters.AddWithValue("@detail", smodel.detail);
cmd.Parameters.AddWithValue("@days", smodel.days);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit(int id, RecurenceTypeModel smodel)
{
try {
RecurenceTypeDBHandle sdb = new RecurenceTypeDBHandle();
sdb.UpdateDetails(smodel);
return(RedirectToAction("Index"));
} catch {
return(View());
}
}
public ActionResult Create(RecurenceTypeModel smodel)
{
try {
if (ModelState.IsValid)
{
RecurenceTypeDBHandle sdb = new RecurenceTypeDBHandle();
if (sdb.Add(smodel))
{
ViewBag.Message = "Details Added Successfully";
ModelState.Clear();
}
}
return(View());
} catch (Exception e) {
e.GetBaseException();
return(View());
}
}
