public async Task <object> GetSchoolDetails(string regNo, int branchId) { if (!string.IsNullOrEmpty(regNo)) { var schoolDetails = await(from school in _context.SchoolAcademy join branch in _context.SchoolBranch on school.Id equals branch.SchoolAcademyID where branch.RegistrationNumber == regNo select new { school, schoolExamType = branch.ExamType, logo = _fileRepo.AppendMultiDocPath(school.Logo), branch }).FirstOrDefaultAsync(); if (schoolDetails == null) { return(null); } return(schoolDetails); //regNo = _context.SchoolBranch.Where(m => m.BranchName == "ONLINE ACADEMY").FirstOrDefault().RegistrationNumber; } else { var schoolDetails = await(from school in _context.SchoolAcademy join branch in _context.SchoolBranch on school.Id equals branch.SchoolAcademyID where branch.Id == branchId select new { school, schoolExamType = branch.ExamType, logo = _fileRepo.AppendMultiDocPath(school.Logo), branch }).FirstOrDefaultAsync(); if (schoolDetails == null) { return(null); } return(schoolDetails); } }
public async Task <ServiceResponse <object> > GetAssignment(int id) { var ToReturn = await _context.ClassSectionAssignment.Select(o => new AssignmentDtoForDetail { Id = o.Id, AssignmentName = o.AssignmentName, ClassSectionId = o.ClassSectionId, ClassSection = (_context.Class.FirstOrDefault(m => m.Id == o.ClassSection.ClassId && m.Active == true) != null && _context.Sections.FirstOrDefault(m => m.Id == o.ClassSection.SectionId && m.Active == true) != null) ? _context.Class.FirstOrDefault(m => m.Id == o.ClassSection.ClassId && m.Active == true).Name + " " + _context.Sections.FirstOrDefault(m => m.Id == o.ClassSection.SectionId && m.Active == true).SectionName : "", RelatedMaterial = _filesRepository.AppendMultiDocPath(o.RelatedMaterial), FileName = SplitValues(o.FileName), Details = o.Details, ReferenceUrl = o.ReferenceUrl, SubjectId = o.SubjectId, DueDateTime = o.DueDateTime != null ? DateFormat.ToDate(o.DueDateTime.ToString()) : "", IsPosted = o.IsPosted, }).FirstOrDefaultAsync(u => u.Id == id); _serviceResponse.Data = ToReturn; _serviceResponse.Success = true; return(_serviceResponse); }