using System.Linq;
using WX.CRM.DAL.Res;
using WX.CRM.IBLL.Res;
using WX.CRM.Model.Entity;

namespace WX.CRM.BLL.Res
{
    public class RES_SENIORSHAREDPOOL_BL : DbContextRepository<RES_SENIORSHAREDPOOL>, IRES_SENIORSHAREDPOOL
    {
        private readonly RES_SENIORSHAREDPOOL_DAL _dal = new RES_SENIORSHAREDPOOL_DAL();

        public int GetCount()
        {
            using (var db = new crmContext())
            {
                var count = db.RES_SENIORSHAREDPOOL.Count();

                return count;
            }
        }

        public string FindSeniorSharedPoolRes(decimal userId, decimal eid)
        {
            var ds = _dal.FindSeniorSharedPoolRes(userId, eid);
            var dt = ds.Tables[0];
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0][0].ToString();
            }
            return string.Empty;
        }
    }
}