public IActionResult AddNewClinker(AddNewClinkerCommand newClinker)
{
var existingClinker = _repository.GetIdByClinkerName(newClinker.FirstName, newClinker.LastName, newClinker.PrisonTermEndDate);
if (existingClinker == null)
{
var createdClinker = _repository.AddNewClinker(newClinker);
return(Created("", createdClinker));
}
else
{
return(BadRequest("Clinker already exists."));
}
}
public Clinker AddNewClinker(AddNewClinkerCommand newClinker)
{
var sql = @"INSERT INTO CLINKER (FirstName, LastName, PrisonTermEndDate)
output inserted.*
VALUES (@FirstName, @LastName, @PrisonTermEndDate)";
using (var db = new SqlConnection(ConnectionString))
{
var parameters = new
{
FirstName = newClinker.FirstName,
LastName = newClinker.LastName,
PrisonTermEndDate = newClinker.PrisonTermEndDate
};
var result = db.QueryFirstOrDefault <Clinker>(sql, parameters);
return(result);
}
}
