DPM_PADM/WebAPI/Helper/Dal/AccountDAL.cs

using APP.Utils;
using BWPMModels;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Threading.Tasks;

namespace APP.Dal
{
    public class AccountDAL : IAccountDAL
    {
        private IDbHelper _db;
        public AccountDAL(IDbHelper db)
        {
            this._db = db;
        }

        public async Task<UserModel> GetById(int id)
        {
            try
            {
                string sp = "Employee_GetById";
                List<SqlParameter> parms = new List<SqlParameter>();
                parms.Add(new SqlParameter("Id", id));
                var data = await _db.ExecuteToTableAsync<UserModel>(sp, parms, DbHelperEnum.StoredProcedure);
                return data != null ? data.FirstOrDefault() : null;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

        public async Task<UserModel> GetByEmail(string email)
        {
            try
            {
                string sp = "Employee_GetByEmail";
                List<SqlParameter> parms = new List<SqlParameter>();
                parms.Add(new SqlParameter("Email", email));
                var data = await _db.ExecuteToTableAsync<UserModel>(sp, parms, DbHelperEnum.StoredProcedure);
                return data != null ? data.FirstOrDefault() : null;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }
    }
}