public DynamicReport GovReportSummary(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> paramsList = new List <SqlParameter>();
paramsList.Add(new SqlParameter("@FromDate", FromDate));
paramsList.Add(new SqlParameter("@ToDate", ToDate));
ReportingDbContext reportingDbContext = new ReportingDbContext(this.connStr);
DataSet dsCtrUsrs = DALFunctions.GetDatasetFromStoredProc("SP_Report_Gov_Summary", paramsList, reportingDbContext);
if (dsCtrUsrs != null && dsCtrUsrs.Tables.Count > 0)
{
DynamicReport dReport = new DynamicReport();
//return an anonymous type with counter and user collection..
var reports = new { OutNEmergServices = dsCtrUsrs.Tables[0], DiagnosticService = dsCtrUsrs.Tables[1] };
dReport.JsonData = JsonConvert.SerializeObject(reports,
new IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd"
});
return(dReport);
}
return(null);
}
public DataTable GetFractionReportByDoctorList(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate), new SqlParameter("@ToDate", ToDate)
};
DataTable result = DALFunctions.GetDataTableFromStoredProc("SP_FRC_GetTotalFractionbyDoctor", paramList, this);
return(result);
}
public DataTable trailBalanceReport(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> spParam = new List <SqlParameter>();
spParam.Add(new SqlParameter("@FromDate", FromDate));
spParam.Add(new SqlParameter("@ToDate", ToDate));
DataTable trailBalance = DALFunctions.GetDataTableFromStoredProc("SP_Report_ACC_TrailBalance", spParam, this);
return(trailBalance);
}
public DataTable BilTxnItemsDateWise(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> spParam = new List <SqlParameter>();
spParam.Add(new SqlParameter("@FromDate", FromDate));
spParam.Add(new SqlParameter("@ToDate", ToDate));
DataTable BillingTxn = DALFunctions.GetDataTableFromStoredProc("SP_ACC_GetBillingTransactions", spParam, this);
return(BillingTxn);
}
///// Get DataTable From SP without Any Input Parameters
public static DataTable GetDataTableFromStoredProc(string storedProcName, DbContext dbContext)
{
try
{
DataSet ds = DALFunctions.GetDatasetFromStoredProc(storedProcName, null, dbContext);
return(ds.Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
//#region Profit Loss Report
//public DataSet profitLossReport()
//{
// DataSet profitLoss = DALFunctions.GetDatasetFromStoredProc("SP_Report_ACC_ProfitLossStatement", null, this);
// return profitLoss;
//}
//#endregion
#region Get Billing TxnItems for transfer to accounting group by CreatedOn and ServiceDept wise
public DataTable BilTxnItemsGroupByDeptWise()
{
try
{
DataTable bilTxnItemsDS = DALFunctions.GetDataTableFromStoredProc("SP_ACC_GetBilTxnItemsServDeptWise", this);
return(bilTxnItemsDS);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable INVGoodsReceiptData()
{
try
{
DataTable invGRDT = DALFunctions.GetDataTableFromStoredProc("[SP_ACC_GetINVGoodsReceiptData]", this);
return(invGRDT);
}
catch (Exception ex)
{
throw ex;
}
}
//public DataSet BilTxnItemsDateWise(DateTime FromDate, DateTime ToDate)
//{
// // AccountingDbContext accountingDBContext = new AccountingDbContext(connString);
// List<SqlParameter> paramList = new List<SqlParameter>()
// {
// new SqlParameter("@FromDate", FromDate),
// new SqlParameter("@ToDate", ToDate)
// };
// DataSet txn = DALFunctions.GetDatasetFromStoredProc("SP_ACC_GetBillingTransactions", paramList, this);
// return txn;
//}
#endregion
#region Get phrm TxnItems datewise for transfer to accounting
public DataSet InvTxnsDateWise(DateTime FromDate, DateTime ToDate)
{
// AccountingDbContext accountingDBContext = new AccountingDbContext(connString);
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate)
};
DataSet txn = DALFunctions.GetDatasetFromStoredProc("SP_ACC_GetInventoryTransactions", paramList, this);
return(txn);
}
//Sud: 14sept'18 --
public DataTable GetItemsForBillingReceipt(int patientId, int?billingTxnId, string billStatus)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@PatientId", patientId),
new SqlParameter("@BillTxnId", billingTxnId.HasValue ? billingTxnId.Value : (int?)null),
new SqlParameter("@BillStatus", billStatus)
};
DataTable discountReportData = DALFunctions.GetDataTableFromStoredProc("SP_BIL_GetItems_ForIPBillingReceipt", paramList, this);
return(discountReportData);
}
public DynamicReport PHRM_Daily_StockValue()
{
List <SqlParameter> paramsList = new List <SqlParameter>();
ReportingDbContext reportingDbContext = new ReportingDbContext(this.connStr);
DataSet dsDailyRev = DALFunctions.GetDatasetFromStoredProc("SP_Report_PHRM_Daily_StockValue", paramsList, reportingDbContext);
DynamicReport dReport = new DynamicReport();
dReport.Schema = null;//we have only one table returning from the database..
//wee need datetime in yyyy-MM-dd format.
dReport.JsonData = JsonConvert.SerializeObject(dsDailyRev.Tables[0],
new IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd"
});
return(dReport);
}
public DataTable PHRMStockItemsReport(string ItemName)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ItemName", ItemName)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_StockItemsReport", paramList, this);
return(stockItems);
}
public DataTable WARDStockItemsReport(int ItemId)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ItemId", ItemId)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_WardReport_StockReport", paramList, this);
return(stockItems);
}
public DataTable PHRMDispensaryStoreStockReport(string Status)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@Status", Status),
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_DispensaryStoreStockReport", paramList, this);
return(stockItems);
}
public DataTable PHRMDailyStockSummaryReport(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable dailyStkSummary = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_DailyStockSummaryReport", paramList, this);
return(dailyStkSummary);
}
public DataTable PHRMSupplierStockReport(string SupplierName)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@SupplierName", SupplierName)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable supplierStock = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_SupplierStockReport", paramList, this);
return(supplierStock);
}
public DataTable PHRMReturnToSupplierReport(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable returntosupplier = DALFunctions.GetDataTableFromStoredProc("SP_PHRM_ReturnToSupplierReport", paramList, this);
return(returntosupplier);
}
public DataTable WARDConsumptionReport(DateTime FromDate, DateTime ToDate)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_WardReport_ConsumptionReport", paramList, this);
return(stockItems);
}
public DataTable PHRMGoodReceiptProductReport(DateTime FromDate, DateTime ToDate, int ItemId)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@ItemId", ItemId)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_PHRM_GoodsReceiptProductReport", paramList, this);
return(stockItems);
}
public DataTable PHRMPurchaseOrderReport(DateTime FromDate, DateTime ToDate, string Status)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@Status", Status)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_PurchaseOrderSummaryReport", paramList, this);
return(stockItems);
}
public DataTable PHRMBillingReport(DateTime FromDate, DateTime ToDate, int InvoiceNumber)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@InvoiceNumber", InvoiceNumber)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable billingreport = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_BillingReport", paramList, this);
return(billingreport);
}
public DataTable PHRMCreditInOutPatReport(DateTime FromDate, DateTime ToDate, bool IsInOutPat, string patientName)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@IsInOutPat", IsInOutPat)
//new SqlParameter("@patientName", patientName)
};
foreach (SqlParameter parameter in paramList)
{
if (parameter.Value == null)
{
parameter.Value = "";
}
}
DataTable creditInOutPat = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_LedgerCredit_IndoorOutdoorPatient", paramList, this);
return(creditInOutPat);
}
public DataTable InventoryValuation()
{
DataTable invValuationData = DALFunctions.GetDataTableFromStoredProc("SP_Report_Inventory_InventoryValuation", this);
return(invValuationData);
}
public DataTable PurchaseReports()
{
DataTable PurRep = DALFunctions.GetDataTableFromStoredProc("SP_Report_Inventory_Purchase", this);
return(PurRep);
}
public DataTable PHRMSupplierInformationReport()
{
DataTable doctorRevenue = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_SupplierInfoReport", this);
return(doctorRevenue);
}
public DataTable ComparisonPOGR()
{
DataTable cmpPOGR = DALFunctions.GetDataTableFromStoredProc("SP_Report_Inventory_ComparePoAndGR", this);
return(cmpPOGR);
}
public DataTable PHRMDepositBalanceReport()
{
DataTable stockItems = DALFunctions.GetDataTableFromStoredProc("SP_PHRMReport_DepositBalanceReport", this);
return(stockItems);
}
public DataTable GetFractionReportByItemList()
{
DataTable result = DALFunctions.GetDataTableFromStoredProc("SP_FRC_GetTotalFractionbyItem", this);
return(result);
}
public DataTable GetFractionApplicable()
{
DataTable result = DALFunctions.GetDataTableFromStoredProc("SP_FRC_GetFractionApplicableList", this);
return(result);
}
public DataTable BedFeatureReprot()
{
DataTable bedfeature = DALFunctions.GetDataTableFromStoredProc("ADT_BedFeature", this);
return(bedfeature);
}
