// genarate Sales report
public static ReportClass Sales(DateTime?from, DateTime?To)
{
OdbcDataAdapter reportAdapter;
DataSet reportDataSet;
ReportClass currentReport = null;
if (from == null || To == null)
{
reportAdapter = new OdbcDataAdapter("select * from salesview", DBConnection.getConnection());
}
else
{
reportAdapter = new OdbcDataAdapter("select * from salesview where InvoiceDate between date(?) and date(?)", DBConnection.getConnection());
reportAdapter.SelectCommand.Parameters.Add("@from", OdbcType.VarChar).Value = String.Format("{0:yyyy-MM-dd}", from);
reportAdapter.SelectCommand.Parameters.Add("@to", OdbcType.VarChar).Value = String.Format("{0:yyyy-MM-dd}", To);
}
reportDataSet = new reportDS();
reportAdapter.Fill(reportDataSet, "sales");
if (reportDataSet.Tables["sales"].Rows.Count > 0)
{
currentReport = new RptSales();
currentReport.SetDataSource(reportDataSet);
}
return(currentReport);
}
// genarate order report
public static ReportClass Orders()
{
OdbcDataAdapter reportAdapter;
DataSet reportDataSet;
ReportClass currentReport = null;
reportAdapter = new OdbcDataAdapter("call OrderView()", DBConnection.getConnection());
reportDataSet = new reportDS();
reportAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
reportAdapter.Fill(reportDataSet, "Orders");
if (reportDataSet.Tables["Orders"].Rows.Count > 0)
{
currentReport = new RptOrders();
currentReport.SetDataSource(reportDataSet);
}
return(currentReport);
}
// genarate Stock Demand report
public static ReportClass StockDemand(DateTime?from, DateTime?To)
{
OdbcDataAdapter reportAdapter;
DataSet reportDataSet;
ReportClass currentReport = null;
reportAdapter = new OdbcDataAdapter("call StockDemand(?,?)", DBConnection.getConnection());
reportAdapter.SelectCommand.Parameters.Add("@from", OdbcType.VarChar).Value = (from == null)?"":String.Format("{0:yyyy-MM-dd}", from);
reportAdapter.SelectCommand.Parameters.Add("@to", OdbcType.VarChar).Value = (To == null) ? "" : String.Format("{0:yyyy-MM-dd}", To);
reportDataSet = new reportDS();
reportAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
reportAdapter.Fill(reportDataSet, "StockDemand");
if (reportDataSet.Tables["StockDemand"].Rows.Count > 0)
{
currentReport = new RptStockDemand();
currentReport.SetDataSource(reportDataSet);
}
return(currentReport);
}
