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