public static TrainingRouteVideo Insert(Tuple <string, string> videoIdAndNo, string routeId, bool isDemo, bool isSubmitChanges = true)
{
TrainingRouteVideo routeVideo = new TrainingRouteVideo()
{
Route = routeId,
IsDemo = isDemo
};
Insert(videoIdAndNo, routeVideo, isSubmitChanges);
return(routeVideo);
}
public static void SetIsDeletedToTrue(string videoId, bool isSubmitChanges = true)
{
TrainingRouteVideo videoToDelete = TrainingRouteVideoById(videoId);
videoToDelete.IsDeleted = true;
videoToDelete.DeletedDT = DateTime.Now;
if (isSubmitChanges)
{
database.SubmitChanges();
}
}
private static void SetIsDemoOfExistingDemoRouteVideoToFalse(string routeId, bool isSubmitChanges = true)
{
TrainingRouteVideo existingDemoVideo = TryGetValidTrainingRouteDemoVideoByRouteId(routeId);
if (existingDemoVideo != null)
{
existingDemoVideo.IsDemo = false;
}
if (isSubmitChanges)
{
database.SubmitChanges();
}
}
public static string Insert(Tuple <string, string> videoIdAndNo, TrainingRouteVideo proposedVideo, bool isSubmitChanges = true)
{
proposedVideo.IsDeleted = false;
proposedVideo.CreateDT = DateTime.Now;
proposedVideo.VideoID = videoIdAndNo.Item1;
proposedVideo.VideoNo = videoIdAndNo.Item2;
database.TrainingRouteVideos.InsertOnSubmit(proposedVideo);
if (isSubmitChanges)
{
database.SubmitChanges();
}
return(proposedVideo.VideoID);
}
public static string Insert(TrainingRouteVideo proposedVideo, bool isSubmitChanges = true)
{
DateTime createDT = DateTime.Now;
proposedVideo.IsDeleted = false;
proposedVideo.CreateDT = createDT;
Tuple <string, string> videoIdAndNo = KeyGenerator.GenerateNewKeyAndNo(myEntityType, createDT);
proposedVideo.VideoID = videoIdAndNo.Item1;
proposedVideo.VideoNo = videoIdAndNo.Item2;
database.TrainingRouteVideos.InsertOnSubmit(proposedVideo);
if (isSubmitChanges)
{
database.SubmitChanges();
}
return(proposedVideo.VideoID);
}
public static string Insert(TrainingRouteVideo proposedVideo, bool isSubmitChanges = true)
{
return(Insert(GenerateIdAndNo(), proposedVideo, isSubmitChanges));
}
public static string InsertToReplacePreviousDemo(Tuple <string, string> videoIdAndNo, TrainingRouteVideo proposedVideo, bool isSubmitChanges = true)
{
SetIsDemoOfExistingDemoRouteVideoToFalse(proposedVideo.Route, isSubmitChanges);
proposedVideo.IsDemo = true; // TODO: should force set IsDemo here?
return(Insert(videoIdAndNo, proposedVideo, isSubmitChanges));
}
public static string TrainingRouteVideoRecordedFullPath(
TrainingRoute route, TrainingRouteVideo video)
{
return(TrainingRouteVideoRecordedFullPath(route.RouteNo, video.VideoNo));
}
