/// <summary> /// Adds a new Carpool to the database. /// </summary> /// <param name="carpool">Carpool to add to the database.</param> /// <returns>Primary Key (ID) of the newly added Carpool.</returns> public static int AddCarpool(Carpool carpool, out string errorMessage) { try { using (SqlConnection connection = ConnectionManager.GetConnection()) { errorMessage = String.Empty; var data = new ActivEarthDataProvidersDataContext(connection); var carpoolData = new CarpoolDataProvider { start = carpool.Start, destination = carpool.Destination, time = carpool.Time, seats_available = carpool.SeatsAvailable, comments = carpool.Comments, user_id = carpool.UserId }; data.CarpoolDataProviders.InsertOnSubmit(carpoolData); data.SubmitChanges(); return carpoolData.id; } } catch (Exception e) { errorMessage = e.Message; return 0; } }
partial void DeleteCarpoolDataProvider(CarpoolDataProvider instance);
partial void UpdateCarpoolDataProvider(CarpoolDataProvider instance);
partial void InsertCarpoolDataProvider(CarpoolDataProvider instance);
private void detach_CarpoolDataProviders(CarpoolDataProvider entity) { this.SendPropertyChanging(); entity.UserDataProvider = null; }