Exemple #1
0
 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());
     }
 }
Exemple #2
0
        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));
        }