public async Task <IActionResult> Update([FromBody] EnrollmentVm request) { if (await _enrollmentService.Update(request)) { return(Ok("Successfull")); } return(BadRequest("Trainee is in class")); }
public async Task <EnrollmentVm> GetById(int classId, string traineeId) { var data = await _context.Enrollments.Where(x => x.ClassId == classId && x.TraineeId == traineeId) .Include(x => x.Class).Include(x => x.Trainee).FirstOrDefaultAsync(); EnrollmentVm vm = _mapper.Map <EnrollmentVm>(data); return(vm); }
//RDLC Report for enrollment public ActionResult EnrollmentReport() { LocalReport localReport = new LocalReport(); string path = Path.Combine(Server.MapPath("~/Reports"), "EnrollmentReport.rdlc"); localReport.ReportPath = path; //list of data List <Enrollment> enrollments = new List <Enrollment>(); enrollments = db.Enrollments.ToList(); List <EnrollmentVm> enrollmentVm = new List <EnrollmentVm>(); EnrollmentVm enrollment; foreach (var item in enrollments) { enrollment = new EnrollmentVm { CourseID = item.Course.Title, StudentID = item.Student.FirstMidName + " " + item.Student.LastName, EnrollmentID = item.EnrollmentID, Grade = item.Grade.ToString() }; enrollmentVm.Add(enrollment); } //Dataset name. (rdlc dataset) ReportDataSource reportDataSource = new ReportDataSource("EnrollmentDataSet", enrollmentVm); string a = "Done"; localReport.DataSources.Add(reportDataSource); List <Student> aStudents = db.Students.ToList(); reportDataSource = new ReportDataSource("StdDataset", aStudents); localReport.DataSources.Add(reportDataSource); ReportParameter[] parameters = new ReportParameter[2]; parameters[0] = new ReportParameter("SchoolName", a); parameters[1] = new ReportParameter("SectionName", "Section Name"); localReport.SetParameters(parameters); //render to web/ anything else //Render() takes 7 parameters string mediaType, encoding, fileName; string[] stringArray; Warning[] warnings; byte[] dataByte = localReport.Render("PDF", null, out mediaType, out encoding, out fileName, out stringArray, out warnings); return(File(dataByte, mediaType)); }
public async Task <bool> Update(EnrollmentVm request) { var data = await _context.Enrollments.Where(x => x.ClassId == request.ClassId && x.TraineeId == request.TraineeId).FirstOrDefaultAsync(); if (data == null) { return(false); } data.ClassId = request.ClassId; try { await _context.SaveChangesAsync(); return(true); } catch { return(false); } }