public override void OnActionExecuting(ActionExecutingContext context)
{
_enclosureDao = (EnclosureDao)context.ActionArguments["enclosure"];
using IDbConnection database = new SqlConnection(MyConnectionString);
const string sql = "SELECT * FROM Electric.Project WHERE id = @projectId";
var project = database.QueryFirstOrDefault <ProjectDao>(sql, new { projectId = _enclosureDao.ProjectId });
if (project == null)
{
throw new ProjectNotFountException("Project does not exist!");
}
base.OnActionExecuting(context);
}
private Models.Enclosure TransformDaoToBusinessLogicEnclosure(EnclosureDao enclosureDao)
{
var devices = _device.GetDevicesForEnclosure(enclosureDao.Id);
var enclosure = new Models.Enclosure()
{
Id = enclosureDao.Id,
Name = enclosureDao.Name,
Date = enclosureDao.Date,
ProjectId = enclosureDao.ProjectId,
Devices = devices,
TotalPrice = enclosureDao.TotalPrice,
EnclosureSpecs = _enclosureSpecs.GetEnclosureSpecsByEnclosureId(enclosureDao.Id),
};
return(enclosure);
}
public ActionResult <Models.Enclosure> CreateEnclosure([FromBody] EnclosureDao enclosure)
{
try
{
return(Created("https://localhost:5001/Enclosure", _enclosure.CreateEnclosure(enclosure)));
}
catch (ProjectNotFountException ex)
{
return(NotFound(ex.Message));
}
catch (Exception ex)
{
_logger.LogError("Error", ex);
return(BadRequest());
}
}
public Models.Enclosure CreateEnclosure(EnclosureDao enclosure)
{
// if (!DoesProjectExist(enclosure.ProjectId))
// {
// throw new ProjectNotFountException("Project does not exist!");
// }
var enclosureDao = new EnclosureDao()
{
Name = enclosure.Name,
Date = DateTime.Now,
ProjectId = enclosure.ProjectId,
};
const string insertQuery = "INSERT INTO Electric.Enclosure VALUES (@name, @date, @projectId, null) SELECT * FROM Electric.Enclosure WHERE id = SCOPE_IDENTITY()";
return(TransformDaoToBusinessLogicEnclosure(_database.QueryFirst <EnclosureDao>(insertQuery, enclosureDao)));
}