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