public JsonResult LoadInventoryData(DateTime dateFrom, DateTime dateTo) { try { InventoryReportModel model = GetInventoryModel(dateFrom, dateTo); var jsonData = new { total = (Int32)Math.Ceiling((float)model.Records.Count), records = model.Records.Count, rows = model.Records.ToArray(), headers = model.Records.OrderBy(m => m.TotalTotal).Select(m => m.Item).Distinct().ToArray(), graph = model.Records.GroupBy(n => n.Date).Select(g => new { Date = g.Key, Sales = g.Select(p => p.TotalTotal).Take(3) } ).ToList() }; return new JsonResult() { Data = jsonData, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } catch (Exception ex) { base.Log(ex); } finally { } return new JsonResult() { Data = String.Empty, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public JsonResult GetStoreList() { InventoryReportModel inventoryReportModel = new InventoryReportModel(); inventoryReportModel.StoreList = _iDropDownService.GetStoreList().ToList(); return(Json(new { StoreList = inventoryReportModel.StoreList })); }
public IEnumerable <InventoryReportModel> GetUsedUnsold() { List <InventoryReportModel> _vehicles = new List <InventoryReportModel>(); using (var conn = new SqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString(); SqlCommand cmd = new SqlCommand("GetUsedUnsoldInventory", conn); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { InventoryReportModel row = new InventoryReportModel(); row.Year = (int)reader["Year"]; row.Make = reader["Make"].ToString(); row.Model = reader["Model"].ToString(); row.Count = (int)reader["Count"]; row.MSRPTotal = (decimal)reader["MSRPTotal"]; _vehicles.Add(row); } } } return(_vehicles); }
public ActionResult Inventory() { var repo = ReportsRepositoryFactory.GetRepository(); var model = new InventoryReportModel(); model.New = repo.GetNew(); model.Used = repo.GetUsed(); return(View(model)); }
void AddProductToGrid(Backend.Objects.Product product) { //Fill Grid [ InventoryGrid ] With Rows InventoryReportModel inventoryReportModel = new InventoryReportModel { Product = product, Currency = Store.CurrencySign, }; //Add To Grid InventoryGrid.Controls.Add(inventoryReportModel); }
public static MemoryStream CreateInventoryReport(InventoryReportModel model) { var _reportRepository = new ReportRepository(); DataTable inventoryPartsData = DataTableConverter.ToDataTable(model.InventoryParts); var dataSources = new List <ReportDataSource>(); ReportDataSource inventoryPartDataSource = new ReportDataSource("InventoryDS", inventoryPartsData); dataSources.Add(inventoryPartDataSource); byte[] reportData = ReportViewerManager.ShowPdfReport("InventoryReport", dataSources); var ms = new MemoryStream(reportData); return(ms); }
private InventoryReportModel GetInventoryModel(DateTime dateFrom, DateTime dateTo) { InventoryReportModel model = null; try { model = new InventoryReportModel(); model.From = dateFrom; model.To = dateTo; model.Records = _reportsService.InventoryDataSet(dateFrom, dateTo); return model; } catch (Exception ex) { base.Log(ex); } finally { } return null; }
public ActionResult InventoryReport(List <InventoryPartReportModel> parts) { var operationResult = new OperationResult(); MemoryStream ms = new MemoryStream(); try { var model = new InventoryReportModel(); model.InventoryParts = parts; ms = ReportingManager.CreateInventoryReport(model); } catch (Exception ex) { operationResult.Message = "Error occured printing Inventory Report"; logger.ErrorFormat("Error occured printing Inventory Report: {0} ", ex.ToString()); this.AddNotification(operationResult.Message, NotificationType.ERROR); } return(new FileStreamResult(ms, "application/pdf")); }
public static async Task <HttpResponseMessage> Run( [HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = null)] HttpRequest req, ILogger log, ExecutionContext context) { log.LogInformation("GetInventoryReportHtml Api Request initiated"); CloudData = new DataStore(log, context); var enumeratedCellars = await CloudData.GetCellarList(); if (enumeratedCellars.GetType() == typeof(StatusCodeResult)) { log.LogError($"Failed to get list of Cellars."); return(new HttpResponseMessage(HttpStatusCode.BadRequest) { Content = new StringContent("Failed to get list of Cellars") }); } var report = new InventoryReportModel(); report.DateOfReport = DateTime.Now; var inventoryCellars = new List <InventoryCellarModel>(); var cellarBottleCount = 0; foreach (var cellar in enumeratedCellars) { var inventoryCellar = await ProcessCellar(cellar); inventoryCellars.Add(inventoryCellar); cellarBottleCount += cellar.BottleCount; } report.TotalNumberOfBottles = cellarBottleCount; report.CellarsTotalValue = inventoryCellars.Sum(cv => cv.CellarTotalValue); report.AveBottleValue = cellarBottleCount > 0 ? report.CellarsTotalValue / cellarBottleCount : 0; report.Cellars = inventoryCellars.AsEnumerable(); // make Html var strB = new StringBuilder(); strB.Append(ReportPieces.Part1); strB.Append(ReportPieces.SummaryData( report.DateOfReport.ToString("d"), string.Format("{0:0,0.00}", report.CellarsTotalValue), report.TotalNumberOfBottles.ToString(), string.Format("{0:0,0.00}", report.AveBottleValue))); foreach (var c in report.Cellars) { strB.Append(ReportPieces.CellarHeader(c.CellarName, c.Capacity.ToString(), c.PctCapacity)); foreach (var v in c.Vintages) { strB.Append(ReportPieces.VintageHeader(v.VinetageYear.ToString())); strB.Append(ReportPieces.CellarLineHeader()); foreach (var i in v.WineItems) { strB.Append(ReportPieces.CellarLineItem(i.Quantity.ToString(), i.Size.ToString(), i.WineryName, i.Region, i.Country, i.WineName, i.Color, i.VarietalType, string.Format("{0:0,0.00}", i.UnitValue), string.Format("{0:0,0.00}", i.TotalValue))); } strB.Append("</div></div>"); //close TableBody for each vintage } strB.Append("</div>"); //close divTable blueTable strB.Append(ReportPieces.CellarFooter(string.Format("{0:0,0.00}", c.CellarTotalValue))); } strB.Append(ReportPieces.EndOfPage); log.LogInformation("GetInventoryReportData Api Request completed"); var response = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StringContent(strB.ToString()) }; response.Content.Headers.ContentType = new MediaTypeHeaderValue("text/html") { CharSet = "UTF-8" }; return(response); }