private void GetInvoiceReportData(DateTime date, int customer)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
var ds1 = (from x in dailydb.vwCustomerDetail
where x.CustomerID == customer
select x).ToList();
var ds2 = dailydb.GetOrderbyDay(date, customer).ToList();
if (ds1.Count() > 0 && ds2.Count() > 0)
{
ReportParameter p1 = new ReportParameter("ReportType", ReportName);
ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString());
ReportParameter p3 = new ReportParameter("DocumentNo", "INV");
ReportParameter p4 = new ReportParameter("BahtText", BahtToText(ds2));
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 });
CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1);
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource);
ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
reportViewer1.LocalReport.DataSources.Add(rtpsource2);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
//private void LoadReport()
//{
// reportViewer1.ProcessingMode = ProcessingMode.Local;
// //string date = "16/11/2017";
// //DateTime dt = Convert.ToDateTime(date);
// //GetSalesOrderData(dt, 3);
//}
#region GET REPORT DATA
private void GetSalesOrderData(DateTime date, int customer)
{
using (var dailydb = new OrderEntities())
{
// Get result from Stored Procedure
var ds = dailydb.GetOrderbyDay(date, customer).ToList();
//OrderUC orderUC = new OrderUC();
if (ds.Count() > 0)
{
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds);
ReportDataSource rtpsource = new ReportDataSource("DataSet1", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
private void GetInvoiceReportData(DateTime date, int customer)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
//var ds1 = (from x in dailydb.vwCustomerDetail
// where x.CustomerID == customer
// select x).ToList();
List <GetOrderCustomer_Result> ds1 = null;
List <GetOrderbyDay_Result> ds2 = null;
ds1 = dailydb.GetOrderCustomer(date, customer, "INV").ToList();
ds2 = dailydb.GetOrderbyDay(date, customer).ToList();
if (ds1.Count() > 0 && ds2.Count() > 0)
{
string docid = (from c in ds1 select(string) c.DocumentID).FirstOrDefault();
string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy");
ReportParameter p1 = new ReportParameter("ReportType", ReportName);
//ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString());
ReportParameter p2 = new ReportParameter("Date", datestring);
ReportParameter p3 = new ReportParameter("BahtText", BahtToText(ds2.Sum(item => item.OrderTotal)));
ReportParameter p4 = new ReportParameter("DocumentID", docid);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 });
CustomerBindingSource.DataSource = null;
OrderBindingSource.DataSource = null;
CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1);
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource);
ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
reportViewer1.LocalReport.DataSources.Add(rtpsource2);
}
else
{
CustomerBindingSource.DataSource = null;
OrderBindingSource.DataSource = null;
}
}
}