private void ExportReport(string exportTo) { try { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); frm.ObjInvoice = objMaster.Current; var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); frm.ExportReport(objMaster.Current.InvoiceNo, "pdf"); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } //if (objMaster.Current == null || objMaster.Current.Id == 0) return; //long id = objMaster.Current.Id; //frmPreAccInvoiceReport frm = new frmPreAccInvoiceReport(); //var list = General.GetQueryable<vu_Invoice>(a => a.Id == id).ToList(); //int count = list.Count; //frm.DataSource = list; //frm.GenerateReport(); //frm.ExportReport(objMaster.Current.InvoiceNo); }
private void btnSendEmail_Click(object sender, EventArgs e) { try { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); frm.ObjInvoice = objMaster.Current; var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); frm.SendEmail(objMaster.Current.InvoiceNo, this.companyEmail); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } //if (objMaster.Current == null || objMaster.Current.Id == 0) return; //long id = objMaster.Current.Id; //frmPreAccInvoiceReport frm = new frmPreAccInvoiceReport(); //var list = General.GetQueryable<vu_Invoice>(a => a.Id == id).ToList(); //int count = list.Count; //frm.DataSource = list; //frm.GenerateReport(); //frm.SendEmail(objMaster.Current.InvoiceNo, this.companyEmail); }
public override void Print() { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).OrderBy(c => c.PickupDate).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmInvoiceReport1"); if (doc != null) { doc.Close(); } UI.MainMenuForm.MainMenuFrm.ShowForm(frm); // MainMenuForm.MainMenuFrm.ShowForm(frm); }
public override void Print() { //if (objMaster.Current == null || objMaster.Current.Id == 0) return; //long id = objMaster.Current.Id; //frmPreAccInvoiceReport frm = new frmPreAccInvoiceReport(); //var list = General.GetQueryable<vu_Invoice>(a => a.Id == id).ToList(); //int count = list.Count; //frm.DataSource = list; //frm.GenerateReport(); //DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmPreAccInvoiceReport1"); //if (doc != null) //{ // doc.Close(); //} //UI.MainMenuForm.MainMenuFrm.ShowForm(frm); try { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); frm.ObjInvoice = objMaster.Current; var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); DockWindow doc = UI.MainMenuForm.MainMenuFrm.GetDockByName("frmInvoiceReport1"); if (doc != null) { doc.Close(); } UI.MainMenuForm.MainMenuFrm.ShowForm(frm); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } // MainMenuForm.MainMenuFrm.ShowForm(frm); }
private void btnSendEmail_Click(object sender, EventArgs e) { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).OrderBy(c => c.PickupDate).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); frm.SendEmail(objMaster.Current.InvoiceNo, this.companyEmail); }
private void ExportReport(string exportTo) { if (objMaster.Current == null || objMaster.Current.Id == 0) { return; } long id = objMaster.Current.Id; frmInvoiceReport frm = new frmInvoiceReport(); var list = General.GetQueryable <vu_Invoice>(a => a.Id == id).OrderBy(c => c.PickupDate).ToList(); int count = list.Count; frm.DataSource = list; frm.GenerateReport(); frm.ExportReport(objMaster.Current.InvoiceNo, exportTo); }
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); } }