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)); }