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)
{
}
}