using Common.Config;
using Common.Helper;
using Dapper;
using PK.Bisnis.Interface;
using PK.DataAccess.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;

namespace PK.Bisnis.Repository
{
    public class AppBankDataRepository : IAppBankData
    {
        private readonly IDbConnection _db = Connection.PKConnection();
        private readonly ResponseMessage _message;

        public AppBankDataRepository()
        {
            _message = new ResponseMessage();
        }

        public Dictionary<string, object> getByDebCode(string DebCode)
        {
            try
            {
                var data =
                    _db.Query<AppBankData>(@"SELECT [IdAppBank]
                                                  ,[DebCode]
                                                  ,[Month]
                                                  ,[Year]
                                                  ,[BankName1]
                                                  ,[BankName2]
                                                  ,[CardNumber1]
                                                  ,[CardNumber2]
                                                  ,[BalanceLimit1]
                                                  ,[BalanceLimit2]
                                                  ,[ActiveSince]
                                                  ,[ActiveUntil]
                                                  ,[CreatedAt]
                                                  ,[CreatedBy]
                                                  ,[UpdatedAt]
                                                  ,[UpdatedBy]
                                              FROM [dbo].[AppBankData] WHERE DebCode = @DebCode",
                        new {DebCode = DebCode}).ToList();
                return _message.SuccessData(true, data, _message.MessageSuccess);
            }
            catch (Exception ex)
            {
                return _message.Failed(true, ex.Message);
            }
        }

