public EmailResponseDto <EmailChannelTable> AddEmailChannel(EmailChannelTable channelInput)
        {
            var response = new EmailResponseDto <EmailChannelTable>();

            try
            {
                var channel = _context.EmailChannels.FirstOrDefault(sp => sp.Key.Equals(channelInput.Key) && sp.EmailPoolID.Equals(channelInput.EmailPoolID));
                if (channel != null)
                {
                    response.Status  = false;
                    response.Message = "This Channel already exists.";
                    response.Result  = channelInput;
                }
                else
                {
                    channelInput.ID = Guid.NewGuid().ToString();
                    _context.EmailChannels.Add(channelInput);
                    if (_context.SaveChanges() == 1)
                    {
                        response.Status  = true;
                        response.Message = "Added";
                        response.Result  = channelInput;
                    }
                    else
                    {
                        response.Status  = false;
                        response.Message = "Not Added";
                        response.Result  = channelInput;
                    }
                }

                return(response);
            }
            catch (Exception ex)
            {
                response.Status  = false;
                response.Message = ex.Message;
                return(response);
            }
        }
        public EmailResponseDto <EmailChannelTable> UpdateEmailChannel(EmailChannelTable channelInput)
        {
            var response = new EmailResponseDto <EmailChannelTable>();

            try
            {
                var channel = _context.EmailChannels.FirstOrDefault(sp => sp.Key.Equals(channelInput.Key) && sp.EmailPoolID.Equals(channelInput.EmailPoolID));
                if (channel != null)
                {
                    channel.EmailProviderID = channelInput.EmailProviderID;
                    if (_context.SaveChanges() == 1)
                    {
                        response.Status  = true;
                        response.Message = "Updated";
                        response.Result  = channelInput;
                    }
                    else
                    {
                        response.Status  = false;
                        response.Message = "Failed To Update";
                        response.Result  = channelInput;
                    }
                }
                else
                {
                    response.Status  = false;
                    response.Message = $"Cannot find Channel with Key {channelInput.Key}";
                    response.Result  = channelInput;
                }

                return(response);
            }
            catch (Exception ex)
            {
                response.Status  = false;
                response.Message = ex.Message;
                return(response);
            }
        }