public List <ShirtInfo> getUndoneItemsByType() { DashQueries db = new DashQueries(); int addDays = 0; List <ShirtInfo> allNotDone = new List <ShirtInfo>(); allNotDone.AddRange(db.getItemCount("Shirts", addDays)); allNotDone.AddRange(db.getItemCount("tops", addDays)); allNotDone.AddRange(db.getItemCount("bottoms", addDays)); allNotDone.AddRange(db.getItemCount("Household", addDays)); return(allNotDone); }
public List <MissingItems> getMissingItems() { DBAccess db1; List <string> storeNames = new List <string>() { "HP", "MH", "WG", "HC" }; //get all the autosort info associated with the qcs items for the day DashQueries db = new DashQueries(); List <qcsReportInfo> AutoSortInfo = db.getAutoInfo(); List <MissingItems> items = new List <MissingItems>(); foreach (qcsReportInfo info in AutoSortInfo) { db1 = new DBAccess(info.storeid); Customer c = db1.GetCustomer(info.CustomerID); MissingItems m = new MissingItems() { CustomerName = c.FirstName + " " + c.LastName, description = info.Description, store = storeNames[info.storeid - 1], qcsType = info.qcsType, TimeStampIn = info.TimeStampIn, rfid = info.rfid, HeatSeal = info.HeatSeal }; if (m.store == "MH" && !m.rfid.StartsWith(" ")) { m.store = "R"; } items.Add(m); } items = items.OrderBy(i => i.store).ThenBy(i => i.qcsType).ThenBy(i => i.CustomerName).ToList(); return(items); }
public string saveQCS(string heatseal, string location) { DashQueries db = new DashQueries(); return(db.SaveQCS(heatseal, location)); }
public bool RemoveQCSInfoEntries(string heatseal) { DashQueries db = new DashQueries(); return(db.RemoveQCSInfoEntries(heatseal)); }
public int getUncatCount() { DashQueries db = new DashQueries(); return(db.GetCountUnCatQCS()); }
public List <QCSInfo> GetQCSTotal(string type) { DashQueries db = new DashQueries(); return(db.getQCSInfo(type)); }