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