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 static ApplicationsModel BuildApplications(DASEntities db) { ApplicationsModel model = new ApplicationsModel(); int languageId = (int)HttpContext.Current.Session["lngId"]; GridDescriptor desc = new GridDescriptor(new SortDescriptor() { PropertyName = "DateCreated", Order = SortOrder.Descending }) { Pager = new PagerDescriptor(1, 20, db.Labels.Where(l => l.ViewId == "Clients" && l.ElementId == "lblPageSize" && l.LanguageId == languageId).Select(l => l.Text).FirstOrDefault(), 5) }; IQueryable <DAS.Domain.Model.ApplicationForm> applications = db.ApplicationForms.AsQueryable(); IList <DAS.Domain.Model.ApplicationForm> listA = applications.Slice(desc).ToList(); model.Filters = new ApplicationListFilterModel(); model.Applications = new ApplicationList() { Descriptor = desc, ListOfApplication = new List <DAS.Backoffice.Models.Application.ApplicationForm>() }; 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, ManufacturingTotalTemporary = item.ManufacturingTotalTemporary, MarketingTotalTemporary = item.MarketingTotalTemporary, AdministrationTotalPermanent = item.AdministrationTotalPermanent, AdministrationTotalTemporary = item.AdministrationTotalTemporary, DesignTotalPermanent = item.DesignTotalPermanent, DesignTotalTemporary = item.DesignTotalTemporary, ManufacturingTotalPermanent = item.ManufacturingTotalPermanent, 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.Applications.ListOfApplication.Add(applicationModel); } return(model); }
public ActionResult OpenApplicationDetails(int ApplicationId) { DAS.Backoffice.Models.Application.ApplicationForm model = Db.ApplicationForms.Where(m => m.ApllicationId == ApplicationId).Select(m => new DAS.Backoffice.Models.Application.ApplicationForm() { ApplicationId = m.ApllicationId, BSOHSAS18001 = (bool)m.BSOHSAS18001, CompanyName = m.CompanyName, Adress = m.Adress, Place = m.Place, Email = m.Email, Telephone = m.Telephone, Applicant = m.Applicant, ISO14001 = (bool)m.ISO14001, ISO22301 = (bool)m.ISO22301, ISO27001 = (bool)m.ISO27001, ISO9001 = (bool)m.ISO9001, OtherIso = (bool)m.OtherIso, Other = m.Other, CompanyWebsite = m.CompanyWebsite, PrimaryContactForAuditPurposes = m.PrimaryContactForAuditPurposes, PrimaryContactTelephone = m.PrimaryContactTelephone, NatureOfBusiness = m.NatureOfBusiness, NumberOfYearsAtThisSite = m.NumberOfYearsAtThisSite, PrincipleServicesOrProducts = m.PrincipleServicesOrProducts, ActivitiesOnClientsSites = m.ActivitiesOnClientsSites, NameOfPresentCertificationBody = m.NameOfPresentCertificationBody, CertificateExpiryDate = m.CertificateExpiryDate, TotalNumberOfEmployees = m.TotalNumberOfEmployees, TotalNumberOfCompanyDirectors = m.TotalNumberOfCompanyDirectors, NumberOfLocations = m.NumberOfLocations, AllSitesMainActivites = m.AllSitesMainActivites, TotalPermanent = m.TotalPermanent, TotalTemporary = m.TotalTemporary, Extension = m.Extension, ManagementRepresentativeName = m.ManagementRepresentativeName, JobTitle = m.JobTitle, NameOfConsultant = m.NameOfConsultant, ConsultantTelephone = m.ConsultantTelephone, ISO14001_2 = (bool)m.ISO14001_2, ISO9001_2 = (bool)m.ISO9001_2, ISO22301_2 = (bool)m.ISO22301_2, ISO27001_2 = (bool)m.ISO27001_2, BSOHSAS18001_2 = (bool)m.BSOHSAS18001_2, StandardTransferred = m.StandardTransferred, DateNextCertificationBodyVisit = m.DateNextCertificationBodyVisit, Other_2 = m.Other_2, OtherIso_2 = (bool)m.OtherIso_2 }).FirstOrDefault(); model.Categories = new List <ApplicationCategory>(); IList <ApplicationFormCatagory> categories = Db.ApplicationFormCatagories.Where(j => j.ApplicationId == ApplicationId).ToList(); ApplicationCategory temp; foreach (var item in categories) { temp = new ApplicationCategory() { ApplicationId = ApplicationId, CategoryId = item.CategoryId, Category = item.Category, TotalPermanent = item.TotalPermanent, TotalTemporary = item.TotalTemporary }; model.Categories.Add(temp); } model.locationActivities = new List <ApplicationLocationActivities>(); IList <AppFormLocationActivity> locAct = Db.AppFormLocationActivities.Where(k => k.ApplicationId == ApplicationId).ToList(); ApplicationLocationActivities pom; foreach (var item in locAct) { pom = new ApplicationLocationActivities() { applicationId = ApplicationId, id = item.Id, location = item.Location, activity = item.Activity, }; model.locationActivities.Add(pom); } return(Json(ResponseStatus.Success, RenderPartialViewToString("OpenApplicationDetails", model))); }
public ActionResult ApplicationWord(int appId) { MemoryStream stream = new MemoryStream(); string path = Server.MapPath("~/Content/"); DAS.Backoffice.Models.Application.ApplicationForm model = Db.ApplicationForms.Where(m => m.ApllicationId == appId).Select(m => new DAS.Backoffice.Models.Application.ApplicationForm() { ApplicationId = m.ApllicationId, CompanyName = m.CompanyName, Adress = m.Adress, Place = m.Place, Telephone = m.Telephone, Email = m.Email, Applicant = m.Applicant, ISO14001 = (bool)m.ISO14001, ISO22301 = (bool)m.ISO22301, ISO27001 = (bool)m.ISO27001, ISO9001 = (bool)m.ISO9001, BSOHSAS18001 = (bool)m.BSOHSAS18001, OtherIso = (bool)m.OtherIso, Other = m.Other, CompanyWebsite = m.CompanyWebsite, PrimaryContactForAuditPurposes = m.PrimaryContactForAuditPurposes, PrimaryContactTelephone = m.PrimaryContactTelephone, NatureOfBusiness = m.NatureOfBusiness, NumberOfYearsAtThisSite = m.NumberOfYearsAtThisSite, PrincipleServicesOrProducts = m.PrincipleServicesOrProducts, ActivitiesOnClientsSites = m.ActivitiesOnClientsSites, NameOfPresentCertificationBody = m.NameOfPresentCertificationBody, CertificateExpiryDate = m.CertificateExpiryDate, TotalNumberOfEmployees = m.TotalNumberOfEmployees, TotalNumberOfCompanyDirectors = m.TotalNumberOfCompanyDirectors, NumberOfLocations = m.NumberOfLocations, AllSitesMainActivites = m.AllSitesMainActivites, SalesTotalPermanent = m.SalesTotalPermanent, SalesTotalTemporary = m.SalesTotalTemporary, MarketingTotalPermanent = m.MarketingTotalPermanent, ManufacturingTotalTemporary = m.ManufacturingTotalTemporary, MarketingTotalTemporary = m.MarketingTotalTemporary, AdministrationTotalPermanent = m.AdministrationTotalPermanent, AdministrationTotalTemporary = m.AdministrationTotalTemporary, DesignTotalPermanent = m.DesignTotalPermanent, DesignTotalTemporary = m.DesignTotalTemporary, ManufacturingTotalPermanent = m.ManufacturingTotalPermanent, OtherTotalPermanent = m.OtherTotalPermanent, OtherTotalTemporary = m.OtherTotalTemporary, TotalPermanent = m.TotalPermanent, TotalTemporary = m.TotalTemporary, Extension = m.Extension, ManagementRepresentativeName = m.ManagementRepresentativeName, JobTitle = m.JobTitle, NameOfConsultant = m.NameOfConsultant, ConsultantTelephone = m.ConsultantTelephone, ISO14001_2 = (bool)m.ISO14001_2, ISO9001_2 = (bool)m.ISO9001_2, ISO22301_2 = (bool)m.ISO22301_2, ISO27001_2 = (bool)m.ISO27001_2, BSOHSAS18001_2 = (bool)m.BSOHSAS18001_2, StandardTransferred = m.StandardTransferred, DateNextCertificationBodyVisit = m.DateNextCertificationBodyVisit, Other_2 = m.Other_2, OtherIso_2 = (bool)m.OtherIso_2, date_created = (DateTime)m.DateCreated }).FirstOrDefault(); model.Categories = new List <ApplicationCategory>(); IList <ApplicationFormCatagory> categories = Db.ApplicationFormCatagories.Where(j => j.ApplicationId == appId).ToList(); ApplicationCategory temp; foreach (var item in categories) { temp = new ApplicationCategory() { ApplicationId = appId, CategoryId = item.CategoryId, Category = item.Category, TotalPermanent = item.TotalPermanent, TotalTemporary = item.TotalTemporary }; model.Categories.Add(temp); } model.locationActivities = new List <ApplicationLocationActivities>(); IList <AppFormLocationActivity> locAct = Db.AppFormLocationActivities.Where(k => k.ApplicationId == appId).ToList(); ApplicationLocationActivities pom; foreach (var item in locAct) { pom = new ApplicationLocationActivities() { applicationId = appId, id = item.Id, location = item.Location, activity = item.Activity }; model.locationActivities.Add(pom); } Aspose.Words.Document dst = ReportBuilder.Execute("", path, model); dst.Save(stream, SaveFormat.Doc); byte[] docData = stream.ToArray(); stream.Dispose(); return(File(docData, "application/doc", model.CompanyName + ".doc")); }