private void PrintDocument() { try { try { var rows = grdDriverCommission.Rows.Where(c => c.Cells[COLS.CommissionId].Value.ToLong() > 0).ToList(); List <long> invoiceIds = rows.Select(c => c.Cells[COLS.CommissionId].Value.ToLong()).ToList <long>(); if (invoiceIds.Count > 0) { frmDriverCommisionTransactionReport frm = new frmDriverCommisionTransactionReport(1); frm.CompanyHeader = ddlSubCompany.Text.Trim(); var list = General.GetQueryable <vu_DriverCommision>(a => invoiceIds.Contains(a.Id)).ToList(); List <Fleet_Driver> driversList = General.GetGeneralList <Fleet_Driver>(c => c.DriverTypeId == 2); frmEmail frmEmail = new frmEmail(null, "", ""); foreach (var item in rows) { frm.DataSource = list.Where(c => c.Id == item.Cells[COLS.CommissionId].Value.ToLong()).OrderBy(c => c.PickupDate).ToList(); frm.GenerateReport(); ReportPrintDocument rpt = new ReportPrintDocument(frm.reportViewer1.LocalReport); rpt.Print(); rpt.Dispose(); } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } catch (Exception ex) { } }
private void EmailInvoices() { try { string subject = txtSubject.Text.Trim(); if (string.IsNullOrEmpty(subject)) { ENUtils.ShowMessage("Required : Email Subject"); return; } var rows = grdDriverCommission.Rows.Where(c => c.Cells[COLS.CommissionId].Value.ToLong() > 0).ToList(); List <long> invoiceIds = rows.Select(c => c.Cells[COLS.CommissionId].Value.ToLong()).ToList <long>(); if (invoiceIds.Count > 0) { //frmDriverTransactionReport frm = new frmDriverTransactionReport(1); frmDriverCommisionTransactionReport frm = new frmDriverCommisionTransactionReport(1); var list = General.GetQueryable <vu_DriverCommision>(a => invoiceIds.Contains(a.Id)).ToList(); // frm.CompanyHeader = ddlSubCompany.Text.Trim(); List <Fleet_Driver> driversList = General.GetGeneralList <Fleet_Driver>(c => c.DriverTypeId == 2); frmEmail frmEmail = new frmEmail(null, "", ""); foreach (var item in rows.Where(c => c.Cells["Check"].Value.ToBool())) { frm.DataSource = list.Where(c => c.Id == item.Cells[COLS.CommissionId].Value.ToLong()).OrderBy(c => c.PickupDate).ToList(); frm.GenerateReport(); //string email = driversList.FirstOrDefault(c => c.Id == item.Cells[COLS.Id].Value.ToInt()).DefaultIfEmpty().Email.ToStr().Trim(); string email = item.Cells[COLS.DriverEmail].Value.ToStr(); if (!string.IsNullOrEmpty(email)) { frm.SendEmailInternally(frmEmail, subject, item.Cells[COLS.DriverNo].Value.ToStr().Trim(), email); } } if (frmEmail != null && frmEmail.IsDisposed == false) { frmEmail.Close(); GC.Collect(); } ENUtils.ShowMessage("Email has been sent successfully"); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }