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);
}
