private void EmailInvoices()
{
try
{
string subject = txtSubject.Text.Trim();
if (string.IsNullOrEmpty(subject))
{
ENUtils.ShowMessage("Required : Email Subject");
return;
}
var rows = grdDriverRent.Rows.Where(c => c.Cells[COLS.RentId].Value.ToLong() > 0).ToList();
List <long> invoiceIds = rows.Select(c => c.Cells[COLS.RentId].Value.ToLong()).ToList <long>();
if (invoiceIds.Count > 0)
{
frmDriverTransactionReport frm = new frmDriverTransactionReport(1);
var list = General.GetQueryable <vu_DriverRent>(a => invoiceIds.Contains(a.Id)).ToList();
frm.CompanyHeader = ddlSubCompany.Text.Trim();
List <Fleet_Driver> driversList = General.GetGeneralList <Fleet_Driver>(c => c.DriverTypeId == 1);
frmEmail frmEmail = new frmEmail(null, "", "");
foreach (var item in rows)
{
frm.DataSource = list.Where(c => c.Id == item.Cells[COLS.RentId].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();
if (!string.IsNullOrEmpty(email))
{
frm.SendEmailInternally(frmEmail, subject, item.Cells[COLS.DriverNo].Value.ToStr().Trim(), email);
}
}
ENUtils.ShowMessage("Email has been sent successfully");
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
public bool SendEmailInternally(frmEmail frmE, string subject, string invoiceNo, string email)
{
frmE.ReportViewer1 = this.reportViewer1;
frmE.FileTitle = "Rent for " + invoiceNo.ToStr();
frmE.ToEmail = email;
frmE.txtTo.Text = email;
if (subject.ToStr().Contains("||"))
{
try
{
var arr = subject.ToStr().Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);
subject = arr[0];
frmE.txtBody.Text = arr[1];
}
catch
{
}
}
frmE.EmailSubject = subject;
frmE.txtSubject.Text = subject;
frmE.txtAttachment.Text = "Rent for " + invoiceNo;
frmE.SendEmail(true);
return(frmE.IsEmailSent);
// General.ShowEmailForm(reportViewer1, "Account Invoice # " + invoiceNo, email);
}
private void btnEmail_Click_1(object sender, EventArgs e)
{
companyEmail = AppVars.objSubCompany.EmailAddress;
frmEmail frm = new frmEmail(reportViewer1, companyEmail);
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
}
public void SendEmailInternally(frmEmail frmE, string subject, string invoiceNo, string email)
{
frmE.ReportViewer1 = this.reportViewer1;
frmE.FileTitle = "Rent for " + invoiceNo.ToStr();
frmE.EmailSubject = subject;
frmE.ToEmail = email;
frmE.txtTo.Text = email;
frmE.txtSubject.Text = subject;
frmE.txtAttachment.Text = "Rent for " + invoiceNo;
frmE.SendEmail(true);
// General.ShowEmailForm(reportViewer1, "Account Invoice # " + invoiceNo, email);
}
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(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)
{
frmDriverCommisionTransactionExpensesReport3 frm = new frmDriverCommisionTransactionExpensesReport3(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)
{
frmDriverCommisionTransactionExpensesReport3 frm = new frmDriverCommisionTransactionExpensesReport3(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)
{
}
}
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);
}
}
