void SetupGridPrinter() { DataTable sampleDataTable = new DataTable("ATABLE"); sampleDataTable.Columns.Add("Building Name", typeof(string)); sampleDataTable.Columns.Add("Space unit", typeof(string)); sampleDataTable.Columns.Add("Date", typeof(string)); sampleDataTable.Columns.Add("Contractor Name", typeof(string)); sampleDataTable.Columns.Add("Installment Due", typeof(string)); sampleDataTable.Columns.Add("Contact No", typeof(string)); // sampleDataTable.Columns.Add("Type", typeof(string)); sampleDataTable.Columns.Add("Status", typeof(string)); var report = da.GetMonthlyReport(DateTime.Parse(ddFromDate.Text), DateTime.Parse(ddToDate.Text), PaymentStatus.COMPLETE); DataRow sampleDataRow; foreach (var c in report) { sampleDataRow = sampleDataTable.NewRow(); sampleDataRow["Building Name"] = c.BuildingName.ToString(CultureInfo.CurrentCulture); sampleDataRow["Space unit"] = c.Typeno.ToString(CultureInfo.CurrentCulture); sampleDataRow["Date"] = c.Date.ToShortDateString(); sampleDataRow["Contractor Name"] = c.Name; sampleDataRow["Installment Due"] = c.InstallmentAmount.ToString( ); sampleDataRow["Contact No"] = c.ContactNo.ToString(CultureInfo.CurrentCulture); // sampleDataRow["Type"] = c.Type; sampleDataRow["Status"] = c.Status; } dataGridPrinter1 = new DataGridPrinter(dataGridView1, printDocument1, sampleDataTable); }
void SetupGridPrinter() { DataTable sampleDataTable = new DataTable("ATABLE"); sampleDataTable.Columns.Add("Building Name", typeof(string)); sampleDataTable.Columns.Add("Space unit", typeof(string)); sampleDataTable.Columns.Add("Date", typeof(string)); sampleDataTable.Columns.Add("Contractor Name", typeof(string)); if (!isMonthlyReport) { sampleDataTable.Columns.Add("Agreement", typeof(string)); } sampleDataTable.Columns.Add("Installment Due", typeof(string)); if (!isMonthlyReport) { sampleDataTable.Columns.Add("Contact No 1", typeof(string)); sampleDataTable.Columns.Add("Contact No 2", typeof(string)); } else { sampleDataTable.Columns.Add("Type", typeof(string)); } sampleDataTable.Columns.Add("Status", typeof(string)); var report = da.GetMonthlyReport(DateTime.Parse(ddFromDate.Text), DateTime.Parse(ddToDate.Text), isMonthlyReport ? PaymentStatus.COMPLETE : PaymentStatus.DUE); DataRow sampleDataRow; foreach (var c in report) { string[] contacts = c.ContactNo.Split('/'); sampleDataRow = sampleDataTable.NewRow(); sampleDataRow["Building Name"] = c.BuildingName.ToString(CultureInfo.CurrentCulture); sampleDataRow["Space unit"] = c.Typeno.ToString(CultureInfo.CurrentCulture); sampleDataRow["Date"] = c.Date.ToShortDateString(); sampleDataRow["Contractor Name"] = c.Name; if (!isMonthlyReport) { sampleDataRow["Agreement"] = c.Agreement.ToString( ); } sampleDataRow["Installment Due"] = c.InstallmentAmount.ToString( ); if (!isMonthlyReport) { sampleDataRow["Contact No 1"] = contacts[0].ToString(CultureInfo.CurrentCulture); sampleDataRow["Contact No 2"] = contacts.Length > 1 ? contacts[1].ToString(CultureInfo.CurrentCulture) : ""; } else { sampleDataRow["Type"] = c.Type; } sampleDataRow["Status"] = c.Status; sampleDataTable.Rows.Add(sampleDataRow); } totalPages = (sampleDataTable.Rows.Count + 14) / 25; dataGridPrinter1 = new DataGridPrinter(dataGridView1, printDocument1, sampleDataTable); }