public HttpResponseMessage GetCourseByModuleId(int moduleId)
{
try {
Courses course = this._courseManagement.GetCourseByModuleId(moduleId);
if (course != null)
{
CoursesDTO dto = new CoursesDTO {
CourdeCode = course.CourdeCode,
CourseId = course.CourseId,
CourseName = course.CourseName,
NumberOfCredits = course.NumberOfCredits,
OwnerId = course.OwnerId,
SyllabusId = course.SyllabusId,
EnrollementKey = course.enrollementKey
};
return(Request.CreateResponse <CoursesDTO>(HttpStatusCode.OK, dto));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Resource Not Found"));
}
}
catch (Exception) {
// Log exception code goes here
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing method."));
}
}
public IActionResult UpdateCourse(int id, [FromBody] CourseUpdate coursedt)
{
CoursesDTO course = new CoursesDTO();
if (ModelState.IsValid)
{
try
{
course = _service.UpdateCourse(id, coursedt);
}
catch (AppObjectNotFoundException)
{
return(NotFound());
}
catch (FailedToSaveToDatabaseException)
{
return(StatusCode(500));
}
}
else
{
return(BadRequest());
}
return(NoContent());
}
public async Task <IActionResult> PutCoursesDTO(int id, CoursesDTO coursesDTO)
{
if (id != coursesDTO.ID)
{
return(BadRequest());
}
var course = new Courses
{
ID = coursesDTO.ID,
CourseName = coursesDTO.CourseName,
TrainingTypeID = coursesDTO.TrainingTypeID,
};
_context.Entry(course).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CoursesDTOExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <CoursesDTO> > PostCoursesDTO(CoursesDTO coursesDTO)
{
var course = new Courses
{
ID = coursesDTO.ID,
CourseName = coursesDTO.CourseName,
TrainingTypeID = coursesDTO.TrainingTypeID,
};
_context.courses.Add(course);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCoursesDTO", new { id = coursesDTO.ID }, coursesDTO));
}
public ActionResult SaveCourse()
{
UserDTO dto = (UserDTO)Session["User"];
int id = dto.UserID;
string course = Request["CourseName"];
int fee = 0;
if (course == "CCNA")
{
fee = 2000;
}
if (course == "DotNet")
{
fee = 1000;
}
if (course == "DBA")
{
fee = 2500;
}
if (course == "PHP")
{
fee = 1000;
}
if (course == "MSOffice")
{
fee = 2000;
}
if (course == "PhotoShop")
{
fee = 1500;
}
CoursesDTO c_dto = new CoursesDTO();
c_dto.UserID = id;
c_dto.isTaken = false;
c_dto.ObtainedMarks = 0;
c_dto.CourseFee = fee;
c_dto.CourseName = course;
c_dto.grade = "";
UserRepository repo = new UserRepository();
repo.SaveCourse(c_dto);
return(getAllCertificate());
}
public IActionResult DeleteCourse(int id)
{
CoursesDTO courseDeleted = new CoursesDTO();
try
{
courseDeleted = _service.DeleteCourse(id);
}
catch (AppObjectNotFoundException)
{
return(NotFound());
}
catch (FailedToSaveToDatabaseException)
{
return(StatusCode(500));
}
return(NoContent());
}
public HttpResponseMessage AddCourse(CoursesDTO dto)
{
try {
Courses course = new Courses();
course.CourdeCode = dto.CourdeCode;
course.CourseName = dto.CourseName;
course.NumberOfCredits = dto.NumberOfCredits;
course.OwnerId = dto.OwnerId;
course.SyllabusId = dto.SyllabusId;
course.enrollementKey = dto.EnrollementKey;
this._courseManagement.AddCourse(course);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception) {
// Log exception code goes here
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing method."));
}
}
public async Task <ActionResult <CoursesDTO> > GetCoursesDTO(int id)
{
var courses = await _context.courses.Include(c => c.TrainingType)
.FirstOrDefaultAsync(c => c.ID == id);
var coursesDTO = new CoursesDTO
{
ID = courses.ID,
CourseName = courses.CourseName,
TrainingTypeID = courses.TrainingTypeID,
TrainingTypeName = courses.TrainingType.TrainingTypeName
};
if (coursesDTO == null)
{
return(NotFound());
}
return(coursesDTO);
}
public HttpResponseMessage AddCourseToResources(CoursesDTO dto)
{
try {
//adding a course to drive
var result = this._resourcesManagement.CreateDirectory(dto.CourseName, "", ElUpToMe);
Resources resources = new Resources {
ResourceType = ResourceEnum.Directory.ToString(),
FileLocation = "",
FileId = result.Id,
FileName = result.Title,
CourseId = _courseManagement.GetCourseIdByCode(dto.CourdeCode),
ModuleID = -1
};
_resourcesManagement.SaveResourcesToDb(resources);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception) {
// Log exception code goes here
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Error occured while executing method."));
}
}
public ActionResult SubmitTest()
{
string cname = Request["cname"];
UserDTO usr = (UserDTO)Session["User"];
int id = usr.UserID;
UserRepository repo = new UserRepository();
var msoffice = new List <MsOfficeDTO>();
var ccna = new List <CCNAdto>();
var dba = new List <DBAdto>();
var dotnet = new List <DotNetDTO>();
var photoshop = new List <PhotoShopDTO>();
var php = new List <PHPdto>();
List <string> ans = new List <string>();
List <string> ques = new List <string>();
int correctAns = 0;
if (cname == "MSOffice")
{
var arr = repo.MSOfficeTest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count() && j < arr.Count())
{
if (ques[i] == arr[j].Statement && ans[i] == arr[j].CorrectOpt)
{
correctAns++;
i++;
j = 0;
}
j++;
}
}
if (cname == "CCNA")
{
var arr = repo.CCNATest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count())
{
if (ques[i] == arr[i].Statement && ans[i] == arr[i].CorrectOpt)
{
correctAns++;
i++;
}
j++;
}
}
if (cname == "DBA")
{
var arr = repo.DBATest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count())
{
if (ques[i] == arr[i].Statement && ans[i] == arr[i].CorrectOpt)
{
correctAns++;
i++;
}
j++;
}
}
if (cname == "DotNet")
{
var arr = repo.DotNetTest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count())
{
if (ques[i] == arr[i].Statement && ans[i] == arr[i].CorrectOpt)
{
correctAns++;
i++;
}
j++;
}
}
if (cname == "Photoshop")
{
var arr = repo.PhotoShopTest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count())
{
if (ques[i] == arr[i].Statement && ans[i] == arr[i].CorrectOpt)
{
correctAns++;
i++;
}
j++;
}
}
if (cname == "PHP")
{
var arr = repo.PhpTest();
foreach (var dto in arr)
{
ans.Add(Request[dto.Statement.ToString()]);
ques.Add(Request[dto.StID.ToString()]);
}
int i = 0;
int j = 0;
while (i < ques.Count())
{
if (ques[i] == arr[i].Statement && ans[i] == arr[i].CorrectOpt)
{
correctAns++;
i++;
}
j++;
}
}
CoursesDTO newdto = new CoursesDTO();
newdto.isTaken = true;
newdto.ObtainedMarks = correctAns * 1;
string grade = "";
if (correctAns > 25)
{
grade = "A";
}
else if (correctAns < 25 && correctAns > 20)
{
grade = "B";
}
else if (correctAns < 20 && correctAns > 15)
{
grade = "C";
}
else if (correctAns < 15 && correctAns > 10)
{
grade = "D";
}
else
{
grade = "F";
}
newdto.grade = grade;
newdto.CourseName = cname;
newdto.UserID = id;
repo.SaveResult(newdto);
return(View("Home"));
}
