public List <SiteDispatchDetail> GetSiteDispatchDetails(SiteDispatchPayload siteDispatchPayload) { try { List <SiteDispatchDetail> result = new List <SiteDispatchDetail> (); var siteDispatchDetails = _context.Query <SiteDispatchDetail> ().FromSqlRaw("exec sp_getDispatch {0}, {1},{2},{3}", siteDispatchPayload.role_name.ToString(), siteDispatchPayload.role_hierarchy, siteDispatchPayload.ProjectId, siteDispatchPayload.VendorId).ToList(); result = _mapper.Map <List <SiteDispatchDetail> > (siteDispatchDetails); return(result); } catch (Exception ex) { throw ex; } }
public IActionResult GetSiteDispatchDetails([FromQuery] SiteDispatchPayload siteDispatchPayload) { try { var response = _siteDispatchService.GetSiteDispatchDetails(siteDispatchPayload); return(Ok(response)); } catch (Exception e) { Util.LogError(e); return(StatusCode(StatusCodes.Status500InternalServerError, new ErrorClass() { code = StatusCodes.Status500InternalServerError.ToString(), message = "Something went wrong" })); } }
public List <SiteDispatchDetail> GetSiteDispatchDetails(SiteDispatchPayload siteDispatchPayload) { List <SiteDispatchDetail> lstDispDetails = _siteDispatchRepository.GetSiteDispatchDetails(siteDispatchPayload); return(lstDispDetails); }