// Add new place to trip public static int AddNewPlaceToTrip(PlaceModel place, int tripID) { int currrentPlaceNumber = 0; using (var cnn = new SQLiteConnection(LoadConnectionString())) { currrentPlaceNumber = cnn.QueryFirst <int>($"SELECT IFNULL(MAX(NUMBER),0) FROM PLACE WHERE TRIPID = {tripID}"); cnn.Execute($"INSERT INTO PLACE VALUES ({tripID},{currrentPlaceNumber + 1}, @Name, @Information,@DateStart,@DateFinish)", place); } return(currrentPlaceNumber + 1); }
public void AddPlace(PlaceModel place) // pass model with name,information,datestart,datefinish { int newNum = DatabaseAccess.AddNewPlaceToTrip(place, this.ID); PlaceModel toAddToTripModel = new PlaceModel { TripID = this.ID, Number = newNum, Name = place.Name, Information = place.Information, DateStart = place.DateStart, DateFinish = place.DateFinish }; this.placeList.Add(toAddToTripModel); Console.WriteLine($"Added place num: {newNum}"); }