public bool doCreatHIDZoneQueueByReqStatus(string vh_id, string entry_sec_id, bool canPass, DateTime req_time) { bool isSeccess = true; E_HIDQueueStatus hidQueueStatus = E_HIDQueueStatus.Request; Nullable <System.DateTime> block_time = null; if (canPass) { block_time = req_time; hidQueueStatus = E_HIDQueueStatus.Blocking; } else { hidQueueStatus = E_HIDQueueStatus.Request; } AHIDZONEQUEUE hidObj = new AHIDZONEQUEUE { VEHICLE_ID = vh_id, ENTRY_SEC_ID = entry_sec_id, REQ_TIME = req_time, BLOCK_TIME = block_time, STATUS = hidQueueStatus }; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { HIDQueueDao.add(con, hidObj); } return(isSeccess); }
public AHIDZONEQUEUE getUsingHIDZoneQueueByVhID(string vh) { AHIDZONEQUEUE zone_queue = null; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { zone_queue = HIDQueueDao.getUsingHIDZoneQueue(con, vh); } return(zone_queue); }
public AHIDZONEQUEUE getHIDZoneQueue_FirstReqInPasue(string entry_sec_id) { AHIDZONEQUEUE zone_queue = null; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { zone_queue = HIDQueueDao.getHIDZoneQueue_FirstReqInPasue(con, entry_sec_id); } return(zone_queue); }
public void updateHIDZoneQueue_Pasue(string car_id, string entry_sec_id, bool isPasue) { using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, car_id, entry_sec_id); if (hidObj != null) { hidObj.IS_PASUE = isPasue; con.Entry(hidObj).Property(p => p.IS_PASUE).IsModified = true; HIDQueueDao.Update(con, hidObj); } } }
public AHIDZONEQUEUE getHIDZoneQueue(DBConnection_EF conn, string vh_id, string entry_sec_id) { AHIDZONEQUEUE queue = null; try { var query = from zone in conn.AHIDZONEQUEUE where zone.VEHICLE_ID.Trim() == vh_id && zone.ENTRY_SEC_ID.Trim() == entry_sec_id.Trim() select zone; queue = query.FirstOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(queue); }
public AHIDZONEQUEUE getUsingHIDZoneQueue(DBConnection_EF conn, string vh_id) { AHIDZONEQUEUE queue = null; try { var query = from zone in conn.AHIDZONEQUEUE where zone.VEHICLE_ID.Trim() == vh_id && zone.STATUS < E_HIDQueueStatus.Release select zone; queue = query.FirstOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(queue); }
public bool updateHIDZoneQueue_ReleasTime(string car_id, string entry_sec_id) { bool isSeccess = true; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, car_id, entry_sec_id); if (hidObj != null) { hidObj.RELEASE_TIME = DateTime.Now; hidObj.STATUS = E_HIDQueueStatus.Release; con.Entry(hidObj).Property(p => p.RELEASE_TIME).IsModified = true; con.Entry(hidObj).Property(p => p.STATUS).IsModified = true; HIDQueueDao.Update(con, hidObj); } } return(isSeccess); }
public bool updateHIDZoneQueue_BlockingTime(string vh_id, string current_sec_id) { bool isSeccess = true; using (DBConnection_EF con = DBConnection_EF.GetUContext()) { AHIDZONEQUEUE hidObj = HIDQueueDao.getHIDZoneQueue(con, vh_id, current_sec_id); if (hidObj != null) { hidObj.BLOCK_TIME = DateTime.Now; hidObj.STATUS = E_HIDQueueStatus.Blocking; con.Entry(hidObj).Property(p => p.BLOCK_TIME).IsModified = true; con.Entry(hidObj).Property(p => p.STATUS).IsModified = true; HIDQueueDao.Update(con, hidObj); } } return(isSeccess); }
public AHIDZONEQUEUE getHIDZoneQueue_FirstReqInPasue(DBConnection_EF conn, string entry_sec_id) { AHIDZONEQUEUE queue = null; try { var query = from zone in conn.AHIDZONEQUEUE where zone.ENTRY_SEC_ID.Trim() == entry_sec_id.Trim() && zone.IS_PASUE orderby zone.REQ_TIME select zone; queue = query.FirstOrDefault(); } catch (Exception ex) { logger.Warn(ex); throw; } return(queue); }
public void Update(DBConnection_EF con, AHIDZONEQUEUE hid) { con.SaveChanges(); }
public void add(DBConnection_EF con, AHIDZONEQUEUE hid) { con.AHIDZONEQUEUE.Add(hid); con.SaveChanges(); }