using ErrorAnalysis.Repository.Entity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ErrorAnalysis.Repository
{
    public class COModelRepository : RepositoryBase
    {
        public COModelRepository(string connectionString) : base(connectionString) { }

        public List<COModelTable> GetCOModels()
        {
            using (var context = new RetMcnpDbContext(_connectionString))
            {
                return context.COModelTables.Where(c => c.CasingID != "casingID").OrderBy(c => c.BIT).OrderBy(c => c.CasingOD).ToList();
            }
        }

        public COModelTable? GetCOModel(string modelId)
        {
            using (var context = new RetMcnpDbContext(_connectionString))
            {
                return context.COModelTables.FirstOrDefault(c => c.ModelID == modelId);
            }
        }
    }
}