public string CurrentStockLevelReport(string ItemName)
{
DanpheHTTPResponse <List <CurrentStockLevel> > responseData = new DanpheHTTPResponse <List <CurrentStockLevel> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <CurrentStockLevel> currentstocklevel = invreportingDbContext.CurrentStockLevelReport(ItemName);
responseData.Status = "OK";
responseData.Results = currentstocklevel;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string CurrentWriteOffReport(int ItemId)
{
DanpheHTTPResponse <List <CurrentWriteOff> > responseData = new DanpheHTTPResponse <List <CurrentWriteOff> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <CurrentWriteOff> currentwriteoff = invreportingDbContext.CurrentWriteOffReport(ItemId);
responseData.Status = "OK";
responseData.Results = currentwriteoff;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string FixedAssetsReport(DateTime FromDate, DateTime ToDate)
{
DanpheHTTPResponse <List <FixedAssetsModel> > responseData = new DanpheHTTPResponse <List <FixedAssetsModel> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <FixedAssetsModel> currentFixedAssets = invreportingDbContext.FixedAssetsReport(FromDate, ToDate);
responseData.Status = "OK";
responseData.Results = currentFixedAssets;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string PurchaseReport()
{
DanpheHTTPResponse <DataTable> responseData = new DanpheHTTPResponse <DataTable>();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
DataTable dsbStats = invreportingDbContext.PurchaseReports();
responseData.Status = "OK";
responseData.Results = dsbStats;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string InventorySummaryReport(DateTime FromDate, DateTime ToDate, string ItemName)
{
DanpheHTTPResponse <List <InventorySummaryModel> > responseData = new DanpheHTTPResponse <List <InventorySummaryModel> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <InventorySummaryModel> allInventorySummaryData = invreportingDbContext.InventorySummaryReport(FromDate, ToDate, ItemName);
responseData.Status = "OK";
responseData.Results = allInventorySummaryData;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string PurchaseOrderReport(DateTime FromDate, DateTime ToDate, int OrderNumber)
{
DanpheHTTPResponse <List <PurchaseOrderModel> > responseData = new DanpheHTTPResponse <List <PurchaseOrderModel> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <PurchaseOrderModel> currentPurchaseOrderlevel = invreportingDbContext.PurchaseOrderReport(FromDate, ToDate, OrderNumber);
responseData.Status = "OK";
responseData.Results = currentPurchaseOrderlevel;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
public string DailyItemDispatchReport(DateTime FromDate, DateTime ToDate, string DepartmentName)
{
DanpheHTTPResponse <List <DailyItemDispatchModel> > responseData = new DanpheHTTPResponse <List <DailyItemDispatchModel> >();
try
{
InventoryReportingDbContext invreportingDbContext = new InventoryReportingDbContext(connString);
List <DailyItemDispatchModel> currentItemdispatchlevel = invreportingDbContext.DailyItemDispatchReport(FromDate, ToDate, DepartmentName);
responseData.Status = "OK";
responseData.Results = currentItemdispatchlevel;
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message;
}
return(DanpheJSONConvert.SerializeObject(responseData));
}
