public ActionResult <Models.EnclosureSpecs> CreateEnclosureSpecs(Models.EnclosureSpecs enclosureSpecs) { try { return(Created("https://localhost:5001/EnclosureSpecs", _enclosureSpecs.CreateEnclosureSpecs(enclosureSpecs))); } catch (Exception ex) { _logger.LogError("Error", ex); return(BadRequest()); } }
public Models.EnclosureSpecs CreateEnclosureSpecs(Models.EnclosureSpecs enclosureSpecs) { if (!DoesEnclosureExist(enclosureSpecs.EnclosureId)) { return(null); } var newEnclosureSpecs = new Models.EnclosureSpecs() { Rows = enclosureSpecs.Rows, Columns = enclosureSpecs.Columns, EnclosureId = enclosureSpecs.EnclosureId }; const string insertQuery = "INSERT INTO Electric.EnclosureSpecs VALUES (@rows, @columns, @enclosureId); SELECT * FROM Electric.EnclosureSpecs WHERE id = SCOPE_IDENTITY()"; return(_database.QueryFirst <Models.EnclosureSpecs>(insertQuery, newEnclosureSpecs)); }