/// <summary>
/// Create a new video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public async Task <VideoMaterialDb> AddAsync(VideoMaterialDb video)
{
_videoDbContext.VideoMaterials.Add(video);
_videoDbContext.SaveChangesAsync().ConfigureAwait(false).GetAwaiter();
var result = await Task.FromResult(video);
return(result);
}
/// <summary>
/// Update video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public void Update(VideoMaterialDb video)
{
if (video == null)
{
throw new ArgumentNullException("video");
}
_videoDbContext.Entry(video).State = EntityState.Modified;
_videoDbContext.SaveChanges();
}
/// <summary>
/// Remove video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public async Task RemoveAsync(VideoMaterialDb video)
{
if (video == null)
{
throw new ArgumentNullException("video");
}
_videoDbContext.VideoMaterials.Remove(video);
await _videoDbContext.SaveChangesAsync().ConfigureAwait(false);
}
/// <summary>
/// Update video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public async Task <VideoMaterialDb> UpdateAsync(VideoMaterialDb video)
{
if (video == null)
{
throw new ArgumentNullException("video");
}
_videoDbContext.Entry(video).State = EntityState.Modified;
await _videoDbContext.SaveChangesAsync().ConfigureAwait(false);
return(await Task.FromResult(video));
}
/// <summary>
/// Remove video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public void Remove(VideoMaterialDb video)
{
_videoDbContext.VideoMaterials.Remove(video);
_videoDbContext.SaveChanges();
}
/// <summary>
/// Create a new video in repository.
/// </summary>
/// <param name="video"></param>
/// <returns></returns>
public void Add(VideoMaterialDb video)
{
_videoDbContext.VideoMaterials.Add(video);
_videoDbContext.SaveChanges();
}
protected override void Seed(BulbaCourses.Video.Data.DatabaseContext.VideoDbContext context)
{
// This method will be called after migrating to the latest version.
#region Users
var user1 = new UserDb()
{
UserId = Guid.NewGuid().ToString(),
Login = "******",
SubscriptionType = 1
};
var user2 = new UserDb()
{
UserId = Guid.NewGuid().ToString(),
Login = "******",
SubscriptionType = 1
};
context.Users.Add(user1);
context.Users.Add(user2);
#endregion
#region Tags
var tag1 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "C#"
};
List <TagDb> tagDbC = new List <TagDb>()
{
tag1
};
var tag2 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "ASP.Net"
};
List <TagDb> tagDbCSharp = new List <TagDb>()
{
tag1, tag2
};
var tag3 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "Java"
};
var tag4 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "Automated"
};
var tag5 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "Testing"
};
List <TagDb> tagDbJava = new List <TagDb>()
{
tag3, tag4, tag5
};
var tag6 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "Network"
};
var tag7 = new TagDb()
{
TagId = Guid.NewGuid().ToString(),
Content = "DHCP"
};
List <TagDb> tagDbNet = new List <TagDb>()
{
tag6, tag7
};
context.Tags.Add(tag1);
context.Tags.Add(tag2);
context.Tags.Add(tag3);
context.Tags.Add(tag4);
context.Tags.Add(tag5);
context.Tags.Add(tag6);
context.Tags.Add(tag7);
#endregion
#region Authors
var author1 = new AuthorDb()
{
AuthorId = Guid.NewGuid().ToString(),
Name = "Aleksandr",
Lastname = "Shaduro",
Annotation = "Experienced Instructor with a demonstrated history of working in the higher education industry. " +
"Skilled in WEB Development, Agile Methodologies. Strong education professional graduated from Belarusian State University",
Professions = "Chief Technical Officer at Artooba"
};
var author2 = new AuthorDb()
{
AuthorId = Guid.NewGuid().ToString(),
Name = "Aleksandr",
Lastname = "Korablin",
Annotation = "MCSD: MICROSOFT CERTIFIED SOLUTION DEVELOPER, ORACLE CERTIFIED ASSOCIATE, " +
"JAVA SE 7 PROGRAMMER, WINDOWS AZURE DEVELOPER, MICROSOFT CERTIFIED TRAINER",
Professions = "MICROSOFT CERTIFIED SOLUTION DEVELOPER"
};
var author3 = new AuthorDb()
{
AuthorId = Guid.NewGuid().ToString(),
Name = "Aleksandr",
Lastname = "Borovoy",
Annotation = "Local network, DHCP, DNS, NOD-32",
Professions = "Local network"
};
context.Authors.Add(author1);
context.Authors.Add(author2);
context.Authors.Add(author3);
#endregion
#region Courses
var course1 = new CourseDb()
{
CourseId = Guid.NewGuid().ToString(),
Name = "ASP by Shaduro",
Author = author1,
Level = 1,
Raiting = 5,
RateCount = 20,
Description = ".NET is a developer platform made up of tools, programming languages, and libraries for building many different types of applications." +
"ASP.NET extends the.NET developer platform with tools and libraries specifically for building web apps.",
Date = DateTime.Now,
Price = 850,
Tags = tagDbCSharp
};
var course2 = new CourseDb()
{
CourseId = Guid.NewGuid().ToString(),
Name = "Programming in C#",
Author = author1,
Level = 1,
Raiting = 4,
RateCount = 12,
Description = "C#(Sharp) is an object-oriented programming language developed by Microsoft.",
Date = DateTime.Now,
Price = 50,
Tags = tagDbC
};
var course3 = new CourseDb()
{
CourseId = Guid.NewGuid().ToString(),
Name = "Java for Automated Testing",
Author = author2,
Level = 1,
Raiting = 4,
RateCount = 10,
Description = "Test automation, a formalized testing process, can automate repetitive but necessary tasks that would be difficult to do manually.",
Date = DateTime.Now,
Price = 70,
Tags = tagDbJava
};
var course4 = new CourseDb()
{
CourseId = Guid.NewGuid().ToString(),
Name = "Local Network",
Author = author3,
Level = 1,
Raiting = 3,
RateCount = 6,
Description = "A local area network (LAN) is a computer network that interconnects computers within a limited area.",
Date = DateTime.Now,
Price = 10,
Tags = tagDbNet
};
context.Courses.Add(course1);
context.Courses.Add(course2);
context.Courses.Add(course3);
context.Courses.Add(course4);
#endregion
#region Videos
var video1 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "validation",
Url = @"D:\TestCourses\ASP by Shaduro\1_video_validation.mp4",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 1,
CourseId = course1.CourseId
};
var video2 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "Refactiring & Security",
Url = @"D:\TestCourses\ASP by Shaduro\2_video_refactiring_&_security.mp4",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 2,
CourseId = course1.CourseId
};
var video3 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "Angular_Basic",
Url = @"D:\TestCourses\ASP by Shaduro\3_video_angular_basic.mp4",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 3,
CourseId = course1.CourseId
};
var video4 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "C# start part.1",
Url = @"D:\TestCourses\Programming in C#\1_1_x264.mp4",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 1,
CourseId = course2.CourseId
};
var video5 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "C# start part.1",
Url = @"D:\TestCourses\Programming in C#\1_2_x264.mp4",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 2,
CourseId = course2.CourseId
};
var video6 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "Java Fundamentals",
Url = @"D:\TestCourses\Java for Automated Testing\01_Java Fundamentals.wmv",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 1,
CourseId = course3.CourseId
};
var video7 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "Object Oriented Programming",
Url = @"D:\TestCourses\Java for Automated Testing\02_Object Oriented Programming.wmv",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 2,
CourseId = course3.CourseId
};
var video8 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "Numbers, strings, dates",
Url = @"D:\TestCourses\Java for Automated Testing\03_Numbers, strings, dates.avi",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 3,
CourseId = course3.CourseId
};
var video9 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "¬водный урок",
Url = @"D:\TestCourses\Ћокальна¤ компьютерна¤ сеть\”рок 1 Ч ¬водный урок.avi",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 1,
CourseId = course4.CourseId
};
var video10 = new VideoMaterialDb()
{
VideoId = Guid.NewGuid().ToString(),
Name = "«акрыта¤ серверна¤ стойка",
Url = @"D:\TestCourses\Ћокальна¤ компьютерна¤ сеть\”рок 2 Ч ќбзор закрытой серверной стойки.avi",
Created = DateTime.Now,
NumberOfViews = 1,
Order = 2,
CourseId = course4.CourseId
};
context.VideoMaterials.Add(video1);
context.VideoMaterials.Add(video2);
context.VideoMaterials.Add(video3);
context.VideoMaterials.Add(video4);
context.VideoMaterials.Add(video5);
context.VideoMaterials.Add(video6);
context.VideoMaterials.Add(video7);
context.VideoMaterials.Add(video8);
context.VideoMaterials.Add(video9);
context.VideoMaterials.Add(video10);
#endregion
base.Seed(context);
}
