public ActionResult ChiefHistory(ChiefHistory objChiefHistory) { try { if (obj.CheckChiefHistory(objChiefHistory.ChiefHistoryID, objChiefHistory.ChiefHistoryName)) { if (objChiefHistory.ChiefHistoryID > 0) { if (obj.Save(objChiefHistory)) { ModelState.Clear(); TempData["msg"] = "Chief History Updated Successfully"; } } else { if (obj.Save(objChiefHistory)) { ModelState.Clear(); TempData["msg"] = "Chief History Saved Successfully"; } } } else { TempData["msg"] = "Chief History Already exist"; } return(RedirectToAction("ChiefHistory", "ChiefHistory")); } catch (Exception Ex) { TempData["msg"] = Ex.Message; return(RedirectToAction("ChiefHistory", "ChiefHistory")); } }
public bool Save(ChiefHistory obj) { Connect(); SqlCommand cmd = new SqlCommand("IUChiefHistory", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.ChiefHistoryID == 0) { cmd.Parameters.AddWithValue("@ChiefHistoryID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@ChiefHistoryID", obj.ChiefHistoryID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@ChiefHistoryName", obj.ChiefHistoryName); if (obj.ReferenceCode == null) { cmd.Parameters.AddWithValue("@ReferenceCode", string.Empty); } else { cmd.Parameters.AddWithValue("@ReferenceCode", obj.ReferenceCode); } if (obj.ChiefHistoryDescription == null) { cmd.Parameters.AddWithValue("@ChiefHistoryDescription", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ChiefHistoryDescription", obj.ChiefHistoryDescription); } cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }