private void btnSendEmail_Click(object sender, EventArgs e) { try { if (objDriverCommision.Current == null) { return; } long id = objDriverCommision.Current.Id; frmDriverCommisionTransactionExpensesReport5 frm = new frmDriverCommisionTransactionExpensesReport5(1); //if (optFullDetail.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) //{ frm.DisplayCriteria = ""; //} //else if (optAccountJobs.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) //{ // frm.DisplayCriteria = "account_"; //} //else if (optSummaryDetails.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) //{ // frm.DisplayCriteria = "summary_"; //} var list = General.GetQueryable <vu_DriverCommisionExpenses2>(a => a.Id == id).OrderBy(c => c.PickupDate).ToList(); int count = list.Count; frm.DataSource = list; var list2 = General.GetQueryable <vu_FleetDriverCommissionExpense>(c => c.CommissionId == id).OrderBy(c => c.Date).ToList(); frm.DataSource2 = list2; frm.GenerateReport(); frm.SendEmail(objDriverCommision.Current.TransNo, objDriverCommision.Current.Fleet_Driver.DefaultIfEmpty().Email.ToStr().Trim()); } catch (Exception ex) { } }
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) { frmDriverCommisionTransactionExpensesReport5 frm = new frmDriverCommisionTransactionExpensesReport5(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) { frmDriverCommisionTransactionExpensesReport5 frm = new frmDriverCommisionTransactionExpensesReport5(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) { } }