public string ConsumptionReport(DateTime FromDate, DateTime ToDate)
{
DanpheHTTPResponse <DataTable> responseData = new DanpheHTTPResponse <DataTable>();
try
{
WardReportingDbContext wardreportingDbContext = new WardReportingDbContext(connString);
DataTable dtResult = wardreportingDbContext.ConsumptionReport(FromDate, ToDate);
responseData.Status = "OK";
responseData.Results = dtResult;
}
catch (Exception ex)
{
//Insert exception details into database table.
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string WARDStockItemsReport(int itemId)
{
DanpheHTTPResponse <DataTable> responseData = new DanpheHTTPResponse <DataTable>();
WardSupplyDbContext wardSupplyDbContext = new WardSupplyDbContext(connString);
try
{
WardReportingDbContext wardreportingDbContext = new WardReportingDbContext(connString);
DataTable stockItemsResult = wardreportingDbContext.WARDStockItemsReport(itemId);
responseData.Status = "OK";
responseData.Results = stockItemsResult;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
