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 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 PrintStatement() { try { if (grdDriverRentLastStatement.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).Count() > 0) { //foreach (var item in grdDriverRentLastStatement.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true)) //{ // long Id = item.Cells[COLS.Id].Value.ToLong(); // ReportPrintDocument rpt = null; // frmDriverCommisionTransactionExpensesReport3 frm = null; // if (Id > 0) // { // frm = new frmDriverCommisionTransactionExpensesReport3(1); // 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.IsFareAndWaitingWise = this.IsFareAndWaitingWiseComm; // frm.GenerateReport(); // rpt = new ReportPrintDocument(frm.reportViewer1.LocalReport); // rpt.Print(); // rpt.Dispose(); // } //} var rows = grdDriverRentLastStatement.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true).ToList(); var list = (from a in rows.Where(c => c.Cells[COLS.Id].Value.ToInt() > 0) select new { Id = a.Cells[COLS.Id].Value.ToInt(), CompanyId = a.Cells[COLS.DriverId].Value.ToInt(), Driver = a.Cells[COLS.DriverNo].Value.ToStr() }).ToList(); frmInvoiceReport frm = new frmInvoiceReport(); ReportPrintDocument rpt = null; foreach (var item in list) { if (item.Id > 0) { using (TaxiDataContext db = new TaxiDataContext()) { var listInv = db.vu_Invoices.Where(a => a.Id == item.Id).OrderBy(c => c.PickupDate).ToList(); frm.DataSource = listInv; var Invoice = db.Invoices.Where(c => c.Id == item.Id).FirstOrDefault(); frm.ObjInvoice = Invoice; //var Inv= //frm.ObjInvoice = listInv.; frm.GenerateReport(); rpt = new ReportPrintDocument(frm.reportViewer1.LocalReport); rpt.Print(); rpt.Dispose(); } } } //if (list.Count > 0) //{ // frmDriverCommisionTransactionExpensesReport4 frm = new frmDriverCommisionTransactionExpensesReport4(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 PrintDocument(long TransId) { try { try { 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 = 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) { 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.GetGeneralList <Fleet_Driver>(c => c.DriverTypeId == 1); // frmEmail frmEmail = new frmEmail(null, "", ""); frmDriverTransactionExpensesReport3 frm = new frmDriverTransactionExpensesReport3(1); foreach (var item in rows) { if (optFullDetail.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { frm.DisplayCriteriaType = ""; } else if (optAccountJobs.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { frm.DisplayCriteriaType = "account_"; } else if (optSummaryDetails.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { frm.DisplayCriteriaType = "summary_"; } 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 = driversList.FirstOrDefault(C => C.Id == item.Cells["DriverId"].Value.ToInt()).DefaultIfEmpty().Gen_SubCompany.DefaultIfEmpty(); frm.CompanyHeader = frm.ObjSubCompany.CompanyName.ToStr().Trim(); frm.VAT = item.Cells["VAT"].Value.ToDecimal(); frm.GenerateReport(); ReportPrintDocument rpt = new ReportPrintDocument(frm.reportViewer1.LocalReport); rpt.Print(); rpt.Dispose(); } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } catch (Exception ex) { } }