public List<StationDetail> GetAllStationDetails() { DataCenterDataContext dbContext = new DataCenterDataContext(); var getAllStations = from stations in dbContext.StationDetails select stations; return getAllStations.ToList(); }
public StationDetail findStationById(int StationID) { DataCenterDataContext db = new DataCenterDataContext(); StationDetail result = (from station in db.StationDetails where station.STATION_ID == StationID select station).Single(); return result; }
public bool CreateStation(string StationName, string StationCode, string StationDescription) { StationDetail sd = new StationDetail { STATION_TITLE = StationName, STATION_CODE = StationCode, STATION_DESCRIPTION = StationDescription }; DataCenterDataContext db = new DataCenterDataContext(); db.StationDetails.InsertOnSubmit(sd); try { db.SubmitChanges(); return true; } catch (Exception e) { return false; } }