internal int PostSD(SiteDown newSD)
{
string sql = @"
INSERT INTO sitedowns
(creatorId, siteNum, siteName, cause, solved)
VALUES
(@CreatorId, @SiteNum, @SiteName, @Cause, @Solved);
SELECT LAST_INSERT_ID();";
return(_db.ExecuteScalar <int>(sql, newSD));
}
internal SiteDown EditSD(SiteDown editedSD)
{
string sql = @"
UPDATE sitedowns
SET
creatorId = @CreatorId,
siteNum = @SiteNum,
siteName = @SiteName,
cause = @Cause,
solved = @Solved
WHERE id = @Id;";
_db.Execute(sql, editedSD);
return(editedSD);
}
public async Task <ActionResult <SiteDown> > EditSD(int sd_id, [FromBody] SiteDown editedSD)
{
try
{
Profile userInfo = await HttpContext.GetUserInfoAsync <Profile>();
editedSD.Creator = userInfo;
editedSD.Id = sd_id;
return(Ok(_service.EditSD(editedSD, userInfo.Id)));
}
catch (System.Exception e)
{
return(BadRequest(e.Message));
}
}
public async Task <ActionResult <SiteDown> > PostSiteDown([FromBody] SiteDown newSD)
{
try
{
Profile userInfo = await HttpContext.GetUserInfoAsync <Profile>();
newSD.CreatorId = userInfo.Id;
SiteDown created = _service.PostSD(newSD);
created.Creator = userInfo;
return(Ok(created));
}
catch (System.Exception e)
{
return(BadRequest(e.Message));
}
}
internal object DeleteSD(int sd_id, string userId)
{
SiteDown original = _repo.GetById(sd_id);
if (original == null)
{
throw new Exception("Invalid sitedown id");
}
if (original.CreatorId != userId)
{
throw new Exception("NOT AUTHORIZED");
}
_repo.DeleteSD(sd_id);
return("Successfully Deleted");
}
internal SiteDown EditSD(SiteDown editedSD, string userId)
{
SiteDown original = _repo.GetById(editedSD.Id);
if (original == null)
{
throw new Exception("Invalid sitedown id");
}
if (original.CreatorId != userId)
{
throw new Exception("NOT AUTHORIZED");
}
editedSD.SiteNum = editedSD.SiteNum == null ? original.SiteNum : editedSD.SiteNum;
editedSD.SiteName = editedSD.SiteName == null ? original.SiteName : editedSD.SiteName;
editedSD.Cause = editedSD.Cause == null ? original.Cause : editedSD.Cause;
editedSD.Solved = editedSD.Solved;
editedSD.Creator = editedSD.Creator == null ? original.Creator : editedSD.Creator;
editedSD.CreatorId = editedSD.CreatorId == null ? original.CreatorId : editedSD.CreatorId;
return(_repo.EditSD(editedSD));
}
internal SiteDown PostSD(SiteDown newSD)
{
newSD.Id = _repo.PostSD(newSD);
return(newSD);
}
