/// <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;
}
