public Nation getStateById(int id)
        {
            CarpoolingDAL.State st = new CarpoolingDAL.State();
            try {
                var query = db.States.Where(o => o.idState == id).First();
                st = query as CarpoolingDAL.State;
            } catch (Exception) {
                st = null;
            }

            return(RepositoryUtility.createNationFromDALState(st));
        }
        public Nation getStateByCountry(Country country)
        {
            CarpoolingDAL.Coutry co = new CarpoolingDAL.Coutry();
            CarpoolingDAL.State  st = new CarpoolingDAL.State();
            try {
                var query = db.Coutries.Where(o => o.idCoutry == country.Id).First();
                co = query as CarpoolingDAL.Coutry;
                var query2 = db.States.Where(o => o.idState == co.idCoutry).First();
                st = query2 as CarpoolingDAL.State;
            } catch (Exception) {
                st = null;
            }

            return(RepositoryUtility.createNationFromDALState(st));
        }
        public Nation getStateById(int id)
        {
            CarpoolingDAL.State st = new CarpoolingDAL.State();
            try {
                var query = db.States.Where(o => o.idState == id).First();
                st = query as CarpoolingDAL.State;
            } catch (Exception) {
                st = null;
            }

            return RepositoryUtility.createNationFromDALState(st);
        }
        public Nation getStateByCountry(Country country)
        {
            CarpoolingDAL.Coutry co = new CarpoolingDAL.Coutry();
            CarpoolingDAL.State st = new CarpoolingDAL.State();
            try {
                var query = db.Coutries.Where(o => o.idCoutry == country.Id).First();
                co = query as CarpoolingDAL.Coutry;
                var query2 = db.States.Where(o => o.idState == co.idCoutry).First();
                st = query2 as CarpoolingDAL.State;
            } catch (Exception) {
                st = null;
            }

            return RepositoryUtility.createNationFromDALState(st);
        }
 partial void DeleteState(State instance);
 partial void UpdateState(State instance);
 partial void InsertState(State instance);