public List <CassetteData> loadCassetteData()
{
try
{
using (DBConnection_EF con = DBConnection_EF.GetUContext())
{
return(cassettedataDao.LoadCassetteData(con));
}
}
catch (Exception ex)
{
logger.Error(ex, "Exception");
return(null);
}
}
public UInt16 getCurrentShelfCapacity()
{
using (DBConnection_EF con = DBConnection_EF.GetUContext())
{
var enable = shelfdefDao.LoadShelfDef(con).Where(x => x.Enable == "Y").Count();
var cassette = cassetteDataDao.LoadCassetteData(con);
int i = 0;
cassette.ForEach(x =>
{
i = i + shelfdefDao.LoadShelfDef(con).Where(y => y.Enable == "Y" && y.ShelfID == x.Carrier_LOC).Count();
});
return((UInt16)(enable - i));
}
}
public int GetZoneCapacity(string zoneid)
{
try
{
using (DBConnection_EF con = DBConnection_EF.GetUContext())
{
var enable = shelfdefDao.LoadShelfDef(con).Where(x => x.ZoneID == zoneid && x.Enable == "Y").Count();
var cassette = cassetteDao.LoadCassetteData(con);
int i = 0;
cassette.ForEach(x =>
{
i = i + shelfdefDao.LoadShelfDef(con).Where(y => y.ZoneID == zoneid && y.Enable == "Y" && y.ShelfID == x.Carrier_LOC).Count();
});
return(enable - i);
}
}
catch (Exception ex)
{
logger.Error(ex, "Exception");
return(0);
}
}