private void PrintStatement()
{
try
{
if (grdDriverRentLastStatement.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).Count() > 0)
{
var rows = grdDriverRentLastStatement.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).ToList();
using (TaxiDataContext db = new TaxiDataContext())
{
var list = (from a in rows.Where(c => c.Cells[COLS.Id].Value.ToInt() > 0)
join b in db.Fleet_Drivers on Convert.ToInt32(a.Cells[COLS.DriverId].Value) equals b.Id
select new
{
RentId = a.Cells[COLS.Id].Value.ToInt(),
DriverId = a.Cells[COLS.DriverId].Value.ToInt(),
Driver = a.Cells[COLS.DriverNo].Value.ToStr(),
VAT = b.VAT
}).ToList();
if (list.Count > 0)
{
frmDriverRentTransactionExpensesReport3 frm = new frmDriverRentTransactionExpensesReport3(list, DateTime.Now.ToDate(), DateTime.Now.ToDate());
frm.ShowDialog();
frm.Dispose();
}
}
}
else
{
ENUtils.ShowMessage("Please select statement to Print");
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
private void EmailInvoices(long TransId)
{
bool IsSuccess = false;
try
{
string subject = txtSubject.Text.Trim();
if (string.IsNullOrEmpty(subject))
{
ENUtils.ShowMessage("Required : Email Subject");
return;
}
if (txtBody.Text.Trim().Length > 0)
{
subject += "||" + txtBody.Text;
}
List <GridViewRowInfo> rows = null;
if (TransId == 0)
{
rows = grdLister.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).ToList();
}
else
{
rows = grdLister.Rows.Where(c => c.Cells["RentId"].Value.ToLong() == TransId).ToList();
}
//List<long> invoiceIds = rows.Select(c => c.Cells["RentId"].Value.ToLong()).ToList<long>();
List <long> invoiceIds = new List <long>();
if (TransId == 0)
{
invoiceIds = rows.Select(c => c.Cells["RentId"].Value.ToLong()).ToList <long>();
}
else
{
invoiceIds = new List <long>();
invoiceIds.Add(TransId);
}
if (invoiceIds.Count > 0)
{
frmDriverRentTransactionExpensesReport3 frm = new frmDriverRentTransactionExpensesReport3(1);
frm.reportViewer1.Tag = "invoice";
var list = General.GetQueryable <vu_DriverRentExpense>(a => invoiceIds.Contains(a.Id)).ToList();
var list2 = General.GetQueryable <vu_FleetDriverRentExpense>(a => invoiceIds.Contains(a.Id)).ToList();
List <Fleet_Driver> driversList = General.GetQueryable <Fleet_Driver>(c => c.DriverTypeId == 1).ToList();
frmEmail frmEmail = new frmEmail(null, "", "");
Fleet_Driver objDriver = null;
foreach (var item in rows.Where(c => c.Cells["Check"].Value.ToBool()))
{
if (optFullDetail.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
frm.optFullDetail.ToggleState = Telerik.WinControls.Enumerations.ToggleState.On;
}
else if (optAccountJobs.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
frm.optAccountJobs.ToggleState = Telerik.WinControls.Enumerations.ToggleState.On;
}
else if (optSummaryDetails.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On)
{
frm.optSummaryDetails.ToggleState = Telerik.WinControls.Enumerations.ToggleState.On;
}
frm.DataSource = list.Where(c => c.Id == item.Cells["RentId"].Value.ToLong()).OrderBy(c => c.PickupDate).ToList();
frm.DataSource2 = list2.Where(c => c.RentId == item.Cells["RentId"].Value.ToLong()).OrderBy(c => c.Date).ToList();
// frm.objSubcompany = objSubcompany;
frm.objSubcompany = driversList.FirstOrDefault(C => C.Id == item.Cells["DriverId"].Value.ToInt()).DefaultIfEmpty().Gen_SubCompany.DefaultIfEmpty();
frm.GenerateReport(item.Cells["VAT"].Value.ToDecimal());
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 = "";
if (objDriver != null)
{
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);
}
}