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);
}
