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