internal Undertaking Edit(Undertaking updated)
{
Undertaking original = GetById(updated.Id);
if (updated.creatorId != original.creatorId)
{
throw new Exception("You cannot edit this.");
}
return(_urepo.Edit(updated));
}
internal Undertaking GetById(int id)
{
Undertaking data = _urepo.GetById(id);
if (data == null)
{
throw new Exception("Invalid id");
}
return(data);
}
internal Undertaking Edit(Undertaking updated)
{
string sql = @"
UPDATE undertakings
SET
name = @Name
WHERE id = @Id;";
_db.Execute(sql, updated);
return(updated);
}
public ActionResult <Undertaking> Create([FromBody] Undertaking newUnder)
{
try
{
return(Ok(_uservice.Create(newUnder)));
}
catch (System.Exception error)
{
return(BadRequest(error.Message));
}
}
internal Undertaking Delete(int id, string userId)
{
Undertaking original = GetById(id);
if (userId != original.creatorId)
{
throw new Exception("You cannot delete this.");
}
_urepo.Delete(id);
return(original);
}
public ActionResult <Undertaking> Edit([FromBody] Undertaking updated, int id)
{
try
{
updated.Id = id;
return(Ok(_uservice.Edit(updated)));
}
catch (System.Exception error)
{
return(BadRequest(error.Message));
}
}
internal Undertaking Create(Undertaking newundertaking)
{
string sql = @"
INSERT INTO undertakings
(creatorId, name, public)
VALUES
(@CreatorId, @Name, @Public);
SELECT LAST_INSERT_ID();";
int id = _db.ExecuteScalar <int>(sql, newundertaking);
newundertaking.Id = id;
return(newundertaking);
}
internal Undertaking Create(Undertaking newUndertaking)
{
return(_urepo.Create(newUndertaking));
}
