public BedTemplate Edit(BedTemplate newBedTemplate)
{
BedTemplate original = GetById(newBedTemplate.Id, newBedTemplate.UserId);
original.Name = newBedTemplate.Name != null ? newBedTemplate.Name : original.Name;
original.Width = newBedTemplate.Width != 0 ? newBedTemplate.Width : original.Width;
original.Height = newBedTemplate.Height != 0 ? newBedTemplate.Height : original.Height;
original.Img = newBedTemplate.Img != null ? newBedTemplate.Img : original.Img;
return(_repo.Edit(original));
}
public ActionResult <BedTemplate> Post([FromBody] BedTemplate newBedTemplate)
{
try
{
var userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
newBedTemplate.UserId = userId;
return(Ok(_bts.Create(newBedTemplate)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
// internal IEnumerable<Garden> Get()
// {
// string sql = "SELECT * FROM BedTemplates WHERE isPrivate = 0;";
// return _db.Query<Garden>(sql);
// }
internal BedTemplate Create(BedTemplate BedTemplateData)
{
string sql = @"
INSERT INTO bedtemplates
(name, userId, width, height, img)
VALUES
(@Name, @UserId, @Width, @Height, @Img);
SELECT LAST_INSERT_ID();
";
BedTemplateData.Id = _db.ExecuteScalar <int>(sql, BedTemplateData);
return(BedTemplateData);
}
public ActionResult <BedTemplate> Edit(int id, [FromBody] BedTemplate editedBedTemplate)
{
try
{
editedBedTemplate.Id = id;
string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
editedBedTemplate.UserId = userId;
return(Ok(_bts.Edit(editedBedTemplate)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
internal BedTemplate Edit(BedTemplate EditedBedTemplate)
{
string sql = @"
UPDATE bedtemplates
SET
name = @Name,
width = @Width,
height = @Height,
img = @Img,
WHERE (id = @Id AND userId = @UserId);
";
_db.Execute(sql, EditedBedTemplate);
return(EditedBedTemplate);
}
public BedTemplate Create(BedTemplate newBedTemplate)
{
return(_repo.Create(newBedTemplate));
}