        public Dictionary<string, object> getAll()
        {
            try
            {
                var data =
                    _db.Query<AppBankData>(@"SELECT [IdAppBank]
                                                  ,[DebCode]
                                                  ,[Month]
                                                  ,[Year]
                                                  ,[BankName1]
                                                  ,[BankName2]
                                                  ,[CardNumber1]
                                                  ,[CardNumber2]
                                                  ,[BalanceLimit1]
                                                  ,[BalanceLimit2]
                                                  ,[ActiveSince]
                                                  ,[ActiveUntil]
                                                  ,[CreatedAt]
                                                  ,[CreatedBy]
                                                  ,[UpdatedAt]
                                                  ,[UpdatedBy]
                                              FROM [dbo].[AppBankData]").ToList();
                return _message.SuccessData(true, data, _message.MessageSuccess);
            }
            catch (Exception ex)
            {
                return _message.Failed(true, ex.Message);
            }
        }

        public Dictionary<string, object> insert(AppBankData appBankData)
        {
            try
            {
                int rowsAffected = _db.Execute(@"INSERT INTO [dbo].[AppBankData]
                                                                   ([DebCode]
                                                                   ,[Month]
                                                                   ,[Year]
                                                                   ,[BankName1]
                                                                   ,[BankName2]
                                                                   ,[CardNumber1]
                                                                   ,[CardNumber2]
                                                                   ,[BalanceLimit1]
                                                                   ,[BalanceLimit2]
                                                                   ,[CreatedAt]
                                                                   ,[CreatedBy] )
                                                             VALUES
                                                                   (@DebCode
                                                                   ,@Month
                                                                   ,@Year
                                                                   ,@BankName1
                                                                   ,@BankName2
                                                                   ,@CardNumber1
                                                                   ,@CardNumber2
                                                                   ,@BalanceLimit1
                                                                   ,@BalanceLimit2
                                                                   ,@CreatedAt
                                                                   ,@CreatedBy )",
                    new
                    {
                        DebCode = appBankData.DebCode,
                        Month = appBankData.Month,
                        Year = appBankData.Year,
                        BankName1 = appBankData.BankName1,
                        BankName2 = appBankData.BankName2,
                        CardNumber1 = appBankData.CardNumber1,
                        CardNumber2 = appBankData.CardNumber2,
                        BalanceLimit1 = appBankData.BalanceLimit1,
                        BalanceLimit2 = appBankData.BalanceLimit2,
                        CreatedAt = DateTime.Now,
                        CreatedBy = appBankData.CreatedBy
                    });

                if (rowsAffected > 0)
                {
                    return _message.Success(true, _message.MessageSuccess);
                }

                return _message.Failed(false, _message.MessageFailed);
            }
            catch (Exception ex)
            {
                return _message.Failed(false, ex.Message);
            }
        }

        public async Task insertImport(AppBankData appBankData)
        {
            try
            {
                int rowsAffected = _db.Execute(@"INSERT INTO [dbo].[AppBankData]
                                                                   ([DebCode]
                                                                   ,[Month]
                                                                   ,[Year]
                                                                   ,[BankName1]
                                                                   ,[BankName2]
                                                                   ,[CardNumber1]
                                                                   ,[CardNumber2]
                                                                   ,[BalanceLimit1]
                                                                   ,[BalanceLimit2]
                                                                   ,[CreatedAt]
                                                                   ,[CreatedBy] )
                                                             VALUES
                                                                   (@DebCode
                                                                   ,@Month
                                                                   ,@Year
                                                                   ,@BankName1
                                                                   ,@BankName2
                                                                   ,@CardNumber1
                                                                   ,@CardNumber2
                                                                   ,@BalanceLimit1
                                                                   ,@BalanceLimit2
                                                                   ,@CreatedAt
                                                                   ,@CreatedBy )",
                    new
                    {
                        DebCode = appBankData.DebCode,
                        Month = appBankData.Month,
                        Year = appBankData.Year,
                        BankName1 = appBankData.BankName1,
                        BankName2 = appBankData.BankName2,
                        CardNumber1 = appBankData.CardNumber1,
                        CardNumber2 = appBankData.CardNumber2,
                        BalanceLimit1 = appBankData.BalanceLimit1,
                        BalanceLimit2 = appBankData.BalanceLimit2,
                        CreatedAt = DateTime.Now,
                        CreatedBy = appBankData.CreatedBy
                    });
            }
            catch (Exception)
            {
            }
        }

        public Dictionary<string, object> update(int idAppBank, AppBankData appBankData)
        {
            try
            {
                appBankData.IdAppBank = idAppBank;
                var rowsAffected = _db.Execute(@"UPDATE [dbo].[AppBankData]
                                               SET [DebCode] = @DebCode
                                                  ,[Month] = @Month
                                                  ,[Year] = @Year
                                                  ,[BankName1] = @BankName1
                                                  ,[BankName2] = @BankName2
                                                  ,[CardNumber1] = @CardNumber1
                                                  ,[CardNumber2] = @CardNumber2
                                                  ,[BalanceLimit1] = @BalanceLimit1
                                                  ,[BalanceLimit2] = @BalanceLimit2
                                                  ,[UpdatedAt] = @UpdatedAt
                                                  ,[UpdatedBy] = @UpdatedBy
                              WHERE IdAppBank = @IdAppBank", appBankData);


                if (rowsAffected > 0)
                {
                    return _message.Success(true, _message.MessageSuccess);
                }


                return _message.Failed(false, _message.MessageFailed);
            }
            catch (Exception ex)
            {
                return _message.Failed(false, ex.Message);
            }
        }

        public Dictionary<string, object> updateDebCode(string debCode, AppBankData appBankData)
        {
            try
            {
                appBankData.DebCode = debCode;
                var rowsAffected = _db.Execute(@"UPDATE [dbo].[AppBankData]
                                               SET [DebCode] = @DebCode
                                                  ,[Month] = @Month
                                                  ,[Year] = @Year
                                                  ,[BankName1] = @BankName1
                                                  ,[BankName2] = @BankName2
                                                  ,[CardNumber1] = @CardNumber1
                                                  ,[CardNumber2] = @CardNumber2
                                                  ,[BalanceLimit1] = @BalanceLimit1
                                                  ,[BalanceLimit2] = @BalanceLimit2
                                                  ,[UpdatedAt] = @UpdatedAt
                                                  ,[UpdatedBy] = @UpdatedBy
                              WHERE DebCode = @DebCode ", appBankData);


                if (rowsAffected > 0)
                {
                    return _message.Success(true, _message.MessageSuccess);
                }


                return _message.Failed(false, _message.MessageFailed);
            }
            catch (Exception ex)
            {
                return _message.Failed(false, ex.Message);
            }
        }
    }
}