private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch{}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch{}
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
switch (ReportType)
{
case "Posted PO":
Data.PO clsPO = new Data.PO();
dt = clsPO.ListAsDataTable(POStatus.Posted, new Data.PODetails(), Constants.C_DATE_MIN_VALUE, Constants.C_DATE_MIN_VALUE, PostingDateFrom, PostingDateTo);
clsPO.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPO = rptds.PO.NewRow();
foreach (DataColumn dc in rptds.PO.Columns)
drPO[dc] = dr[dc.ColumnName];
rptds.PO.Rows.Add(drPO);
}
break;
case "Posted PO Returns":
Data.POReturns clsPOReturns = new Data.POReturns();
dt = clsPOReturns.ListAsDataTable(POReturnStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo);
clsPOReturns.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPOReturns = rptds.POReturns.NewRow();
foreach (DataColumn dc in rptds.POReturns.Columns)
drPOReturns[dc] = dr[dc.ColumnName];
rptds.POReturns.Rows.Add(drPOReturns);
}
break;
case "Posted Debit Memo":
Data.DebitMemos clsDebitMemos = new Data.DebitMemos();
dt = clsDebitMemos.ListAsDataTable(DebitMemoStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo);
clsDebitMemos.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drDebitMemos = rptds.DebitMemo.NewRow();
foreach (DataColumn dc in rptds.DebitMemo.Columns)
drDebitMemos[dc] = dr[dc.ColumnName];
rptds.DebitMemo.Rows.Add(drDebitMemos);
}
break;
case "By Vendor":
Data.PurchaseAnalysis clsPurchaseAnalysis = new Data.PurchaseAnalysis();
dt = clsPurchaseAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsPurchaseAnalysis.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.PurchaseAnalysisPerVendor.NewRow();
foreach (DataColumn dc in rptds.PurchaseAnalysisPerVendor.Columns)
drPAByVendor[dc] = dr[dc.ColumnName];
rptds.PurchaseAnalysisPerVendor.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
DateTime PostingDateFrom = DateTime.MinValue;
try
{ PostingDateFrom = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch {}
DateTime PostingDateTo = DateTime.MinValue;
try
{ PostingDateTo = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch {}
eSalesFilter clseSalesFilter = new eSalesFilter();
if (lblTask.Text == "esales")
{
clseSalesFilter.FilterIncludeIneSales = true;
clseSalesFilter.IncludeIneSales = true;
}
DataClass clsDataClass = new DataClass();
System.Data.DataTable dt;
string ReportType = cboReportType.SelectedItem.Text;
long lngSupplierID = long.Parse(cboSupplier.SelectedValue);
switch (ReportType)
{
case "Posted PO":
Data.PO clsPO = new Data.PO();
dt = clsPO.ListAsDataTable(POStatus.Posted, new Data.PODetails(), Constants.C_DATE_MIN_VALUE, Constants.C_DATE_MIN_VALUE, PostingDateFrom, PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsPO.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPO = rptds.PO.NewRow();
foreach (DataColumn dc in rptds.PO.Columns)
{
drPO[dc] = dr[dc.ColumnName];
}
rptds.PO.Rows.Add(drPO);
}
break;
case "Posted PO Returns":
Data.POReturns clsPOReturns = new Data.POReturns();
dt = clsPOReturns.ListAsDataTable(POReturnStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsPOReturns.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPOReturns = rptds.POReturns.NewRow();
foreach (DataColumn dc in rptds.POReturns.Columns)
{
drPOReturns[dc] = dr[dc.ColumnName];
}
rptds.POReturns.Rows.Add(drPOReturns);
}
break;
case "Posted Debit Memo":
Data.DebitMemos clsDebitMemos = new Data.DebitMemos();
dt = clsDebitMemos.ListAsDataTable(DebitMemoStatus.Posted, PostingStartDate: PostingDateFrom, PostingEndDate: PostingDateTo, SupplierID: lngSupplierID, clseSalesFilter: clseSalesFilter);
clsDebitMemos.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drDebitMemos = rptds.DebitMemo.NewRow();
foreach (DataColumn dc in rptds.DebitMemo.Columns)
{
drDebitMemos[dc] = dr[dc.ColumnName];
}
rptds.DebitMemo.Rows.Add(drDebitMemos);
}
break;
case "By Vendor":
Data.PurchaseAnalysis clsPurchaseAnalysis = new Data.PurchaseAnalysis();
dt = clsPurchaseAnalysis.ByVendor(PostingDateFrom, PostingDateTo);
clsPurchaseAnalysis.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drPAByVendor = rptds.PurchaseAnalysisPerVendor.NewRow();
foreach (DataColumn dc in rptds.PurchaseAnalysisPerVendor.Columns)
{
drPAByVendor[dc] = dr[dc.ColumnName];
}
rptds.PurchaseAnalysisPerVendor.Rows.Add(drPAByVendor);
}
break;
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
