Click here to Skip to main content
15,891,976 members
Articles / Mobile Apps / Windows Phone 7

RegiRide, a complete Windows Phone application

Rate me:
Please Sign up or sign in to vote.
4.99/5 (51 votes)
24 Jun 2012CPOL17 min read 114.1K   2.5K   123  
A complete WP7 application with SQL compact database, LINQ to SQL, MVVM Light and Dropbox integration
namespace RegiRide.Repository
{
    using System;
    using System.Collections.Generic;
    using System.Linq;

    using RegiRide.Model;

    public class RideRepository : IRideRepository
    {
        private readonly RideDataContext rideDataContext;

        public RideRepository(RideDataContext rideDataContext)
        {
            this.rideDataContext = rideDataContext;
        }

        public List<Ride> GetAll()
        {
            return (from ride in rideDataContext.Rides select ride).ToList();
        }

        public Ride GetPreviousState(Ride ride)
        {
            return rideDataContext.Rides.GetOriginalEntityState(ride);    
        }

        public void Save(Ride ride)
        {
            if (rideDataContext.Rides.GetOriginalEntityState(ride) == null)
            {
                rideDataContext.Rides.InsertOnSubmit(ride);
            }

            rideDataContext.SubmitChanges();
        }

        public Ride CreateNewRide()
        {
            Ride latestRide = this.GetLatestRide();

            Ride ride;

            if (latestRide != null)
            {
                ride = new Ride
                    {
                        Date = DateTime.Now, 
                        StartMilage = latestRide.EndMilage,
                        EndMilage = latestRide.EndMilage + (latestRide.EndMilage - latestRide.StartMilage), 
                        StartAddress = latestRide.EndAddress,
                        EndAddress = latestRide.StartAddress,
                        RideType = (int)RideType.Business
                    };
            }
            else
            {
                ride = new Ride
                {
                    Date = DateTime.Now,
                    RideType = (int)RideType.Business
                };
            }

            return ride;
        }

        public void Delete(Ride model)
        {
            if (model != null)
            {
                if (model.Id != Guid.Empty)
                {
                    var rideToDelete = this.rideDataContext.Rides.SingleOrDefault(r => r.Id == model.Id);
                    if (rideToDelete != null)
                    {
                        rideDataContext.Rides.DeleteOnSubmit(rideToDelete);
                        rideDataContext.SubmitChanges();
                    }
                }
            }
        }

        public bool IsAddressUsed(Address model)
        {
            if (model != null)
            {
                if (model.Id != Guid.Empty)
                {
                    int numberOfRidesUsingAddress = this.rideDataContext.Rides.Count(r => r.AddressStartId == model.Id || r.AddressEndId == model.Id);
                    if (numberOfRidesUsingAddress > 0)
                    {
                        return true;
                    }
                }
            }

            return false;
        }

        public void DeleteAll()
        {
            rideDataContext.Rides.DeleteAllOnSubmit(rideDataContext.Rides);
            rideDataContext.SubmitChanges();
        }

        public Ride GetLatestRide()
        {
            return (from ride in rideDataContext.Rides orderby ride.Date descending select ride).Take(1).SingleOrDefault();
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect http://www.simpletechture.nl
Netherlands Netherlands
Patrick Kalkman is a senior Software Architect with more than 20 years professional development experience. He works for SimpleTechture where he helps teams develop state of the art web applications.

Patrick enjoys writing his blog. It discusses agile software development. Patrick can be reached at patrick@simpletechture.nl.

Published Windows 8 apps:


Published Windows Phone apps:


Awards:

Best Mobile article of March 2012
Best Mobile article of June 2012

Comments and Discussions