private void LoadData() { string sFrom = Request.QueryString["datefrom"].ToString(); string sTo = Request.QueryString["dateto"].ToString(); lblDateFrom.Text = sFrom; lblDateTo.Text = sTo; DataTable dtbOverview = new DataTable(); dtbOverview.Columns.Add("ProductID", typeof(int)); dtbOverview.Columns.Add("ProductCategoryName", typeof(string)); dtbOverview.Columns.Add("Price", typeof(double)); dtbOverview.Columns.Add("ProductName", typeof(string)); dtbOverview.Columns.Add("Number", typeof(int)); dtbOverview.Columns.Add("Total", typeof(double)); dtbOverview.Columns.Add("Date_Create", typeof(string)); dtbOverview.Columns.Add("FullName", typeof(string)); dtbOverview.Columns.Add("Phone", typeof(string)); dtbOverview.Columns.Add("Address", typeof(string)); Invoice objInvoice = new Invoice(); DataTable dtbInvoice = new DataTable(); InvoiceDetails obj = new InvoiceDetails(); DataTable dtb = new DataTable(); dtb = obj.ReportbyDate(sFrom, sTo); int nCount = dtb.Rows.Count; for (int i = 0; i < nCount; i++) { string nInvoiceID = dtb.Rows[i]["InvoiceID"].ToString(); string sDate = dtb.Rows[i]["Date_Create"].ToString(); int UserID = Convert.ToInt32(dtb.Rows[i]["UserID"]); string sName = dtb.Rows[i]["FullName"].ToString(); string sAddress = dtb.Rows[i]["Address"].ToString(); string sPhone = dtb.Rows[i]["Phone"].ToString(); dtbInvoice = objInvoice.getMultipleID(nInvoiceID); int nCountInvoice = dtbInvoice.Rows.Count; for (int j = 0; j < nCountInvoice; j++) { int nNumber = Convert.ToInt32(dtbInvoice.Rows[j]["Number"]); double dTotal = Convert.ToDouble(dtbInvoice.Rows[j]["Total"]); int nProductID = Convert.ToInt32(dtbInvoice.Rows[j]["ProductID"]); string sProductName = dtbInvoice.Rows[j]["ProductName"].ToString(); double fPrice = Convert.ToDouble(dtbInvoice.Rows[j]["Price"]); string sCategoryName = dtbInvoice.Rows[j]["ProductCategoryName"].ToString(); dtbOverview.Rows.Add(nProductID, sCategoryName, fPrice, sProductName, nNumber, dTotal, sDate, sName, sPhone, sAddress); } } rptReportSale.DataSource = dtbOverview; rptReportSale.DataBind(); }
private void LoadData() { string sFrom = Request.QueryString["datefrom"].ToString(); string sTo = Request.QueryString["dateto"].ToString(); lblDateFrom.Text = sFrom; lblDateTo.Text = sTo; InvoiceDetails obj = new InvoiceDetails(); DataTable dtb = new DataTable(); //string sto= Convert.ToDateTime(sTo).ToString("ddMMyyyy"); //string from = Convert.ToDateTime(sFrom).ToString("ddMMyyyy"); dtb = obj.ReportbyDate(sFrom, sTo); rptProduct.DataSource = dtb; rptProduct.DataBind(); }