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