public string SaveQCS(string heatseal, string type)
{
//The first condition is that the heatseal number has to be in the AutoSort.ArticleCode column and
//slot blank
AssemblyDB.AutoSort auto = dbassembly.AutoSorts.Where(au => au.ArticleCode == heatseal &&
au.Slot == " ").SingleOrDefault();
if (auto == null)
{
return(string.Empty);
}
QCSInfo qcs = dbBCS.QCSInfoes.Where(Q => Q.HeatSeal == heatseal).SingleOrDefault();
if (qcs != null) //if already there then update the type
{
qcs.Bin = type;
}
else
{
QCSInfo dbItem = new QCSInfo()
{
HeatSeal = heatseal, Bin = type, Time = auto.DueDate
};
dbBCS.QCSInfoes.Add(dbItem);
}
try
{
dbBCS.SaveChanges();
}
catch (Exception e)
{
return(e.InnerException.Message);
}
return(string.Empty);
}
public bool RemoveQCSInfoEntries(string heatseal)
{
QCSInfo qcs = dbBCS.QCSInfoes.Where(Q => Q.HeatSeal == heatseal).SingleOrDefault();
if (qcs == null)
{
return(false);
}
dbBCS.QCSInfoes.Remove(qcs);
dbBCS.SaveChanges();
return(true);
}
public string SaveQCS(string heatseal, string location)
{
QCSInfo dbItem = new QCSInfo()
{
HeatSeal = heatseal, Bin = location, Time = DateTime.Now
};
db.QCSInfoes.Add(dbItem);
try
{
db.SaveChanges();
}
catch (Exception e)
{
return(e.InnerException.Message);
}
return(string.Empty);
}
