/// <summary>
/// Adds a new Recycle Center to the database.
/// </summary>
/// <param name="center">Recycle Center to add to the database.</param>
/// <returns>Primary Key (ID) of the newly added Recycle Center.</returns>
public static int AddRecycleCenter(RecycleCenter center, out string errorMessage)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
errorMessage = String.Empty;
var data = new ActivEarthDataProvidersDataContext(connection);
var centerData = new RecyclingCenterDataProvider
{
location = center.Location,
comments = center.Comments,
automotive = center.Automotive,
electronics = center.Electronics,
construction = center.Construction,
batteries = center.Batteries,
garden = center.Garden,
glass = center.Glass,
hazardous = center.Hazardous,
household = center.Household,
metal = center.Metal,
paint = center.Paint,
paper = center.Paper,
plastic = center.Plastic,
user_id = center.UserId
};
data.RecyclingCenterDataProviders.InsertOnSubmit(centerData);
data.SubmitChanges();
return centerData.id;
}
}
catch (Exception e)
{
errorMessage = e.Message;
return 0;
}
}
partial void DeleteRecyclingCenterDataProvider(RecyclingCenterDataProvider instance);
partial void InsertRecyclingCenterDataProvider(RecyclingCenterDataProvider instance);
private void detach_RecyclingCenterDataProviders(RecyclingCenterDataProvider entity)
{
this.SendPropertyChanging();
entity.UserDataProvider = null;
}
