public IEnumerable<Journey> GetAll() { List<Journey> journeys = new List<Journey>(); string connectionString = "Data Source=isostore:/MileageTracker.sdf"; using (LinqDataContext dataContext = new LinqDataContext(connectionString)) { var dbJourneys = dataContext.Journeys; foreach (var dbJourney in dbJourneys) { Journey journey = new Journey() { Id = dbJourney.Id, Date = dbJourney.Date, StartMileage = dbJourney.StartMileage, EndMileage = dbJourney.EndMileage }; journeys.Add(journey); } } return journeys; }
public void Delete(Journey journey) { string connectionString = "Data Source=isostore:/MileageTracker.sdf"; using (LinqDataContext dataContext = new LinqDataContext(connectionString)) { JourneyLinqEntity dbJourney = dataContext.Journeys .Where(j => j.Id == journey.Id) .Single(); dataContext.Journeys.DeleteOnSubmit(dbJourney); dataContext.SubmitChanges(); } }
private void ApplicationBarIconButton_Save_Click(object sender, EventArgs e) { // TODO: Verify input, to ensure we have start mileage, end mileage and a date. Journey journey = new Journey() { Date = this.Date.Value.Value, StartMileage = int.Parse(this.StartMileage.Text), EndMileage = int.Parse(this.EndMileage.Text) }; JourneyRepository journeyRepository = new JourneyRepository(); journeyRepository.Insert(journey); App.ViewModel.LoadData(); NavigationService.GoBack(); }
public Journey GetById(int id) { Journey journey; string connectionString = "Data Source=isostore:/MileageTracker.sdf"; using (LinqDataContext dataContext = new LinqDataContext(connectionString)) { JourneyLinqEntity dbJourney = dataContext.Journeys .Where(j => j.Id == id) .Single(); // TODO: Make data adapter or use automapper? journey = new Journey() { Id = dbJourney.Id, Date = dbJourney.Date, StartMileage = dbJourney.StartMileage, EndMileage = dbJourney.EndMileage }; } return journey; }
public void Insert(Journey journey) { JourneyLinqEntity journeyLinq = new JourneyLinqEntity() { Date = journey.Date, StartMileage = journey.StartMileage, EndMileage = journey.EndMileage }; string connectionString = "Data Source=isostore:/MileageTracker.sdf"; using (LinqDataContext dataContext = new LinqDataContext(connectionString)) { dataContext.Journeys.InsertOnSubmit(journeyLinq); dataContext.SubmitChanges(); } }
public void LogJourney(Journey journey) { this.journeys.Add(journey); }