public Models.SellingPoint CreateSellingPoint(SellingPointDto sellingPointDto) { const string sql = "INSERT INTO SkiTickets.SellingPoint VALUES (@name, @location)" + " SELECT * FROM SkiTickets.SellingPoint WHERE id = SCOPE_IDENTITY()"; return(TransformDaoToBusinessLogicSellingPoint(_database.QueryFirst <SellingPointDao>(sql, new { name = sellingPointDto.Name, location = sellingPointDto.Location }))); }
public Models.SellingPoint UpdateSellingPoint(int id, SellingPointDto sellingPointDto) { const string sql = "UPDATE SkiTickets.SellingPoint SET name = @name, location = @location WHERE id = @id"; _database.Execute(sql, new { id = id, name = sellingPointDto.Name, location = sellingPointDto.Location, }); return(GetSellingPointById(id)); }
public ActionResult <Models.Person> CreatePerson([FromBody] SellingPointDto sellingPointDto) { try { return(Created("https://localhost:5001/SellingPoint", new OkResponse <Models.SellingPoint>(_sellingPoint.CreateSellingPoint(sellingPointDto)))); } catch (SellingPointBadRequestException e) { return(BadRequest(new ErrorResponse(e.Message, new List <string>() { "sellingPoint" }))); } catch (Exception e) { return(BadRequest(new ErrorResponse(e.Message, new List <string>() { "sellingPoint" }))); } }
public ActionResult <Models.SellingPoint> UpdateSellingPoint(int sellingPointId, SellingPointDto sellingPointDto) { try { return(Ok(new OkResponse <Models.SellingPoint>(_sellingPoint.UpdateSellingPoint(sellingPointId, sellingPointDto)))); } catch (SellingPointNotFoundException e) { return(NotFound(e.Message)); } catch (SellingPointBadRequestException e) { return(BadRequest(new ErrorResponse(e.Message, new List <string>() { "sellingPoint", "sellingPointId" }))); } catch (Exception e) { return(BadRequest(new ErrorResponse(e.Message, new List <string>() { "sellingPoint", "sellingPointId" }))); } }