public string AddRecyclingCenter(XElement input)
{
try
{
RecycleCenter center = new RecycleCenter()
{
Location = input.Element("Location").Value,
Comments = input.Element("Comments").Value,
Automotive = bool.Parse(input.Element("Automotive").Value),
Electronics = bool.Parse(input.Element("Electronics").Value),
Construction = bool.Parse(input.Element("Construction").Value),
Batteries = bool.Parse(input.Element("Batteries").Value),
Garden = bool.Parse(input.Element("Garden").Value),
Glass = bool.Parse(input.Element("Glass").Value),
Hazardous = bool.Parse(input.Element("Hazardous").Value),
Household = bool.Parse(input.Element("Household").Value),
Metal = bool.Parse(input.Element("Metal").Value),
Paint = bool.Parse(input.Element("Paint").Value),
Paper = bool.Parse(input.Element("Paper").Value),
Plastic = bool.Parse(input.Element("Plastic").Value),
UserId = int.Parse(input.Element("UserId").Value)
};
string errorMessage;
int recycleId = RecyclingDAO.AddRecycleCenter(center, out errorMessage);
return "Recycling Center addition was " + (recycleId > 0 ? "successful." : ("unsuccessful. Reason: " + errorMessage));
}
catch (Exception e)
{
return String.Format("Recycling Center addition was unsuccessful. Reason: {0}", e.Message);
}
}
/// <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;
}
}
