OHV/Dev/OHV/OHV.SqliteDAL/DAL/AxisPositionDataDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OHV.Common.Model;

namespace OHV.SqliteDAL.DAL
{
    public class AxisPositionDataDAL : GenericDAL<AxisPositionData>
    {
        public List<AxisPositionData> GetKFromName(string axisName)
        {
            List<AxisPositionData> dataList = new List<AxisPositionData>();

            using (var db = new OHVDbContext("OHVDb"))
            {
                dataList = db.Set<AxisPositionData>().Where(x => x.AxisName.Equals(axisName)).ToList();
            }

            return dataList;
        }

        public List<AxisPositionData> GetKFromPostion(string position)
        {
            List<AxisPositionData> dataList = new List<AxisPositionData>();

            using (var db = new OHVDbContext("OHVDb"))
            {
                dataList = db.Set<AxisPositionData>().Where(x => x.Name.Equals(position)).ToList();
            }

            return dataList;
        }

        public AxisPositionData GetK(string axisName, string position)
        {
            var list = this.GetKFromName(axisName);

            return list.Where(x => x.Name.Equals(position)).SingleOrDefault();

        }
    }
}