/// <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;
}
}
public string AddCarpool(XElement input)
{
try
{
Carpool carpool = new Carpool()
{
Start = input.Element("Start").Value,
Destination = input.Element("Destination").Value,
SeatsAvailable = byte.Parse(input.Element("SeatsAvailable").Value),
Time = input.Element("Time").Value,
Comments = input.Element("Comments").Value,
UserId = int.Parse(input.Element("UserId").Value)
};
string errorMessage;
int carpoolId = CarpoolDAO.AddCarpool(carpool, out errorMessage);
return "Carpool addition was " + (carpoolId > 0 ? "successful." : ("unsuccessful. Reason: " + errorMessage));
}
catch (Exception e)
{
return String.Format("Carpool addition was unsuccessful. Reason: {0}", e.Message);
}
}