public void Create(Location_SYD obj)
 {
     try
     {
         db.Location_SYD.Add(obj);
     }
     catch (Exception)
     {
         throw;
     }
 }
 public void Update(Location_SYD obj)
 {
     try
     {
         Location_SYD locObject = this.db.Location_SYD.FirstOrDefault(loc => loc.location_id == obj.location_id);
         locObject = obj;
     }
     catch (Exception)
     {
         throw;
     }
 }
        public Location_SYD SelectById(int Id)
        {
            Location_SYD retVal = null;

            try
            {
                retVal = this.db.Location_SYD.FirstOrDefault(al => al.location_id == Id);
            }
            catch (Exception)
            {
                throw;
            }

            return(retVal);
        }