public ActionResult Delete(int?communityid, int?id, Item item)
{
if (CustomUser.Person.Id != item.OwnerId && !CustomUser.IsInRole((int)communityid, "Reviewer"))
{
return(RedirectToAction("Index", "Home"));
}
//Check if it is borrowed
ViewBorrowed borrow = new ViewBorrowed();
borrow = DatabaseHelper.RetrieveSingle <ViewBorrowed>(@"
select Item.Id, Item.ItemName, Item.OwnerId, Item.Usage, Item.Warning, Item.Age, Item.CommunityId,
case when DateBorrowed is not null and DateReturned is null then cast(1 as bit)
else cast(0 as bit) end as Borrowed
from Item left join BorrowItem on Item.Id = BorrowItem.ItemId
where DateReturned is null and CommunityId = @CommunityId and ItemId = @ItemId
", new SqlParameter("@CommunityId", (int)communityid),
new SqlParameter("@ItemId", (int)id));
if (borrow.DateReturned == null)
{
return(RedirectToAction("Index", "Home"));
}
DatabaseHelper.Execute(@"
Delete from Item
where Id = @Id
", new SqlParameter("@Id", id));
return(RedirectToAction("Details", new { communityid = communityid, id = id }));
}
public ActionResult Return(int?communityId, int?id)
{
ViewBorrowed borrowedItem = new ViewBorrowed();
borrowedItem = DatabaseHelper.RetrieveSingle <ViewBorrowed>(@"
Select ItemId, BorrowerId, DateBorrowed, DateDue, DateReturned, CommunityName, ItemName, CommunityId
From BorrowItem join Item on BorrowItem.ItemId = Item.Id
join Community on Item.CommunityId = Community.Id
Where BorrowItem.Id = @Id
", new SqlParameter("@Id", id));
return(View(borrowedItem));
}
public ActionResult Return(int?communityId, int?id, ViewBorrowed borrowed)
{
if (communityId == null || id == null)
{
return(RedirectToAction("BorrowedItems"));
}
if (CustomUser.Person.Id != id)
{
return(RedirectToAction("Index", "Home"));
}
DatabaseHelper.Update(@"
Update BorrowItem
set DateReturned = @DateReturned
Where Id = @Id
", new SqlParameter("@Id", id),
new SqlParameter("@DateReturned", DateTimeOffset.Now));
return(RedirectToAction("BorrowedItems"));
}
