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