public City getCityById(int id)
{
CarpoolingDAL.City ci = new CarpoolingDAL.City();
try {
var query = db.Cities.Where(o => o.idCity == id).First();
ci = query as CarpoolingDAL.City;
} catch (Exception) {
ci = null;
}
return(RepositoryUtility.createCityFromDALCity(ci));
}
public City getCityById(int id)
{
CarpoolingDAL.City ci = new CarpoolingDAL.City();
try {
var query = db.Cities.Where(o => o.idCity == id).First();
ci = query as CarpoolingDAL.City;
} catch (Exception) {
ci = null;
}
return RepositoryUtility.createCityFromDALCity(ci);
}
public Country getCountryByCity(City city)
{
CarpoolingDAL.City ci = new CarpoolingDAL.City();
CarpoolingDAL.Coutry co = new CarpoolingDAL.Coutry();
try {
var query = db.Cities.Where(o => o.idCity == city.Id).First();
ci = query as CarpoolingDAL.City;
var query2 = db.Coutries.Where(o => o.idCoutry == ci.idCoutry).First();
co = query2 as CarpoolingDAL.Coutry;
} catch (Exception) {
co = null;
}
return(RepositoryUtility.createCoutryFromDALCoutry(co));
}
public Country getCountryByCity(City city)
{
CarpoolingDAL.City ci = new CarpoolingDAL.City();
CarpoolingDAL.Coutry co = new CarpoolingDAL.Coutry();
try {
var query = db.Cities.Where(o => o.idCity == city.Id).First();
ci = query as CarpoolingDAL.City;
var query2 = db.Coutries.Where(o => o.idCoutry == ci.idCoutry).First();
co = query2 as CarpoolingDAL.Coutry;
} catch (Exception) {
co = null;
}
return RepositoryUtility.createCoutryFromDALCoutry(co);
}
private void detach_Cities(City entity)
{
this.SendPropertyChanging();
entity.Coutry = null;
}
private void attach_Cities(City entity)
{
this.SendPropertyChanging();
entity.Coutry = this;
}
partial void DeleteCity(City instance);
partial void UpdateCity(City instance);
partial void InsertCity(City instance);