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