public ActionResult GetOrdervsGRVReport(DateTimeFromToQuery ins) { List <OrdervsGRVReport> report = reportrepo.GetOrdervsGRVReport(ins); StringWriter sw = new StringWriter(); sw.WriteLine("\"Day\",\"Date\",\"Order Total\",\"Friday Total\",\"GRV Total\",\"Friday Total\""); string name = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=OrdervsGRV_" + name + ".csv"); Response.ContentType = "text/csv"; foreach (OrdervsGRVReport ex in report) { sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\"", ex.Day , ex.Date , ex.OrderTotal , ex.FridayOrderTotal , ex.GRVTotal , ex.FridayGRVTotal)); } Response.Write(sw.ToString()); Response.End(); return(null); }
public ActionResult GetOrdersExpectedDateReport(DateTimeFromToQuery ins) { List <PinkslipOrderReport> report = reportrepo.GetOrdersPerExpectedDeliveryDate(ins); StringWriter sw = new StringWriter(); sw.WriteLine("\"Pink Slip Number\",\"Order Date\",\"Order Total\""); string name = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=Orders_for_" + ins.From.ToShortDateString() + "_" + name + ".csv"); Response.ContentType = "text/csv"; foreach (PinkslipOrderReport ex in report) { sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\"", ex.PinkslipNumber , ex.OrderDate , ex.OrderTotal )); } Response.Write(sw.ToString()); Response.End(); return(null); }
public ActionResult GetCashOfficeReport(DateTimeFromToQuery ins) { List <CashOfficeReport> report = reportrepo.GetCashOfficeReport(ins); StringWriter sw = new StringWriter(); sw.WriteLine("\"Money Unit\",\"Sealed\",\"Opened\",\"Notes\",\"Cashiers\",\"Total\",\"Drops\",\"Transits\"," + "\"Day End Balance\""); string name = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=Cashoffice" + "_" + name + ".csv"); Response.ContentType = "text/csv"; decimal notestotal = 0; decimal cashiertotal = 0; decimal droptotal = 0; decimal trasittotal = 0; foreach (CashOfficeReport ex in report) { notestotal += ex.Sealed + ex.Opened + ex.TotalInOffice; cashiertotal += ex.CashierTotal; droptotal += ex.Drop; trasittotal += 0; sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\"", ex.MoneyUnit , ex.Sealed , ex.Opened , (ex.Sealed + ex.Opened + ex.TotalInOffice) , ex.CashierTotal , (ex.Sealed + ex.Opened + ex.TotalInOffice + ex.CashierTotal) , ex.Drop , 0 , (ex.Sealed + ex.Opened + ex.TotalInOffice + ex.CashierTotal - ex.Drop - 0) )); } decimal pickuptotal = reportrepo.GetPickUpTotal(ins.From); sw.WriteLine(", , ,{0},{1},{2},{3},{4},{5}" , notestotal, cashiertotal, (notestotal + cashiertotal), droptotal, trasittotal, (notestotal + cashiertotal - droptotal - trasittotal)); sw.WriteLine("\" \""); sw.WriteLine(", , , , , , ,\"Total Pickups\",\"{0}\"", pickuptotal); sw.WriteLine(", , , , , , ,\"Day end Total\",\"{0}\"", (notestotal + cashiertotal - droptotal - trasittotal + pickuptotal)); Response.Write(sw.ToString()); Response.End(); return(null); }
public ActionResult GetSparReconReport(DateTimeFromToQuery ins) { List <SparReconReport> report = reportrepo.GetSparReconReport(ins); StringWriter sw = new StringWriter(); sw.WriteLine("\"Status\",\"GRV Invoice Number\",\"Sate Date\",\"GRV Pay Date\",\"Excluding VAT\",\"Including VAT\",\"Pink Slip Number\",\"GRV Type\" " + " ,\"Supplier\",\"Recon Invoice Number\",\"Recon GRV Date\", Recon Amount, Recon GRV Type"); string name = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=SparInvoiceRecon" + "_" + name + ".csv"); Response.ContentType = "text/csv"; sw.WriteLine("\"GRV's not on Spar Invoice\""); foreach (SparReconReport ex in report) { if (ex.ReconInvoiceNumber.Equals("No GRV")) { sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\",\"{12}\"", "No Recon" , ex.GRVInvoiceNumber , ex.StateDate , ex.GRVPayDate , ex.GRVExVAT , ex.GRVInVAT , ex.GRVPinkSlipNumber , (ex.GRVType.Equals("1")) ? "GRV" : "CLM" , ex.Supplier , "" , "" , "" , "" )); } } sw.WriteLine("\" \""); sw.WriteLine("\"Spar Invoices not in GRV List\""); foreach (SparReconReport ex in report) { if (ex.GRVInvoiceNumber.Equals("No Recon")) { sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\",\"{12}\"", ex.Status , "" , "" , "" , "" , "" , "" , "" , ex.Supplier , ex.ReconInvoiceNumber , ex.ReconDate , ex.ReconAmount , (ex.ReconType.Equals("1")) ? "GRV" : "CLM" )); } } sw.WriteLine("\" \""); sw.WriteLine("\"Matched on GRV List and Spar Invoice\""); foreach (SparReconReport ex in report) { if ((!ex.GRVInvoiceNumber.Equals("No Recon")) && (!ex.ReconInvoiceNumber.Equals("No GRV"))) { sw.WriteLine(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\",\"{9}\",\"{10}\",\"{11}\",\"{12}\"", ex.Status , ex.GRVInvoiceNumber , ex.StateDate , ex.GRVPayDate , ex.GRVExVAT , ex.GRVInVAT , ex.GRVPinkSlipNumber , (ex.GRVType.Equals("1")) ? "GRV" : "CLM" , ex.Supplier , ex.ReconInvoiceNumber , ex.ReconDate , ex.ReconAmount , (ex.ReconType.Equals("1")) ? "GRV" : "CLM" )); } } Response.Write(sw.ToString()); Response.End(); return(null); }