public HttpResponseMessage GetSpectroDetail(ENT.SpectroDetailParam objENT) { List <ENT.SpectroEntry> lstResult = new List <ENT.SpectroEntry>(); try { objENT.Mode = "GetSpectroDetail"; lstResult = new DAL.SpectroEntry().GetSpectroDetailForAPI(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 : GetSpectroDetail()"); return(ControllerContext.Request.CreateResponse(HttpStatusCode.InternalServerError, new { objENT, lstResult })); } }
public List <ENT.SpectroEntry> GetSpectroDetailForAPI(ENT.SpectroDetailParam objENT) { List <ENT.SpectroEntry> lstENT = new List <ENT.SpectroEntry>(); try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "GetSpectroDataForAPI"; sqlCMD.Parameters.AddWithValue("@SpectroNo", objENT.SpectroNo); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); lstENT = DBHelper.GetEntityList <ENT.SpectroEntry>(sqlCMD); } catch (Exception ex) { throw ex; } return(lstENT); }