private void EmailInvoices(long TransId) { bool IsSuccess = false; try { string subject = txtSubject.Text.Trim(); if (string.IsNullOrEmpty(subject)) { ENUtils.ShowMessage("Required : Email Subject"); return; } List <GridViewRowInfo> rows = null; if (TransId == 0) { rows = grdDriverCommission.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).ToList(); } else { rows = grdDriverCommission.Rows.Where(c => c.Cells["CommissionId"].Value.ToLong() == TransId).ToList(); } //List<long> invoiceIds = rows.Select(c => c.Cells["CommissionId"].Value.ToLong()).ToList<long>(); List <long> invoiceIds = new List <long>(); if (TransId == 0) { invoiceIds = rows.Select(c => c.Cells["CommissionId"].Value.ToLong()).ToList <long>(); } else { invoiceIds = new List <long>(); invoiceIds.Add(TransId); } if (invoiceIds.Count > 0) { frmDriverCommisionTransactionExpensesReport2 frm = new frmDriverCommisionTransactionExpensesReport2(1); var list = General.GetQueryable <vu_DriverCommisionExpenses2>(a => invoiceIds.Contains(a.Id)).ToList(); var list2 = General.GetQueryable <vu_FleetDriverCommissionExpense>(a => invoiceIds.Contains(a.Id)).ToList(); List <Fleet_Driver> driversList = General.GetQueryable <Fleet_Driver>(c => c.DriverTypeId == 2).ToList(); frmEmail frmEmail = new frmEmail(null, "", ""); Fleet_Driver objDriver = null; foreach (var item in rows.Where(c => c.Cells["Check"].Value.ToBool())) { frm.DataSource = list.Where(c => c.Id == item.Cells["CommissionId"].Value.ToLong()).OrderBy(c => c.PickupDate).ToList(); frm.DataSource2 = list2.Where(c => c.CommissionId == item.Cells["CommissionId"].Value.ToLong()).OrderBy(c => c.Date).ToList(); frm.GenerateReport(); objDriver = driversList.FirstOrDefault(c => c.Id == item.Cells["DriverId"].Value.ToInt()); //string email = driversList.FirstOrDefault(c => c.Id == item.Cells[COLS.Id].Value.ToInt()).DefaultIfEmpty().Email.ToStr().Trim(); string email = objDriver.Email.ToStr().Trim(); if (!string.IsNullOrEmpty(email)) { IsSuccess = frm.SendEmailInternally(frmEmail, subject, objDriver.DriverNo.ToStr().Trim(), email); } } if (frmEmail != null && frmEmail.IsDisposed == false) { frmEmail.Close(); GC.Collect(); } if (IsSuccess) { RadDesktopAlert alert = new RadDesktopAlert(); alert.ContentText = "Email has been sent successfully"; alert.Show(); } // ENUtils.ShowMessage("Email has been sent successfully"); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void PrintDocument(long TransId) { try { try { List <GridViewRowInfo> rows = null; if (TransId == 0) { rows = grdDriverCommission.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).ToList(); } else { rows = grdDriverCommission.Rows.Where(c => c.Cells["CommissionId"].Value.ToLong() == TransId).ToList(); } List <long> invoiceIds = new List <long>(); if (TransId == 0) { invoiceIds = rows.Select(c => c.Cells["CommissionId"].Value.ToLong()).ToList <long>(); } else { invoiceIds = new List <long>(); invoiceIds.Add(TransId); } if (invoiceIds.Count > 0) { frmDriverCommisionTransactionExpensesReport2 frm = new frmDriverCommisionTransactionExpensesReport2(1); frm.CompanyHeader = AppVars.objSubCompany.CompanyName.ToStr().Trim(); var list = General.GetQueryable <vu_DriverCommisionExpenses2>(a => invoiceIds.Contains(a.Id)).ToList(); var list2 = General.GetQueryable <vu_FleetDriverCommissionExpense>(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["CommissionId"].Value.ToLong()).OrderBy(c => c.PickupDate).ToList(); frm.DataSource2 = list2.Where(c => c.CommissionId == item.Cells["CommissionId"].Value.ToLong()).OrderBy(c => c.Date).ToList(); frm.GenerateReport(); ReportPrintDocument rpt = new ReportPrintDocument(frm.reportViewer1.LocalReport); rpt.Print(); rpt.Dispose(); } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } catch (Exception ex) { } }