public static ApplicationList FilterApplications(DASEntities db, GridDescriptor desc, ApplicationListFilterModel filters)
{
ApplicationList model = new ApplicationList()
{
Descriptor = desc, ListOfApplication = new List <DAS.Backoffice.Models.Application.ApplicationForm>()
};
IQueryable <DAS.Domain.Model.ApplicationForm> applications = db.ApplicationForms.AsQueryable();
int languageId = (int)HttpContext.Current.Session["lngId"];
if (filters == null)
{
filters = new ApplicationListFilterModel();
}
string filApplication = "";
if (!string.IsNullOrWhiteSpace(filters.Name))
{
filApplication = filters.Name.Replace(":", "").Replace("/", "").Replace("-", "").Replace("–", "").Replace("\"", "").Replace(".", "");
applications = applications.Where(m => m.CompanyName.Contains(filApplication));
}
IList <DAS.Domain.Model.ApplicationForm> listA = applications.Slice(desc).ToList();
DAS.Backoffice.Models.Application.ApplicationForm applicationModel;
foreach (var item in listA)
{
applicationModel = new DAS.Backoffice.Models.Application.ApplicationForm()
{
ApplicationId = item.ApllicationId, CompanyName = item.CompanyName, Adress = item.Adress, Place = item.Place, Telephone = item.Telephone, Email = item.Email, Applicant = item.Applicant,
ISO14001 = (bool)item.ISO14001, ISO22301 = (bool)item.ISO22301, ISO27001 = (bool)item.ISO27001, ISO9001 = (bool)item.ISO9001, OtherIso = (bool)item.OtherIso, Other = item.Other,
CompanyWebsite = item.CompanyWebsite, PrimaryContactForAuditPurposes = item.PrimaryContactForAuditPurposes, PrimaryContactTelephone = item.PrimaryContactTelephone,
NatureOfBusiness = item.NatureOfBusiness, NumberOfYearsAtThisSite = item.NumberOfYearsAtThisSite, PrincipleServicesOrProducts = item.PrincipleServicesOrProducts,
ActivitiesOnClientsSites = item.ActivitiesOnClientsSites, NameOfPresentCertificationBody = item.NameOfPresentCertificationBody, CertificateExpiryDate = item.CertificateExpiryDate,
TotalNumberOfEmployees = item.TotalNumberOfEmployees, TotalNumberOfCompanyDirectors = item.TotalNumberOfCompanyDirectors, NumberOfLocations = item.NumberOfLocations,
AllSitesMainActivites = item.AllSitesMainActivites, SalesTotalPermanent = item.SalesTotalPermanent, SalesTotalTemporary = item.SalesTotalTemporary, MarketingTotalPermanent = item.MarketingTotalPermanent,
MarketingTotalTemporary = item.MarketingTotalTemporary, AdministrationTotalPermanent = item.AdministrationTotalPermanent, AdministrationTotalTemporary = item.AdministrationTotalTemporary,
DesignTotalPermanent = item.DesignTotalPermanent, DesignTotalTemporary = item.DesignTotalTemporary, ManufacturingTotalPermanent = item.ManufacturingTotalPermanent, ManufacturingTotalTemporary = item.ManufacturingTotalTemporary,
OtherTotalPermanent = item.OtherTotalPermanent, OtherTotalTemporary = item.OtherTotalTemporary, TotalPermanent = item.TotalPermanent, TotalTemporary = item.TotalTemporary, Extension = item.Extension, ManagementRepresentativeName = item.ManagementRepresentativeName,
JobTitle = item.JobTitle, NameOfConsultant = item.NameOfConsultant, ConsultantTelephone = item.ConsultantTelephone, ISO14001_2 = (bool)item.ISO14001_2, ISO9001_2 = (bool)item.ISO9001_2,
ISO22301_2 = (bool)item.ISO22301_2, ISO27001_2 = (bool)item.ISO27001_2, BSOHSAS18001_2 = (bool)item.BSOHSAS18001_2, StandardTransferred = item.StandardTransferred,
DateNextCertificationBodyVisit = item.DateNextCertificationBodyVisit, Other_2 = item.Other_2, OtherIso_2 = (bool)item.OtherIso_2, date_created = (DateTime)item.DateCreated
};
model.ListOfApplication.Add(applicationModel);
}
return(model);
}
public JsonResult FindApplication(ApplicationListFilterModel filters, GridDescriptor request)
{
ApplicationList model = HomeBuilder.FilterApplications(Db, request, filters);
return(Json(ResponseStatus.Success, RenderPartialViewToString("ApplicationList", model)));
}
