public void UpdateAllSaleCounts()
{
char store = userStoreDic[Context.ConnectionId];
SqlStoredProcedures sqlSP = new SqlStoredProcedures();
List <Sale> sales = sqlSP.StoreSelectSales(store);
foreach (Sale sale in sales)
{
Clients.Client(Context.ConnectionId).UpdateSaleCount(sale.GetProductID(), sale.GetCount(), sale.GetEmployeeCount());
}
decimal total = sqlSP.StoreGetSaleTotal(store);
Clients.Client(Context.ConnectionId).UpdateTotal(Convert.ToDouble(total).ToString("N2"));
}
private ActionResult CPDownloadSales()
{
if (user.HasPolicy("Store.Sales.Download"))
{
SqlStoredProcedures sqlSP = new SqlStoredProcedures();
DateTime startDate = Convert.ToDateTime(postData["startDate"]);
DateTime endDate = Convert.ToDateTime(postData["endDate"]);
List <Sale> saleCounts = sqlSP.StoreSelectSales(startDate, endDate);
StringBuilder sb = new StringBuilder();
DateTime date = DateTime.Now;
sb.AppendLine("\"Date\",\"Store\",\"Product Name\",\"Count\",\"Employee Count\"");
foreach (Sale sale in saleCounts)
{
if (date != null && date != sale.GetDate())
{
sb.AppendLine();
}
date = sale.GetDate();
sb.Append("\"" + CSV.Escape(sale.GetDate().ToShortDateString()) + "\"" + ",");
sb.Append("\"" + CSV.Escape(Convert.ToString(sale.GetStore())) + "\"" + ",");
sb.Append("\"" + CSV.Escape(Convert.ToString(sale.GetProductName())) + "\"" + ",");
sb.Append("\"" + CSV.Escape(Convert.ToString(sale.GetCount())) + "\"" + ",");
sb.Append("\"" + CSV.Escape(Convert.ToString(sale.GetEmployeeCount())) + "\"");
sb.Append("\n");
}
byte[] fileBytes = System.Text.Encoding.UTF8.GetBytes(sb.ToString());
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, postData["startDate"] + "-" + postData["endDate"] + ".csv"));
}
else
{
throw new NoPermissionException();
}
}
