public DataTable Receiptno(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repReceiptno", new object[] { reportProp.SubDivision, reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId, reportProp.Receiptno }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable DailyCRTransactionWiseexport(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repDailyChequeTransactionWise", new object[] { reportProp.SubDivision, reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId, reportProp.ForGrid }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable CancelTrasaction(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repCancelTrasaction", new object[] { reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable ReportDailyPCSheet(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repDailyPaymentControlSheet", new object[] { reportProp.SubDivision, reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId, reportProp.ForGrid }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable DatewiseSPTSexport(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repPayTransSummaryDatewiseSubDivision_export", new object[] { reportProp.CounterName, reportProp.SubDivision, reportProp.fromdate, reportProp.todate, reportProp.UserId }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable DatewiseSTS(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repTrasactionSummaryDatewiseSubDivisonwise", new object[] { reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable DailyLoginLogout(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repUserLoginLogout", new object[] { reportProp.CounterName, reportProp.fromdate, reportProp.todate, reportProp.UserId }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable PopulateCounterUserwise(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_Counter_Search_user", new object[] { reportProp.UserName }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable DailyCSUserWise(report_Prop reportProp)
{
try
{
return(SqlHelper.ExecuteDataset(com.con, "usp_repDailyCollectionSummaryUserwise", new object[] { reportProp.CounterName, reportProp.UserName, reportProp.fromdate, reportProp.todate, reportProp.UserId, reportProp.ForGrid }).Tables[0]);
}
catch (Exception e)
{
throw e;
}
}
public DataTable Receiptno(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.Receiptno(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable CancelTrasactionexport(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.CancelTrasactionexport(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable DatewiseSPTSexport(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.DatewiseSPTSexport(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable DailyDateSubDivisionWiseSummary(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.DailyDateSubDivisionWiseSummary(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable PopulateCounterUserwise(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.PopulateCounterUserwise(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}
public DataTable DailyCRTransactionWise(report_Prop reportProp)
{
try
{
reportdal = new report_dal();
DataTable dt = reportdal.DailyCRTransactionWise(reportProp);
return(dt);
}
catch (Exception e)
{
ErrMessage = e.Message;
return(null);
}
}