public static int AddNewRoute(Route route, out string errorMessage)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
errorMessage = String.Empty;
var data = new ActivEarthDataProvidersDataContext(connection);
var routeData = new ActiveRouteDataProvider
{
gmt_offset = route.GMTOffset,
distance = route.Distance,
end_latitude = route.EndLatitude,
end_longitude = route.EndLongitude,
end_time = route.EndTime,
mode = route.Mode,
points = route.Points,
start_latitude = route.StartLatitude,
start_longitude = route.StartLongitude,
start_time = route.StartTime,
steps = route.Steps,
type = route.Type,
user_id = route.UserId
};
data.ActiveRouteDataProviders.InsertOnSubmit(routeData);
data.SubmitChanges();
if (routeData.id > 0)
{
ActiveRouteDAO.ProcessRoute(route);
}
return routeData.id;
}
}
catch (Exception e)
{
errorMessage = e.Message;
return 0;
}
}