public async Task <ActionResult <ApplicationCategory> > Insert([FromBody] ApplicationCategory model) { if (ModelState.IsValid == false) { return(BadRequest(ModelState)); } if (model.ApplicationCategoryName == null) { return(BadRequest("Unable to update the Record. Required fields missing")); } var applicationCategory = await(from c in _db.ApplicationCategories where c.ApplicationCategoryName == model.ApplicationCategoryName select c) .AsNoTracking() .FirstOrDefaultAsync(); if (applicationCategory != null) { return(StatusCode(409, "Unable to create the Record. The Record already exists in the Database")); } await _db.ApplicationCategories.AddAsync(model); await _db.SaveChangesAsync(); return(StatusCode(201, "The Record has been Created")); }
//[Route("")] public async Task <ActionResult <ApplicationCategory> > Update(int id, [FromBody] ApplicationCategory model) { if (ModelState.IsValid == false) { return(BadRequest(ModelState)); } if (id != model.ApplicationCategoryId) { return(BadRequest()); } if (model.ApplicationCategoryName == null) { return(BadRequest("Unable to update the Record. Required field missing")); } var applicationCategory = await(from c in _db.ApplicationCategories where c.ApplicationCategoryId != model.ApplicationCategoryId && c.ApplicationCategoryName == model.ApplicationCategoryName select c) .AsNoTracking() .FirstOrDefaultAsync(); if (applicationCategory != null) { return(StatusCode(409, "Unable to update the Record. The Record already exists in teams")); } _db.ApplicationCategories.Update(model); await _db.SaveChangesAsync(); return(Ok("Update successfull")); }
public async Task <IActionResult> Edit(int id, [Bind] ApplicationCategory applicationCategory) { if (id != applicationCategory.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(applicationCategory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ApplicationCategoryExists(applicationCategory.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(applicationCategory)); }
public JsonResult AddCategory(string text, string tt, string tp, IList <ApplicationCategory> categories) { ApplicationCategory model = new ApplicationCategory(); model.Category = text; model.TotalPermanent = tp; model.TotalTemporary = tt; categories.Add(model); return(Json(ResponseStatus.Success, RenderPartialViewToString("ApplicationCategory", categories))); }
public async Task <IActionResult> Create([Bind] ApplicationCategory applicationCategory) { if (ModelState.IsValid) { applicationCategory.State = RowStateEnum.Active; _context.Add(applicationCategory); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(applicationCategory)); }
// GET: Applications/Edit/5 public ActionResult EditCategory(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ApplicationCategory appCategory = db.ApplicationCategories.Find(id); if (appCategory == null) { return(HttpNotFound()); } return(View(appCategory)); }
public ActionResult EditCategory(ApplicationCategoryViewModel appCategory) { if (ModelState.IsValid) { ApplicationCategory mode = new ApplicationCategory { ApplicationCategoryId = appCategory.ApplicationCategoryId, ApplicationName = appCategory.ApplicationName }; db.Entry(mode).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(appCategory)); }
public ActionResult AddApplicationCategory(ApplicationCategoryViewModel vModel) { if (ModelState.IsValid) { ApplicationCategory model = new ApplicationCategory { ApplicationCategoryId = Guid.NewGuid(), ApplicationName = vModel.ApplicationName }; db.ApplicationCategories.Add(model); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vModel)); }
public async Task <ActionResult> Create(CreateCategoryViewModel model) { if (ModelState.IsValid) { ApplicationCategory category = new ApplicationCategory { CategoryName = model.CategoryName, UserId = User.Identity.GetUserId() }; db.Categories.Add(category); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(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 AddCategoryEditor() { ApplicationCategory model = new ApplicationCategory(); return(Json(ResponseStatus.Success, RenderPartialViewToString("AddCategory", model), JsonRequestBehavior.AllowGet)); }
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")); }