public virtual int Fill(CloudAccountDA.ReportInvoiceDetailsDataTable dataTable, int?CompanyID, int?ClientID, string Status, DateTime?FromDate, DateTime?ToDate) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (CompanyID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = CompanyID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (ClientID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = ClientID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (Status == null) { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = Status; } if (FromDate.HasValue) { this.Adapter.SelectCommand.Parameters[4].Value = FromDate.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = DBNull.Value; } if (ToDate.HasValue) { this.Adapter.SelectCommand.Parameters[5].Value = ToDate.Value; } else { this.Adapter.SelectCommand.Parameters[5].Value = DBNull.Value; } if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
private void BindGrid() { DateTime?dtFromDate = new DateTime?(); DateTime?dtToDate = new DateTime?(); string sStatus = (string)null; if (this.txtDateFrom.Text.Trim().Length > 0) { dtFromDate = new DateTime?(DateTime.Parse(this.txtDateFrom.Text.Trim())); } if (this.txtDateTo.Text.Trim().Length > 0) { dtToDate = new DateTime?(DateTime.Parse(this.txtDateTo.Text.Trim())); } if (this.ddlStatus.SelectedIndex > 0) { sStatus = this.ddlStatus.SelectedItem.Value; } if (this.ddlClient.SelectedIndex > 0) { string s = this.ddlClient.SelectedItem.Value; if (string.IsNullOrEmpty(s)) { return; } this.objReportInvoiceDetailsDT = this.objReportInvoiceDetailsBll.GetData(int.Parse(this.hfCompanyID.Value), int.Parse(s), sStatus, dtFromDate, dtToDate); Label label = new Label() { Text = this.ddlClient.SelectedItem.Text }; label.Font.Bold = true; this.divGrids.Controls.Add((Control)label); this.divGrids.Controls.Add((Control) new LiteralControl("<br />")); GridView gridView1 = new GridView(); gridView1.DataSource = (object)this.objReportInvoiceDetailsDT; gridView1.CssClass = "reportTable table table-responsive"; gridView1.Width = Unit.Percentage(100.0); gridView1.GridLines = GridLines.None; gridView1.EmptyDataText = "No invoice available in this search values."; GridView gridView2 = gridView1; gridView2.HeaderStyle.BackColor = ColorTranslator.FromHtml("#0083E0"); gridView2.HeaderStyle.ForeColor = Color.White; gridView2.RowDataBound += new GridViewRowEventHandler(this.gv_RowDataBound); gridView2.DataBind(); this.divGrids.Controls.Add((Control)gridView2); InvoiceDetailsReport.MergeRows(gridView2); this.divGrids.Controls.Add((Control) new LiteralControl("<br />")); } else { this.ddlClient.DataBind(); foreach (ListItem listItem in this.ddlClient.Items) { if (!string.IsNullOrEmpty(listItem.Value)) { this.objReportInvoiceDetailsDT = this.objReportInvoiceDetailsBll.GetData(int.Parse(this.hfCompanyID.Value), int.Parse(listItem.Value), sStatus, dtFromDate, dtToDate); Label label = new Label() { Text = listItem.Text }; label.Font.Bold = true; this.divGrids.Controls.Add((Control)label); this.divGrids.Controls.Add((Control) new LiteralControl("<br />")); GridView gridView1 = new GridView(); gridView1.DataSource = (object)this.objReportInvoiceDetailsDT; gridView1.CssClass = "reportTable table table-responsive"; gridView1.Width = Unit.Percentage(100.0); gridView1.GridLines = GridLines.None; gridView1.EmptyDataText = "No invoice available in this search values."; GridView gridView2 = gridView1; gridView2.HeaderStyle.BackColor = ColorTranslator.FromHtml("#0083E0"); gridView2.HeaderStyle.ForeColor = Color.White; gridView2.RowDataBound += new GridViewRowEventHandler(this.gv_RowDataBound); gridView2.DataBind(); InvoiceDetailsReport.MergeRows(gridView2); this.divGrids.Controls.Add((Control)gridView2); this.divGrids.Controls.Add((Control) new LiteralControl("<br />")); } } } }