//GET //Get Ride list /// <summary> /// Loads the rides from the database and then coverts it into a Ride list which it returns /// </summary> /// <returns>List<Ride></returns> public List <Ride> GetRideList() { RidesDataTable rideRows = new RidesDataTable(); AdapterManager.RidesTableAdapter.Fill(rideRows); List <Ride> list = new List <Ride>(); foreach (RidesRow row in rideRows) { Ride ride = new Ride(row.Id, row.Name, row.Catagory, row.Status); list.Add(ride); } return(list); }
//Edit Ride status in database /// <summary> /// Edits the Ride status inside the database /// </summary> /// <param name="ride"></param> /// <param name="status"></param> public void EditRideStatus(Ride ride, string status) { //Get database rows RidesDataTable rideRows = new RidesDataTable(); AdapterManager.RidesTableAdapter.Fill(rideRows); //Find the rows to edit RidesRow row = rideRows.FindById(ride.Id); //Update the row with edited data row.Status = status; //Save changes AdapterManager.RidesTableAdapter.Update(rideRows); }