using FrameworkDAL.DTO.AddOnField;
using FrameworkDAL.Query.AddOnField;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;
using Newtonsoft.Json;

namespace FrameworkDAL.CustomCode.AddOnField
{
    public class AddOnFieldDAL : IAddOnFieldDAL
    {
        private readonly IQueryExecutor _queryExecutor;

        public AddOnFieldDAL(IQueryExecutor queryExecutor)
        {
            _queryExecutor = queryExecutor;
        }

        public async Task<IEnumerable<AddOnFieldDTO>> GetAddOnField(int addOnFieldId, LoginDTO loginDTO)
        {
            string json = "";
            try
            {
                string sql = AddOnFieldQB.GET_ADDONFIELD;
                var parameters = new { addonfieldid = addOnFieldId };
                IEnumerable<AddOnFieldDTO> result = await _queryExecutor.QueryAsync<AddOnFieldDTO>(loginDTO, sql, parameters);
                json = JsonConvert.SerializeObject(result);
                return result;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                json = null;
            }
        }

        public async Task<IEnumerable<AddOnFieldDTO>> GetAddOnFieldByEntityId(int entityId, LoginDTO loginDTO)
        {
            string json = "";
            try
            {
                string sql = AddOnFieldQB.GET_ADDONFIELD_BY_ENTITYID;
                var parameters = new { entityid = entityId };
                IEnumerable<AddOnFieldDTO> result = await _queryExecutor.QueryAsync<AddOnFieldDTO>(loginDTO, sql, parameters);
                json = JsonConvert.SerializeObject(result);
                return result;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                json = null;
            }
        }
    }
}