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); }