public ContractorPresentationStub(contractor dbItem)
{
this.Id = dbItem.id;
this.Name = dbItem.name;
this.Deleted = dbItem.deleted;
this.ContractorType = dbItem.contractor_type;
}
public ActionResult Edit(int id)
{
contractor contractor = RepoContractor.FindByPk(id);
ContractorFormStub formStub = new ContractorFormStub(contractor);
return(View("Form", formStub));
}
internal string Delete(int id)
{
contractor data = GetById(id);
_repo.Delete(id);
return("delorted");
}
public ActionResult Create(ContractorFormStub model)
{
//bool isNameExist = RepoContractor.Find().Where(p => p.name == model.Name).Count() > 0;
if (ModelState.IsValid)
{
contractor dbItem = new contractor();
dbItem = model.GetDbObject(dbItem);
try
{
RepoContractor.Save(dbItem);
}
catch (Exception e)
{
return(View("Form", model));
}
//message
string template = HttpContext.GetGlobalResourceObject("MyGlobalMessage", "CreateSuccess").ToString();
this.SetMessage(model.Name, template);
return(RedirectToAction("Index"));
}
else
{
return(View("Form", model));
}
}
public ActionResult Register()
{
ViewBag.questions = new SelectList(db.securityques, "id", "qdesc");
contractor c = new contractor();
c.userid = "CTR" + (db.contractors.Count() + 1).ToString("D4");
return(View(c));
}
public ContractorFormStub(contractor dbItem)
: this()
{
this.Id = dbItem.id;
this.Name = dbItem.name;
this.Deleted = dbItem.deleted;
this.ContractorType = dbItem.contractor_type;
}
public contractor GetDbObject(contractor dbItem)
{
dbItem.id = this.Id;
dbItem.name = this.Name;
dbItem.deleted = this.Deleted;
dbItem.contractor_type = this.ContractorType;
return(dbItem);
}
public Contractor MapContractor(contractor contractor)
{
return(new Contractor()
{
OrganisationIdentifier = contractor.organisationIdentifier,
Ukprn = contractor.ukprn,
LegalName = contractor.legalName,
});
}
public JsonResult Delete(int id)
{
string template = "";
ResponseModel response = new ResponseModel(true);
contractor dbItem = RepoContractor.FindByPk(id);
RepoContractor.Delete(dbItem);
return(Json(response));
}
internal contractor GetById(int id)
{
contractor data = _repo.GetById(id);
if (data == null)
{
throw new Exception("Invalid Id");
}
return(data);
}
public ActionResult <contractor> Create([FromBody] contractor newProd)
{
try
{
return(Ok(_service.Create(newProd)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public ActionResult Register(contractor c)
{
if (ModelState.IsValid)
{
db.contractors.Add(c);
db.SaveChanges();
TempData["msg"] = "New User Created Successfully";
return(Redirect("/"));
}
ViewBag.questions = new SelectList(db.securityques, "id", "qdesc");
return(View(c));
}
public ActionResult <contractor> Edit([FromBody] contractor updated, int id)
{
try
{
updated.Id = id;
return(Ok(_service.Edit(updated)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public void Save(contractor dbItem)
{
if (dbItem.id == 0) //create
{
context.contractors.Add(dbItem);
}
else //edit
{
var entry = context.Entry(dbItem);
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
internal contractor Create(contractor newcontractor)
{
string sql = @"
INSERT INTO contractors
(name, description, kingdomCred, id, jobId)
VALUES
(@Name, @Description, @kingdomCred, @id, @jobId);
SELECT LAST_INSERT_ID();";
int id = _db.ExecuteScalar <int>(sql, newcontractor);
newcontractor.Id = id;
return(newcontractor);
}
internal contractor Edit(contractor contractorToEdit)
{
string sql = @"
UPDATE contractors
SET
name = @Name,
description = @Description,
kingdomCred = @KingdomCred,
jobId = @jobId
WHERE id = @Id;
SELECT * FROM contractors WHERE id = @Id;";
return(_db.QueryFirstOrDefault <contractor>(sql, contractorToEdit));
}
internal contractor Edit(contractor updated)
{
// REVIEW
contractor data = GetById(updated.Id);
//null check properties you are editing in repo
data.Description = updated.Description != null ? updated.Description : data.Description;
data.Name = updated.Name != null ? updated.Name : data.Name;
//remember if null checking an integer put an Elvis operator ? in the model following the type
data.KingdomCred = updated.KingdomCred != null ? updated.KingdomCred : data.KingdomCred;
return(_repo.Edit(data));
}
public async Task <ActionResult> Post(contractor new_contractor)
{
if (ModelState.IsValid)
{
var result = await dbContext.fdc_contractors.AddAsync(new_contractor);
if (result != null && result.State == EntityState.Added)
{
await dbContext.SaveChangesAsync();
var response = await dbContext.GetContractor(result.Entity.contractor_id);
return(Ok(response));
}
return(NotFound());
}
return(BadRequest());
}
public void MapContractor()
{
var organisationIdentifier = "OrganisationIdentifier";
var ukprn = 123456789;
var legalName = "LegalName";
var fcsContractor = new contractor()
{
organisationIdentifier = organisationIdentifier,
ukprn = ukprn,
legalName = legalName
};
var contractor = NewService().MapContractor(fcsContractor);
contractor.OrganisationIdentifier.Should().Be(organisationIdentifier);
contractor.Ukprn.Should().Be(ukprn);
contractor.LegalName.Should().Be(legalName);
}
public async Task <ActionResult> Put(int id, contractor modify_contractor)
{
if (ModelState.IsValid)
{
modify_contractor.contractor_id = id;
var result = dbContext.fdc_contractors.Update(modify_contractor);
if (result != null && result.State == EntityState.Modified)
{
await dbContext.SaveChangesAsync();
var response = await dbContext.GetContractor(result.Entity.contractor_id);
return(Ok(response));
}
return(NotFound());
}
return(BadRequest());
}
public void Delete(contractor dbItem)
{
context.contractors.Remove(dbItem);
context.SaveChanges();
}
internal contractor Create(contractor newProd)
{
return(_repo.Create(newProd));
}
