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