public HttpResponseMessage GetSpectroMaster(ENT.SpectroMasterParam objENT) { List <ENT.SpectroMaster> lstResult = new List <ENT.SpectroMaster>(); try { objENT.Mode = "GetSpectroMaster"; lstResult = new DAL.SpectroEntry().GetSpectroMasterForAPI(objENT); objENT.Message = lstResult.Count + " record found."; return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { objENT, lstResult })); } catch (Exception ex) { objENT.Message = ex.Message.ToString(); ERRORREPORTING.Report(ex, Request.RequestUri.AbsoluteUri, new Guid("00000000-0000-0000-0000-000000000000"), "Gujarat_Intrux", "Function Name : GetSpectroMaster()"); return(ControllerContext.Request.CreateResponse(HttpStatusCode.InternalServerError, new { objENT, lstResult })); } }
public List <ENT.SpectroMaster> GetSpectroMasterForAPI(ENT.SpectroMasterParam objENT) { List <ENT.SpectroMaster> lstENT = new List <ENT.SpectroMaster>(); try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "GetSpectroDataForAPI"; sqlCMD.Parameters.AddWithValue("@FromDate", objENT.FromDate); sqlCMD.Parameters.AddWithValue("@ToDate", objENT.ToDate); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); lstENT = DBHelper.GetEntityList <ENT.SpectroMaster>(sqlCMD); } catch (Exception ex) { throw ex; } return(lstENT); }