public static DataSet GetLeadInLeadOutReport(string programType, string ProgramEnabled, string ProgramID, string fromMonth, int fromYear, string toMonth, int toYear, string ReportFormat, string Band, string StationEnabled, string MemberStatus, string StationId, string City, string StateId, string day, string StartTime, string EndTime)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataSetProcedure("dbo.PSP_LeadInLeadOutReport_GET",
new SqlParameter("@programType", programType),
new SqlParameter("@ProgramEnabled", ProgramEnabled),
new SqlParameter("@ProgramID", ProgramID),
new SqlParameter("@fromMonth", fromMonth),
new SqlParameter("@fromYear", fromYear),
new SqlParameter("@toMonth", toMonth),
new SqlParameter("@toYear", toYear),
new SqlParameter("@ReportFormat", ReportFormat),
new SqlParameter("@Band", Band),
new SqlParameter("@StationEnabled", StationEnabled),
new SqlParameter("@MemberStatusId", MemberStatus),
new SqlParameter("@StationId", StationId),
new SqlParameter("@City", City),
new SqlParameter("@StateId", StateId),
new SqlParameter("@Day", day),
new SqlParameter("@StartTime", StartTime),
new SqlParameter("@EndTime", EndTime)
));
}
}
public static DataSet GetCarriageListByProgramReport(string programType, string ProgramEnabled, string ProgramID, string fromMonth, int fromYear, string toMonth, int toYear, string ReportFormat, string Band, string StationEnabled, string MemberStatus, string StationId, string City, string StateId)
{
using (var sqlHelper = new InfSqlHelper())
{
return(sqlHelper.ExecuteDataSetProcedure("dbo.PSP_CarriageListByProgramReport_GET",
//new SqlParameter("@ProgramType", programType),
//new SqlParameter("@StationEnabled", ProgramEnabled),
//new SqlParameter("@FromMonth", fromMonth),
//new SqlParameter("@FromYear", fromYear),
//new SqlParameter("@ToMonth", toMonth),
//new SqlParameter("@ToYear", toYear),
//new SqlParameter("@BandSpan", ""),
//new SqlParameter("@MemberStatusName", ""),
//new SqlParameter("@Station", ""),
//new SqlParameter("@MemStatus", "")
new SqlParameter("@programType", programType),
new SqlParameter("@ProgramEnabled", ProgramEnabled),
new SqlParameter("@ProgramID", ProgramID),
new SqlParameter("@fromMonth", fromMonth),
new SqlParameter("@fromYear", fromYear),
new SqlParameter("@toMonth", toMonth),
new SqlParameter("@toYear", toYear),
new SqlParameter("@ReportFormat", ReportFormat),
new SqlParameter("@Band", Band),
new SqlParameter("@StationEnabled", StationEnabled),
new SqlParameter("@MemberStatusId", MemberStatus),
new SqlParameter("@StationId", StationId),
new SqlParameter("@City", City),
new SqlParameter("@StateId", StateId)
));
}
}
