public void Post([FromBody] ApiCourse c)
{
var tbCourse = new TbCourses()
{
CourseName = c.CourseName,
SubTitle = c.SubTitle,
CourseCode = c.CourseCode,
CourseBrief = c.CourseBrief,
CoverImage = c.CoverImage,
CourseDuration = c.CourseDuration,
CourseTags = c.CourseTags,
TargetAudiences = c.TargetAudiences,
CourseDetails = c.CourseDetails,
KnowledgePoints = c.KnowledgePoints,
Scores = c.Scores,
IsRecommended = c.IsRecommended,
JoinDate = c.JoinDate == null ? DateTime.Now : (DateTime)c.JoinDate,
IsActive = c.IsActive
};
_db.TbCourses.Add(tbCourse);
_db.SaveChanges();
var tbCourseAssignment = new TbCourseAssignments
{
InstructorId = Guid.Parse("C0A46162 - C5E2 - 43CC - AB29 - B24E650BA7C1"),
CourseId = tbCourse.CourseId
};
_db.TbCourseAssignments.Add(tbCourseAssignment);
_db.SaveChanges();
}
public ApiCourse Get(int id)
{
var tbCourse = (from i in _db.TbCourses where i.CourseId == id select i).FirstOrDefault();
var apiCourse = new ApiCourse();
if (tbCourse != null)
{
apiCourse.CourseId = tbCourse.CourseId;
apiCourse.CourseName = tbCourse.CourseName;
apiCourse.SubTitle = tbCourse.SubTitle;
apiCourse.CourseCode = tbCourse.CourseCode;
apiCourse.CourseBrief = tbCourse.CourseBrief;
apiCourse.CoverImage = tbCourse.CoverImage;
apiCourse.CourseDuration = tbCourse.CourseDuration;
apiCourse.CourseTags = tbCourse.CourseTags;
apiCourse.TargetAudiences = tbCourse.TargetAudiences;
apiCourse.CourseDetails = tbCourse.CourseDetails;
apiCourse.KnowledgePoints = tbCourse.KnowledgePoints;
apiCourse.Scores = tbCourse.Scores;
apiCourse.IsRecommended = tbCourse.IsRecommended;
apiCourse.JoinDate = tbCourse.JoinDate;
apiCourse.ModifiedDate = tbCourse.ModifiedDate;
apiCourse.Instructors = "/api/coursesinstructors/" + tbCourse.CourseId;
apiCourse.Students = "/api/coursesubscriptions/" + tbCourse.CourseId;
}
return(apiCourse);
}
//public void Delete(int id)
public ApiCourse Delete(int id)
{
var apicourse = new ApiCourse();
var tbCourse = (from i in _db.TbCourses
where i.CourseId == id
select i).FirstOrDefault();
if (tbCourse != null)
{
tbCourse.CourseId = id;
tbCourse.IsDeleted = true;
tbCourse.Modifier = Guid.Parse("C0A46162-C5E2-43CC-AB29-B24E650BA7C1");
tbCourse.ModifiedDate = DateTime.Now;
_db.TbCourses.Update(tbCourse);
_db.SaveChanges();
}
else
{
apicourse.Message = _localizer["CourseNotExists"];
}
return(apicourse);
}
public void Put(int id, [FromBody] ApiCourse course)
{
var tbCourse = (from i in _db.TbCourses
where i.CourseId == id
select i).FirstOrDefault();
Guid.TryParse(User.FindFirst(ClaimTypes.Name)?.Value, out var modifier);
if (tbCourse != null)
{
tbCourse.CourseId = id;
tbCourse.CourseName = course.CourseName;
tbCourse.SubTitle = course.SubTitle;
tbCourse.CourseCode = course.CourseCode;
tbCourse.CourseBrief = course.CourseBrief;
tbCourse.CoverImage = course.CoverImage;
tbCourse.CourseDuration = course.CourseDuration;
tbCourse.CourseTags = course.CourseTags;
tbCourse.TargetAudiences = course.TargetAudiences;
tbCourse.CourseDetails = course.CourseDetails;
tbCourse.KnowledgePoints = course.KnowledgePoints;
tbCourse.Scores = course.Scores;
tbCourse.IsRecommended = course.IsRecommended;
tbCourse.IsActive = course.IsActive;
tbCourse.Modifier = modifier;
tbCourse.ModifiedDate = DateTime.Now;
_db.TbCourses.Update(tbCourse);
_db.SaveChanges();
}
else
{
//TODO
}
}
public void Post([FromBody] ApiCourse course)
{
var tbCourse = new TbCourses()
{
CourseName = course.CourseName,
SubTitle = course.SubTitle,
CourseCode = course.CourseCode,
CourseBrief = course.CourseBrief,
CoverImage = course.CoverImage,
CourseDuration = course.CourseDuration,
CourseTags = course.CourseTags,
TargetAudiences = course.TargetAudiences,
CourseDetails = course.CourseDetails,
KnowledgePoints = course.KnowledgePoints,
Scores = course.Scores,
IsRecommended = course.IsRecommended,
JoinDate = course.JoinDate == null ? DateTime.Now : (DateTime)course.JoinDate,
IsActive = course.IsActive
};
_db.TbCourses.Add(tbCourse);
_db.SaveChanges();
Guid.TryParse(User.FindFirst(ClaimTypes.Name)?.Value, out var instructorId);
var tbCourseAssignments = new TbCourseAssignments
{
CourseId = tbCourse.CourseId,
InstructorId = instructorId
};
_db.TbCourseAssignments.Add(tbCourseAssignments);
_db.SaveChanges();
}
//public void Put(int id, [FromBody]ApiCourse course)
public ApiCourse Put(int id, [FromBody] ApiCourse course)
{
var apicourse = new ApiCourse();
var tbCourse = (from i in _db.TbCourses
where i.CourseId == id
select i).FirstOrDefault();
if (tbCourse != null)
{
tbCourse.CourseId = id;
tbCourse.CourseName = course.CourseName;
tbCourse.SubTitle = course.SubTitle;
tbCourse.CourseCode = course.CourseCode;
tbCourse.CourseBrief = course.CourseBrief;
tbCourse.CoverImage = course.CoverImage;
tbCourse.CourseDuration = course.CourseDuration;
tbCourse.CourseTags = course.CourseTags;
tbCourse.TargetAudiences = course.TargetAudiences;
tbCourse.CourseDetails = course.CourseDetails;
tbCourse.KnowledgePoints = course.KnowledgePoints;
tbCourse.Scores = course.Scores;
tbCourse.IsRecommended = course.IsRecommended;
tbCourse.IsActive = course.IsActive;
tbCourse.Modifier = Guid.Parse("C0A46162-C5E2-43CC-AB29-B24E650BA7C1");
tbCourse.ModifiedDate = DateTime.Now;
_db.TbCourses.Update(tbCourse);
_db.SaveChanges();
}
else
{
apicourse.Message = _localizer["CourseNotExists"];
}
return(apicourse);
}
