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; } } }