public static void SetIsDeletedToTrue(string routeId, bool isSubmitChanges = true)
{
TrainingRoute routeToDelete = TrainingRouteById(routeId);
routeToDelete.IsDeleted = true;
routeToDelete.DeleteDT = DateTime.Now;
if (isSubmitChanges)
{
database.SubmitChanges();
}
}
private void SaveRoute(object parameter = null)
{
string errMsg = ValidateRouteParams();
try
{
if (!string.IsNullOrEmpty(errMsg))
{
throw new Exception(errMsg);
}
switch (routeSetClimbMode)
{
case ClimbMode.Training:
errMsg = rocksOnRouteViewModel.ValidateRocksOnTrainingRoute();
if (!string.IsNullOrEmpty(errMsg))
{
throw new Exception(errMsg);
}
TrainingRoute newTrainingRoute = CreateTrainingRouteFromUi();
rocksOnRouteViewModel.SaveRocksOnTrainingRoute(newTrainingRoute);
break;
case ClimbMode.Boulder:
default:
errMsg = rocksOnRouteViewModel.ValidateRocksOnBoulderRoute();
if (!string.IsNullOrEmpty(errMsg))
{
throw new Exception(errMsg);
}
BoulderRoute newBoulderRoute = CreateBoulderRouteFromUi();
rocksOnRouteViewModel.SaveRocksOnBoulderRoute(newBoulderRoute);
break;
}
UiHelper.NotifyUser(routeSetClimbMode.ToString() + " Route is Saved.");
// Switch to Routes page
Routes routesPage = new Routes(routeSetClimbMode);
this.NavigationService.Navigate(routesPage);
}
catch (Exception ex)
{
UiHelper.NotifyUser("Error when saving the route:" + Environment.NewLine +
ex.ToString());
}
}
public static string Insert(TrainingRoute proposedRoute, bool isSubmitChanges = true)
{
DateTime createDT = DateTime.Now;
proposedRoute.IsDeleted = false;
proposedRoute.CreateDT = createDT;
Tuple <string, string> routeIdAndNo = KeyGenerator.GenerateNewKeyAndNo(myEntityType, createDT);
proposedRoute.RouteID = routeIdAndNo.Item1;
proposedRoute.RouteNo = routeIdAndNo.Item2;
database.TrainingRoutes.InsertOnSubmit(proposedRoute);
if (isSubmitChanges)
{
database.SubmitChanges();
}
return(proposedRoute.RouteID);
}
public static string InsertRouteAndRocksOnRoute(
TrainingRoute aRoute,
ICollection <RockOnRouteViewModel> someRocksOnRoute,
bool isSubmitChanges = true)
{
string newRouteKey = null;
if (someRocksOnRoute.Any())
{
RockOnTrainingRoute[] rocksOnTrainingRoute =
someRocksOnRoute.Select(x => new RockOnTrainingRoute
{
TrainingRouteSeq = x.TrainingSeq,
Rock = x.MyRockViewModel.MyRock.RockID
}).ToArray();
newRouteKey = InsertRouteAndRocksOnRoute(aRoute,
rocksOnTrainingRoute, isSubmitChanges);
}
return(newRouteKey);
}
public static string InsertRouteAndRocksOnRoute(
TrainingRoute aRoute,
ICollection <RockOnTrainingRoute> someRocksOnTrainingRoute,
bool isSubmitChanges = true)
{
string newRouteKey = null;
if (someRocksOnTrainingRoute.Any())
{
newRouteKey = TrainingRouteDataAccess.Insert(aRoute, false);
RockOnTrainingRouteDataAccess.InsertAll(someRocksOnTrainingRoute,
newRouteKey, false);
// submit changes altogether
if (isSubmitChanges)
{
database.SubmitChanges();
}
}
return(newRouteKey);
}
public string SaveRocksOnTrainingRoute(TrainingRoute trainingRoute)
{
return(TrainingRouteAndRocksDataAccess.InsertRouteAndRocksOnRoute(
trainingRoute, rocksOnRoute, true));
}
public static string TrainingRouteVideoRecordedFullPath(
TrainingRoute route, TrainingRouteVideo video)
{
return(TrainingRouteVideoRecordedFullPath(route.RouteNo, video.VideoNo));
}
