public HttpResponseMessage GetHeatStartStop() { ENT.HeatStartStop objENT = new ENT.HeatStartStop(); List <ENT.HeatStartStop> lstResult = new List <ENT.HeatStartStop>(); try { objENT.Mode = "GetAll"; lstResult = new DAL.HeatStartStop().GetHeatStartStop(objENT); objENT.Message = lstResult.Count + " Record Found."; } catch (Exception ex) { objENT.Message = ex.Message.ToString(); return(ControllerContext.Request.CreateResponse(HttpStatusCode.InternalServerError, new { objENT })); } return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { lstResult, objENT })); }
public List <ENT.HeatStartStop> GetHeatStartStop(ENT.HeatStartStop objENT) { List <ENT.HeatStartStop> lstENT = new List <ENT.HeatStartStop>(); try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "GetHeatStartStop"; sqlCMD.Parameters.AddWithValue("@HeatID", objENT.HeatID); sqlCMD.Parameters.AddWithValue("@HeatStart", objENT.HeatStart); sqlCMD.Parameters.AddWithValue("@HeatStop", objENT.HeatStop); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); lstENT = DBHelper.GetEntityList <ENT.HeatStartStop>(sqlCMD); } catch (Exception ex) { throw ex; } return(lstENT); }
public HttpResponseMessage SaveHeatStartStop(ENT.HeatStartStop Model) { try { if (new DAL.HeatStartStop().InsertUpdateDeleteHeatStartStop(Model)) { Model.Message = "Heat Started Successfully."; } else { Model.Message = "Internal Server Error"; } } catch (Exception ex) { Model.Message = ex.Message.ToString(); return(ControllerContext.Request.CreateResponse(HttpStatusCode.InternalServerError, new { ex.Message })); } return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { Model })); }
public bool InsertUpdateDeleteHeatStartStop(ENT.HeatStartStop objENT) { bool row = false; try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "InsertUpdateDeleteHeatStartStop"; sqlCMD.Parameters.AddWithValue("@HeatID", objENT.HeatID); sqlCMD.Parameters.AddWithValue("@HeatStart", objENT.HeatStart); sqlCMD.Parameters.AddWithValue("@HeatStop", objENT.HeatStop); sqlCMD.Parameters.AddWithValue("@IsStop", objENT.IsStop); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); row = objCRUD.InsertUpdateDelete(sqlCMD); } catch (Exception ex) { throw ex; } return(row); }