public vWallDetail GetWallDetailById( int id )
{
using( MinyDataContext ctx = new MinyDataContext() )
{
return ctx.vWallDetails.Where( x => x.WallId == id ).FirstOrDefault();
};
}
public IEnumerable<vItem> GetWallItemsById( int id )
{
using( MinyDataContext ctx = new MinyDataContext() )
{
return ctx.vItems.Where( x => x.WallId == id ).ToList();
};
}
public vItem GetItemById( int id )
{
using(MinyDataContext ctx = new MinyDataContext())
{
return ctx.vItems.Where( x => x.ItemId == id ).FirstOrDefault();
}
}
public bool DeleteItem( int itemToDelete )
{
using(MinyDataContext ctx = new MinyDataContext())
{
try
{
ctx.sDeleteItem( itemToDelete );
return true;
}
catch
{
return false;
}
}
}
public int CreateItem( CreateItemViewModel model )
{
using(MinyDataContext ctx = new MinyDataContext())
{
try
{
System.Nullable<int> CreatedItemId = ctx.sCreateItem( model.WallId, model.AuthorId, model.Note, model.Url, model.PicturePath, model.VideoPath, model.NbCol ).First();
if(CreatedItemId.HasValue) { return CreatedItemId.Value; }
return 0;
}
catch
{
return 0;
}
}
}