/// <summary> /// Method returns all Positions From Database /// </summary> /// <returns>Collection of Positions</returns> public async Task <ObservableCollection <DtoPosition> > GetAllPositions() { var ret = new ObservableCollection <DtoPosition>(); using (var data = Context) foreach (var item in await(from item in data.Position select item).ToListAsync()) { ret.Add(PositionConverter.DataAccsessToDto(item)); } return(ret); }
/// <summary> /// Returns Position with specific ID /// </summary> /// <param name="positionId">Position ID</param> /// <returns>Position Business Object</returns> public async Task <DtoPosition> GetPosition(int positionId) { try { using (var data = Context) return (PositionConverter.DataAccsessToDto( await (from item in data.Position where item.id == positionId select item) .FirstOrDefaultAsync())); } catch (Exception) { return(null); } }