//////////////////////may cause error
public IActionResult EditMaterialVedio(VideoMaterial k)
{
if (!ModelState.IsValid)
{
return(BadRequest("enter the whole data please"));
}
return(Ok(k));
}
public IEnumerable <VideoMaterial> AddMaterial(VideoMaterial NewMaterial)
{
var material = DB.VideoMaterials.FromSqlRaw("EXEC dbo.usp_VidoeMaterials_Insert {0},{1}"
, NewMaterial.VideoMaterialName
, NewMaterial.URL
)
.ToList <VideoMaterial>();
return(material);
}
public int CreateVideoMaterial(VideoMaterial videoMaterial)
{
int id = this.repository.Create <BaseMaterial>(new VideoMaterial
{
Name = videoMaterial.Name,
Duration = videoMaterial.Duration,
Quality = videoMaterial.Quality
});
return(id);
}
public async Task AddVideoMaterial(VideoMaterial videoMaterial)
{
await videoMaterialRepository.AddAsync(videoMaterial);
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity <ArticleMaterial>().ToTable("ArticleMaterial");
modelBuilder.Entity <VideoMaterial>().ToTable("VideoMaterial");
modelBuilder.Entity <BookMaterial>().ToTable("BookMaterial");
modelBuilder.Entity <User>().Property(u => u.Name).HasMaxLength(50);
modelBuilder.Entity <User>().Property(a => a.Email).HasMaxLength(50);
modelBuilder.Entity <User>().Property(a => a.Password).HasMaxLength(128);
modelBuilder.Entity <Skill>().Property(s => s.Name).HasMaxLength(30);
modelBuilder.Entity <Material>().Property(m => m.Name).HasMaxLength(50);
modelBuilder.Entity <ArticleMaterial>().Property(b => b.Name).HasMaxLength(128);
modelBuilder.Entity <ArticleMaterial>().Property(b => b.Resource).HasMaxLength(500);
modelBuilder.Entity <VideoMaterial>().Property(v => v.Name).HasMaxLength(128);
modelBuilder.Entity <VideoMaterial>().Property(v => v.Link).HasMaxLength(500);
modelBuilder.Entity <BookMaterial>().Property(v => v.Name).HasMaxLength(128);
modelBuilder.Entity <BookMaterial>().Property(v => v.Author).HasMaxLength(128);
modelBuilder.Entity <Test>().Property(c => c.Name).HasMaxLength(30);
modelBuilder.Entity <Question>().Property(c => c.Name).HasMaxLength(128);
modelBuilder.Entity <Answer>().Property(c => c.Name).HasMaxLength(60);
modelBuilder.Entity <Course>().Property(c => c.Name).HasMaxLength(128);
modelBuilder.Entity <Course>().Property(c => c.Description).HasMaxLength(250);
modelBuilder.Entity <UserSkills>().HasKey(x => new { x.UserId, x.SkillId });
modelBuilder.Entity <UserSkills>()
.HasOne(x => x.User)
.WithMany(x => x.UserSkills)
.HasForeignKey(x => x.UserId);
modelBuilder.Entity <UserSkills>()
.HasOne(x => x.Skill)
.WithMany(x => x.UserSkills)
.HasForeignKey(x => x.SkillId);
modelBuilder.Entity <UserCoursesInProgress>().HasKey(x => new { x.UserId, x.CourseId });
modelBuilder.Entity <UserCoursesInProgress>()
.HasOne(x => x.User)
.WithMany(x => x.CoursesInProgress)
.HasForeignKey(x => x.UserId)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity <UserCoursesInProgress>()
.HasOne(x => x.Course)
.WithMany(x => x.UsersInProgress)
.HasForeignKey(x => x.CourseId)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity <UserPassedCourses>().HasKey(x => new { x.UserId, x.CourseId });
modelBuilder.Entity <UserPassedCourses>()
.HasOne(x => x.User)
.WithMany(x => x.PassedCourses)
.HasForeignKey(x => x.UserId)
.OnDelete(DeleteBehavior.Restrict);
modelBuilder.Entity <UserPassedCourses>()
.HasOne(x => x.Course)
.WithMany(x => x.UsersPassed)
.HasForeignKey(x => x.CourseId)
.OnDelete(DeleteBehavior.Restrict);
var skill = new Skill {
Id = 1, Name = "C#"
};
var skill2 = new Skill {
Id = 2, Name = ".Net"
};
var skills = new List <Skill>()
{
skill, skill2
};
var article = new ArticleMaterial {
Id = 1, Name = "C# Metanit", PublishDate = DateTime.Now, Resource = "https://metanit.com/"
};
var video = new VideoMaterial {
Id = 2, Name = "Extreme Code - CLR", Quality = VideoQuality.High, Duration = "19,27", Link = "https://www.youtube.com/watch?v=neu6M576RWo"
};
var book = new BookMaterial {
Id = 3, Name = "CLR via C#", Author = "Richter", Format = BookFormat.Large, Pages = 236, YearOfPublish = 2006
};
modelBuilder.Entity <Skill>().HasData(skills);
modelBuilder.Entity <ArticleMaterial>().HasData(article);
modelBuilder.Entity <VideoMaterial>().HasData(video);
modelBuilder.Entity <BookMaterial>().HasData(book);
}
