public void UpdateSaleCount(int productID, int count, int employeeCount) { if (productID > 999 || count > 999 || employeeCount > 999) { return; } if (productID < 0 || count < 0 || employeeCount < 0) { return; } char store = userStoreDic[Context.ConnectionId]; SqlStoredProcedures sqlSP = new SqlStoredProcedures(); sqlSP.StoreUpdateSaleCount(Char.ToUpper(store), productID, count, employeeCount); decimal total = sqlSP.StoreGetSaleTotal(store); foreach (KeyValuePair <string, char> userStorePair in userStoreDic) { if (userStorePair.Value == store) { Clients.Client(userStorePair.Key).UpdateSaleCount(productID, count, employeeCount); Clients.Client(userStorePair.Key).UpdateTotal(Convert.ToDouble(total).ToString("N2")); } } }
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")); }
public void UpdateTotal() { char store = userStoreDic[Context.ConnectionId]; decimal total; SqlStoredProcedures sqlSP = new SqlStoredProcedures(); total = sqlSP.StoreGetSaleTotal(store); Convert.ToDouble(total).ToString("N2"); foreach (KeyValuePair <string, char> userStorePair in userStoreDic) { if (userStorePair.Value == userStoreDic[Context.ConnectionId]) { Clients.Client(userStorePair.Key).UpdateTotal(Convert.ToDouble(total).ToString("N2")); } } }