Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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);
        }