public BedGroupViewModel EditBedsByGroupId(BedGroupViewModel newBed)
{
if (newBed.DatePlanted != null && newBed.DateFertilized != null && newBed.Name != null && newBed.Height != 0 && newBed.Width != 0 && newBed.Img != null && newBed.Description != null)
{
return(_repo.EditBedsInGroup(newBed));
}
throw new Exception("Some properties are null");
}
public ActionResult <BedGroupViewModel> EditBedsByGroupId(int id, [FromBody] BedGroupViewModel editedBed)
{
try
{
editedBed.BedGroupId = id;
string userId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
editedBed.UserId = userId;
return(Ok(_bs.EditBedsByGroupId(editedBed)));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
internal BedGroupViewModel EditBedsInGroup(BedGroupViewModel bed)
{
string sql = @"
UPDATE beds
SET
name = @Name,
description = @Description,
width = @Width,
height = @Height,
datePlanted = @DatePlanted,
dateFertilized = @DateFertilized,
img = @Img
WHERE (userId = @UserId AND bedId FROM bedgroups WHERE (userId = @UserId AND groupId = @BedGroupId) = id);";
_db.Execute(sql, bed);
return(bed);
}
