コード例 #1
0
        /// <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);
        }
コード例 #2
0
 /// <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);
     }
 }