コード例 #1
0
        public bool deleteRace(int raceID)
        {
            bool isDeleted = false;
            var db = new MXEugeneDBContext();
            Race fRace = db.Races.Where(r => r.RaceID == raceID).FirstOrDefault<Race>();
            if (fRace != null)
            {
                foreach( Class c in fRace.Class)
                {
                    List<Rider> testlist = c.Rider;
                    if (c.Rider.Count != 0)
                    {
                        c.Rider.Clear();
                        /*foreach (Rider r in c.Rider)
                        {
                            c.Rider.Remove(r);
                        }*/
                    }

                }
                if(fRace.Class != null)
                {
                    fRace.Class.Clear();
                }

                db.Races.Remove(fRace);
                db.SaveChanges();
                isDeleted = true;
            }
            return isDeleted;
        }
コード例 #2
0
 public bool deleteBike(int bikeID)
 {
     bool isDeleted = false;
     var db = new MXEugeneDBContext();
     Bike fBike = db.Bikes.Where(b => b.BikeID == bikeID).FirstOrDefault<Bike>();
     if (fBike != null)
     {
         db.Bikes.Remove(fBike);
         db.SaveChanges();
         isDeleted = true;
     }
     return isDeleted;
 }
コード例 #3
0
 public bool addRiderToClass(int classID, int riderID)
 {
     bool isAdded = false;
     var db = new MXEugeneDBContext();
     Rider fRider = db.Riders.Where(r => r.RiderID == riderID).FirstOrDefault<Rider>();
     Class fClass = db.Classes.Where(c => c.ClassID == classID).FirstOrDefault<Class>();
     if(fClass != null)
     {
         fClass.Rider.Add(fRider);
         db.SaveChanges();
         isAdded = true;
     }
     return isAdded;
 }
コード例 #4
0
 public bool addLicense(License license)
 {
     bool isLicenseAdded = false;
     var db = new MXEugeneDBContext();
     Rider fRider = db.Riders.Where(r => r.RiderID == license.Rider.RiderID).FirstOrDefault<Rider>();
     if (Rider != null)
     {
         license.Rider = fRider;
         db.Licenses.Add(license);
         db.SaveChanges();
         isLicenseAdded = true;
     }
     return isLicenseAdded;
 }
コード例 #5
0
 public bool addBike(Bike bike)
 {
     bool isBikeAdded = false;
     var db = new MXEugeneDBContext();
     Rider fRider = db.Riders.Where(r => r.RiderID == bike.Rider.RiderID).FirstOrDefault<Rider>();
     if (Rider != null)
     {
         bike.Rider = fRider;
         db.Bikes.Add(bike);
         db.SaveChanges();
         isBikeAdded = true;
     }
     return isBikeAdded;
 }
コード例 #6
0
 public bool addRider(Rider rider)
 {
     bool isAdded = false;
     var db = new MXEugeneDBContext();
     Rider fRider = (from r in db.Riders
                     where r.FName == rider.FName &&
                     r.LName == rider.LName
                     select r).FirstOrDefault<Rider>();
     if (fRider == null)
     {
         db.Riders.Add(rider);
         db.SaveChanges();
         isAdded = true;
     }
     return isAdded;
 }
コード例 #7
0
        public bool addRace(Race race)
        {
            bool isAdded = false;
            var db = new MXEugeneDBContext();
            Race fRace = (from r in db.Races
                          where r.Title == race.Title &&
                          r.Date == race.Date
                          select r).FirstOrDefault<Race>();
            if(fRace == null)
            {
                db.Races.Add(race);
                db.SaveChanges();
                isAdded = true;
            }

            return isAdded;
        }
コード例 #8
0
 public bool editRace(Race race)
 {
     bool isUpdated = false;
     var db = new MXEugeneDBContext();
     Race fRace = db.Races.Where(r => r.RaceID == race.RaceID).FirstOrDefault<Race>();
     if(fRace != null)
     {
         fRace.Title = race.Title;
         fRace.Descrtiption = race.Descrtiption;
         fRace.Date = race.Date;
         fRace.Class = race.Class;
         db.SaveChanges();
         isUpdated = true;
     }
     return isUpdated;
 }
コード例 #9
0
 public bool deleteLicense(int licenseID)
 {
     bool isDeleted = false;
     var db = new MXEugeneDBContext();
     License fLicenses = db.Licenses.Where(l => l.LicenseID == licenseID).FirstOrDefault<License>();
     if (fLicenses != null)
     {
         db.Licenses.Remove(fLicenses);
         db.SaveChanges();
         isDeleted = true;
     }
     return isDeleted;
 }
コード例 #10
0
        public bool editRider(Rider rider)
        {
            bool isUpdated = false;
            var db = new MXEugeneDBContext();
            Rider fRider = db.Riders.Where(r => r.RiderID == rider.RiderID).FirstOrDefault<Rider>();
            if (fRider != null)
            {
                fRider.FName = rider.FName;
                fRider.LName = rider.LName;
                fRider.EMail = rider.EMail;
                fRider.City = rider.City;
                fRider.State = rider.State;
                fRider.Zip = rider.Zip;
                fRider.Phone = rider.Phone;
                fRider.DOB = rider.DOB;
                fRider.Age = rider.Age;
                fRider.ReleaseSigned = rider.ReleaseSigned;
                fRider.ParentReleaseSigned = rider.ParentReleaseSigned;

                db.SaveChanges();
                isUpdated = true;
            }
            return isUpdated;
        }
コード例 #11
0
 public bool editLicense(License license)
 {
     bool isUpdated = false;
     var db = new MXEugeneDBContext();
     License fLicense = db.Licenses.Where(l => l.LicenseID == license.LicenseID).FirstOrDefault<License>();
     if (fLicense != null)
     {
         fLicense.LicenseType = license.LicenseType;
         fLicense.District = license.District;
         fLicense.Classification = license.Classification;
         fLicense.DateIssued = license.DateIssued;
         fLicense.DateExpires = license.DateExpires;
         fLicense.Rider = license.Rider;
         db.SaveChanges();
         isUpdated = true;
     }
     return isUpdated;
 }
コード例 #12
0
 public bool editBike(Bike bike)
 {
     bool isUpdated = false;
     var db = new MXEugeneDBContext();
     Bike fBike = db.Bikes.Where(b => b.BikeID == bike.BikeID).FirstOrDefault<Bike>();
     if (fBike != null)
     {
         fBike.BikeID = bike.BikeID;
         fBike.BikeNum = bike.BikeNum;
         fBike.Make = bike.Make;
         fBike.Model = bike.Model;
         db.SaveChanges();
         isUpdated = true;
     }
     return isUpdated;
 }
コード例 #13
0
        public bool deleteRider(int riderID)
        {
            bool isDeleted = false;
            var db = new MXEugeneDBContext();
            Rider fRider = db.Riders.Where(r => r.RiderID == riderID).FirstOrDefault<Rider>();
            if (fRider != null)
            {
                // need to remove bikes and linces from rider befor deleting the rider
                /*var Bikes = db.Bikes.Where(b => b.Rider.RiderID == fRider.RiderID).AsQueryable();
                List<License> Licenses = db.Licenses.Where(l => l.rider == fRider).ToList<License>();
                if(Bikes != null)
                {
                    foreach(Bike b in Bikes)
                    {
                        db.Bikes.Remove(b);
                    }
                }
               if (Licenses != null)
                {
                    foreach (License l in Licenses)
                    {
                        db.Licenses.Remove(l);
                    }
                }*/

                db.Riders.Remove(fRider);
                db.SaveChanges();
                isDeleted = true;
            }
            return isDeleted;
        }