public bool saveAndUpdate(string vh_id, string adr_id, string sec_id, int acc_dist, long ping_time) { bool isSuccess = true; ANETWORKQUALITY network_quality = null; using (DBConnection_EF con = new DBConnection_EF()) { network_quality = networkQualityDAO.getByVhAdrAndSecID(con, vh_id, adr_id, sec_id); if (network_quality == null) { network_quality = new ANETWORKQUALITY() { VEICLE_ID = vh_id, ADR_ID = adr_id, SEC_ID = sec_id, ACC_SEC_DIST = acc_dist, PING_TIME = ping_time, UPD_TIME = DateTime.Now }; networkQualityDAO.add(con, network_quality); } else { network_quality.ACC_SEC_DIST = acc_dist; network_quality.PING_TIME = ping_time; network_quality.UPD_TIME = DateTime.Now; networkQualityDAO.update(con); } } return(isSuccess); }
public List <ANETWORKQUALITY> addNetworkQuality(string vh_id, string adr_id, string sec_id, int acc_dist, long ping_time) { List <ANETWORKQUALITY> lstNetwork = null; //DBConnection_EF con = DBConnection_EF.GetContext(); using (DBConnection_EF con = new DBConnection_EF()) { lstNetwork = networkQualityDAO.loadBySecIDAndVhID(con, sec_id, vh_id); int networkCount = lstNetwork.Count; if (lstNetwork.Count >= eachSectionOfPingTime_MaxKeepConut) { for (int i = eachSectionOfPingTime_MaxKeepConut - 1; i < networkCount; i++) { networkQualityDAO.remove(con, lstNetwork[i]); lstNetwork.Remove(lstNetwork[i]); } } ANETWORKQUALITY network_quality = new ANETWORKQUALITY() { VEICLE_ID = vh_id, ADR_ID = adr_id, SEC_ID = sec_id, ACC_SEC_DIST = acc_dist, PING_TIME = ping_time, UPD_TIME = DateTime.Now }; networkQualityDAO.add(con, network_quality); } return(lstNetwork); }
public void remove(DBConnection_EF con, ANETWORKQUALITY network_qualitys) { con.ANETWORKQUALITY.Remove(network_qualitys); con.SaveChanges(); }
public void add(DBConnection_EF con, ANETWORKQUALITY network_quality) { con.ANETWORKQUALITY.Add(network_quality); con.SaveChanges(); }