public SchoolListModel GetAllSchoolList(SchoolListModel school) { logger.Info("Method getAllSchools called."); SchoolListModel schoolList = new SchoolListModel(); try { if (TokenManager.CheckToken(school._tenantName, school._token)) { schoolList = this.schoolRepository.GetAllSchoolList(school); schoolList._message = SUCCESS; schoolList._failure = false; logger.Info("Method getAllSchools end with success."); } else { schoolList._failure = true; schoolList._message = TOKENINVALID; return(schoolList); } } catch (Exception ex) { schoolList._message = ex.Message; schoolList._failure = true; logger.Error("Method getAllSchools end with error :" + ex.Message); } return(schoolList); }
/// <summary> /// Get All school for dropdown /// </summary> /// <param name="school"></param> /// <returns></returns> public SchoolListModel GetAllSchools(SchoolListModel school) { SchoolListModel schoolListModel = new SchoolListModel(); try { var schoolList = this.context?.SchoolMaster.Where(x => x.TenantId == school.TenantId).OrderBy(x => x.SchoolName).Select(x => new GetSchoolForView() { SchoolId = x.SchoolId, TenantId = x.TenantId, SchoolName = x.SchoolName.Trim(), Telephone = null, NameOfPrincipal = null, StreetAddress1 = null, Status = null, DateSchoolOpened = x.SchoolDetail.FirstOrDefault().DateSchoolOpened, DateSchoolClosed = x.SchoolDetail.FirstOrDefault().DateSchoolClosed }).ToList(); schoolListModel.GetSchoolForView = schoolList; schoolListModel.PageNumber = null; schoolListModel._pageSize = null; schoolListModel._tenantName = school._tenantName; schoolListModel._token = school._token; schoolListModel._failure = false; } catch (Exception es) { schoolListModel._message = es.Message; schoolListModel._failure = true; schoolListModel._tenantName = school._tenantName; schoolListModel._token = school._token; } return(schoolListModel); }
public SchoolListModel GetAllSchoolList(SchoolListModel school) { SchoolListModel schoolListModel = new SchoolListModel(); try { var schoolList = this.context?.TableSchoolMaster.Where(x => x.TenantId == school.TenantId).OrderBy(x => x.SchoolName).Select(x => new GetSchoolForView() { School_Id = x.SchoolId, Tenant_Id = x.TenantId, School_Name = x.SchoolName.Trim(), Phone = null, Principle = null, School_Address = null, Status = null }).ToList(); schoolListModel.GetSchoolForView = schoolList; schoolListModel.PageNumber = null; schoolListModel._pageSize = null; schoolListModel._tenantName = school._tenantName; schoolListModel._token = school._token; schoolListModel._failure = false; } catch (Exception es) { schoolListModel._message = es.Message; schoolListModel._failure = true; schoolListModel._tenantName = school._tenantName; schoolListModel._token = school._token; } return(schoolListModel); }
public ActionResult <SchoolListModel> GetAllSchoolList(PageResult pageResult) { SchoolListModel schoolList = new SchoolListModel(); try { schoolList = _schoolRegisterService.GetAllSchoolList(pageResult); } catch (Exception es) { schoolList._message = es.Message; schoolList._failure = true; } return(schoolList); }
public SchoolListModel GetAllSchools(PageResult pageResult) { SchoolListModel schoolListModel = new SchoolListModel(); try { var courseInfo = from schoolMaster in this.context?.TableSchoolMaster.ToList() join schoolDetails in this.context?.TableSchoolDetail.ToList() on schoolMaster.SchoolId equals schoolDetails.SchoolId into schoolInfo from schools in schoolInfo.DefaultIfEmpty() select new GetSchoolForView() { School_Name = schoolMaster.SchoolName.Trim(), School_Id = schoolMaster.SchoolId, Tenant_Id = schoolMaster.TenantId, Phone = schools == null ? string.Empty : schools.Telephone.Trim(), Principle = schools == null ? string.Empty : schools.NameOfPrincipal.Trim(), School_Address = schoolMaster.StreetAddress1.Trim() + " " + schoolMaster.StreetAddress2.Trim() + " " + schoolMaster.State.Trim() + " " + schoolMaster.Country.Trim() + " " + schoolMaster.Zip.Trim(), Status = schools?.Status }; schoolListModel.TotalCount = courseInfo.Count(); //courseInfo=courseInfo.Where(s => s.School_Name.Contains(pageResult.FilterText) || s.Principle.Contains(pageResult.FilterText) || s.School_Address.Contains(pageResult.FilterText) || s.Phone.Contains(pageResult.FilterText)).Where(x=>x.School_Name.Equals(pageResult.SchoolNameFilter)); courseInfo = courseInfo.OrderBy(x => x.School_Name).Skip((pageResult.PageNumber - 1) * pageResult.PageSize).Take(pageResult.PageSize).ToList(); schoolListModel.GetSchoolForView = courseInfo.ToList(); schoolListModel.PageNumber = pageResult.PageNumber; schoolListModel._pageSize = pageResult.PageSize; schoolListModel._tenantName = pageResult._tenantName; schoolListModel._token = pageResult._token; schoolListModel._failure = false; } catch (Exception es) { schoolListModel._message = es.Message; schoolListModel._failure = true; schoolListModel._tenantName = pageResult._tenantName; schoolListModel._token = pageResult._token; } return(schoolListModel); }
/// <summary> /// Get SchoolsList with pagination /// </summary> /// <param name="pageResult"></param> /// <returns></returns> public SchoolListModel GetAllSchoolList(PageResult pageResult) { int resultData; SchoolListModel schoolListModel = new SchoolListModel(); IQueryable <SchoolMaster> transactionIQ = null; var SchoolMasterList = this.context?.SchoolMaster .Include(d => d.SchoolDetail) .Where(x => x.TenantId == pageResult.TenantId); try { if (pageResult.FilterParams == null || pageResult.FilterParams.Count == 0) { //string sortField = "SchoolName"; string sortOrder = "desc"; transactionIQ = SchoolMasterList; } else { if (pageResult.FilterParams != null && pageResult.FilterParams.ElementAt(0).ColumnName == null && pageResult.FilterParams.Count == 1) { string Columnvalue = pageResult.FilterParams.ElementAt(0).FilterValue; transactionIQ = SchoolMasterList.Where(x => x.SchoolName.ToLower().Contains(Columnvalue.ToLower()) || x.StreetAddress1.ToLower().Contains(Columnvalue.ToLower()) || x.StreetAddress2.ToLower().Contains(Columnvalue.ToLower()) || x.Zip.ToLower().Contains(Columnvalue.ToLower()) || x.State.ToLower().Contains(Columnvalue.ToLower()) || x.City.ToLower().Contains(Columnvalue.ToLower())); var childTelephoneFilter = SchoolMasterList.Where(x => x.SchoolDetail.FirstOrDefault() != null ? x.SchoolDetail.FirstOrDefault().Telephone.ToLower().Contains(Columnvalue.ToLower()) : string.Empty.Contains(Columnvalue)); if (childTelephoneFilter.ToList().Count > 0) { transactionIQ = transactionIQ.Concat(childTelephoneFilter); } var childNameOfPrincipalFilter = SchoolMasterList.Where(x => x.SchoolDetail.FirstOrDefault() != null ? x.SchoolDetail.FirstOrDefault().NameOfPrincipal.ToLower().Contains(Columnvalue.ToLower()) : string.Empty.Contains(Columnvalue)); if (childNameOfPrincipalFilter.ToList().Count > 0) { transactionIQ = transactionIQ.Concat(childNameOfPrincipalFilter); } var countryFilter = this.context?.Country.Where(x => x.Name.ToLower().Contains(Columnvalue.ToLower())); if (countryFilter.ToList().Count > 0) { foreach (var country in countryFilter.ToList()) { var countrySearch = SchoolMasterList.Where(x => x.Country == country.Id.ToString()); if (countrySearch.ToList().Count > 0) { transactionIQ = transactionIQ.Concat(countrySearch); } } } } else { transactionIQ = Utility.FilteredData(pageResult.FilterParams, SchoolMasterList).AsQueryable(); } transactionIQ = transactionIQ.Distinct(); } if (pageResult.SortingModel != null) { switch (pageResult.SortingModel.SortColumn.ToLower()) { case "nameofprincipal": if (pageResult.SortingModel.SortDirection.ToLower() == "asc") { transactionIQ = transactionIQ.OrderBy(a => a.SchoolDetail.Count > 0 ? a.SchoolDetail.FirstOrDefault().NameOfPrincipal : null); } else { transactionIQ = transactionIQ.OrderByDescending(a => a.SchoolDetail.Count > 0 ? a.SchoolDetail.FirstOrDefault().NameOfPrincipal : null); } break; default: transactionIQ = Utility.Sort(transactionIQ, pageResult.SortingModel.SortColumn, pageResult.SortingModel.SortDirection.ToLower()); break; } } int totalCount = transactionIQ.Count(); transactionIQ = transactionIQ.Skip((pageResult.PageNumber - 1) * pageResult.PageSize).Take(pageResult.PageSize); var schoollist = transactionIQ.AsNoTracking().Select(s => new GetSchoolForView { SchoolId = s.SchoolId, SchoolName = s.SchoolName, TenantId = s.TenantId, Telephone = s.SchoolDetail.FirstOrDefault() == null ? string.Empty : s.SchoolDetail.FirstOrDefault().Telephone == null ? string.Empty : s.SchoolDetail.FirstOrDefault().Telephone.Trim(), NameOfPrincipal = s.SchoolDetail.FirstOrDefault() == null ? string.Empty : s.SchoolDetail.FirstOrDefault().NameOfPrincipal == null ? string.Empty : s.SchoolDetail.FirstOrDefault().NameOfPrincipal.Trim(), StreetAddress1 = s.SchoolDetail.FirstOrDefault() == null ? string.Empty : ToFullAddress(s.StreetAddress1, s.StreetAddress2, int.TryParse(s.City, out resultData) == true ? this.context.City.Where(x => x.Id == Convert.ToInt32(s.City)).FirstOrDefault().Name : s.City, int.TryParse(s.State, out resultData) == true ? this.context.State.Where(x => x.Id == Convert.ToInt32(s.State)).FirstOrDefault().Name : s.State, int.TryParse(s.Country, out resultData) == true ? this.context.Country.Where(x => x.Id == Convert.ToInt32(s.Country)).FirstOrDefault().Name : string.Empty, s.Zip), Status = s.SchoolDetail.FirstOrDefault() == null ? false : s.SchoolDetail.FirstOrDefault().Status == null ? false : s.SchoolDetail.FirstOrDefault().Status }).ToList(); schoolListModel.TenantId = pageResult.TenantId; schoolListModel.GetSchoolForView = schoollist; schoolListModel.TotalCount = totalCount; schoolListModel.PageNumber = pageResult.PageNumber; schoolListModel._pageSize = pageResult.PageSize; schoolListModel._tenantName = pageResult._tenantName; schoolListModel._token = pageResult._token; schoolListModel._failure = false; } catch (Exception es) { schoolListModel._message = es.Message; schoolListModel._failure = true; schoolListModel._tenantName = pageResult._tenantName; schoolListModel._token = pageResult._token; } return(schoolListModel); }