using System;
using System.Collections.Generic;
using System.Net;
using System.Net.Mail;
using System.Text;
using Model;
using classes;
using AwsDotnetCsharp.Model;
using MySqlConnector;
using System.Data;

namespace PMF.Services
{
    public class Mailer: Pmfbase
    {
        public void SendEmail(ContactUsModel contactUs, List<string> admins = default)
        {
            var message = GetEmailTemplate(contactUs);

            SendMessage(contactUs.Caterogy, Constants.TMT_MAIL, message, admins);
        }

        public void SendEmail(List<InfringementPayment> problemInfridgments, List<string> admins)
        {
            //use the problemInfridgments and send emails to the admins
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("The Cronjob could not complete the following payments: ");

            foreach (var problemInfridgment in problemInfridgments)
            {
                sb.AppendLine("infringementID: " + problemInfridgment.InfringementID.ToString() + " NoticeNumber: " + problemInfridgment.NoticeNumber);
            }

            SendMessage("PMF Error Payments", "sshabala@tmt.africa", sb.ToString(), admins);
        }

        private void SendMessage(string subject, string toEmail, string messageBody, List<string> admins = default)
        {
            try
            {
                var secretsmanager = new SecretsManagerService();
                var smtpUser = secretsmanager.GetSesUser();
                SmtpClient client = new SmtpClient()
                {
                    Host = Constants.TMT_MAIL_HOST,
                    Port = 587,
                    EnableSsl = true,
                    DeliveryMethod = SmtpDeliveryMethod.Network,
                    UseDefaultCredentials = false,
                    Credentials = new NetworkCredential()
                    {
                        UserName = smtpUser.SMTP_Username,
                        Password = smtpUser.SMTP_Password
                    }
                };

                MailAddress from = new MailAddress(Constants.TMT_MAIL, "PMF");
                MailAddress to = new MailAddress(toEmail); //pmf admin email remove this if there is no primary email
                MailMessage message = new MailMessage
                {
                    IsBodyHtml = true,
                    From = from
                };
                message.To.Add(to);

                if (admins != null)
                {
                    foreach (var adminEmail in admins)
                    {
                        message.CC.Add(new MailAddress(adminEmail));
                    }
                }

                message.Subject = subject;
                message.Body = messageBody;
                client.Send(message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        private string ReplaceEmailPlaceHolders(string emailType, ContactUsModel contactUs)
        {
            string emailBody = "";
            MySqlDataReader _reader = null;
            try
            {
                if (_con.State == ConnectionState.Closed) _con.Open();
                string statement = $"SELECT * FROM setting WHERE strKey = '{emailType}'";
                var cmd = new MySqlCommand(statement, _con);
                _reader = cmd.ExecuteReader();

                if (_reader.HasRows)
                {
                    while (_reader.Read())
                    {
                        string rawValue = _reader["strValue"].ToString();

                        emailBody = Uri.UnescapeDataString(rawValue);
                    }
                    emailBody = emailBody.Replace("{name}", contactUs.Name);
                    emailBody = emailBody.Replace("{surname}", contactUs.Surname);
                    emailBody = emailBody.Replace("{email}", contactUs.Email);
                    emailBody = emailBody.Replace("{number}", contactUs.IdNumber);
                    emailBody = emailBody.Replace("{message}", contactUs.Message);

                    if (!string.IsNullOrWhiteSpace(contactUs.TicketNumber))
                    {
                        emailBody = emailBody.Replace("{ticketNumber}", contactUs.TicketNumber);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (_reader != null) _reader.Close();
                if (_con != null || _con.State == ConnectionState.Open) _con.Close();
            }
            return emailBody;
        }

        private string GetEmailTemplate(ContactUsModel contactUs)
        {
            string open = "{";
            string close = "}";

            var sb = new StringBuilder();
            sb.Append(@$"
                        <html>
                            <head>
                                <style>
                                    @import url('https://fonts.googleapis.com/css2?family=Poppins:wght@400;600;700;900&display=swap');

                                        .header {open}
                                            float:left;
                                            padding-top: 5%;
                                            padding-left: 5%;
                                            width: 45%;
                                            overflow:hidden;
                                        {close}

                                        .header-right {open}
                                            padding-top: 5%;
                                            padding-right: 5%;
                                            
                                        {close}

                                        table {open}
                                            width: 90%;
                                            border-collapse: collapse;
                                            margin-top: -3%;
                                        {close}

                                        td, th {open}
                                            padding: 5px;
                                            font-size: 11px;
                                            text-align: center;
                                            color: #5f6f7c;
                                            font-family: 'Poppins', sans-serif;
                                            font-family:  Calibri;
                                            
                                        {close}

                                        table th {open}
                                            background-color: #6c757d;
                                            color: white;
                                            font-weight: 400;
                                            font-size: 11px;
                                            font-family:  Calibri;
                                            padding: 5px;
                                        {close}

                                        table, td, th {open}
                                            border: 1px solid #6c757d;
                                        {close}

                                        tr:nth-child(even) {open} background-color: #c4cacf;{close}
                                         tr:nth-child(odd) {open} background-color: #f2f2f2;{close}

                                        .total-column {open}
                                            text-align: right;
                                            color: white;
                                             font-weight: 600;
                                              background-color: #6c757d;
                                        {close}

                                        .total-label {open}
                                            text-align: left;
                                            color: white;
                                            font-weight: 600;
                                            background-color: #6c757d;
                                        {close}

                                        .line {open}
                                            width: 90%;
                                            margin-bottom: 5%;
                                        {close}

                                        .header-text {open}
                                            color: #b1aeae;
                                            font-family:  'Poppins', sans-serif;
                                            text-align: center;
                                        {close}

                                        h1 {open}
                                            font-size: 30px;
                                            font-family: 'Poppins', sans-serif;
                                        {close}

                                        .right {open}
                                            width: 35%;
                                            float: left;
                                            font-size: 11px;
                                            margin-top: -2%;
                                            color: grey;
                                        {close}

                                        .left {open}
                                            width: 55%;
                                            float: left;
                                            margin-left: 5%;
                                            margin-top: -2%;
                                            font-size: 11px;
                                            color: grey;
                                        {close}

                                        .black {open}
                                            color: black;
                                        {close}

                                        body {open}
                                            font-family: 'Poppins', sans-serif;
                                        {close}

                                        .footer {open}
                                                position: fixed;
                                                bottom: 0;
                                                width: 100%;
                                                text-align: center;
                                                margin: auto;
                                                font-weight: 600;
                                                font-size: 10px;
                                                color: #6c757d;
                                        {close}

                                        .foo {open}
                                            font-weight: 600;
                                        {close}
                                </style>
                            </head>
                            <body>
                                <div class='main'>
                                   <div class = 'right'>
                                        <p><b class ='black'> Name: </b>  {contactUs.Name}</p>
                                        <p><b class ='black'> Surname: </b>  {contactUs.Surname}</p>
                                        <p><b class ='black'>ID Number: </b>  {contactUs.IdNumber}</p>
                                        <p><b class ='black'> Email: </b>  {contactUs.Email}</p>            
                                        <p><b class ='black'> Ticket number: </b>  {contactUs.TicketNumber}</p>
                                        <hr class='line'>
                                        <p><b class ='black'> {contactUs.Message} </b> </p>
                                   </div>
                                </div>
                                <div class='footer'>
                                    <hr style = 'width: 90%'>
                                         <p> <span style= 'float: center; margin-bottom: 1%'> Paymyfines, PO BOX 234, Century City, Cape Town, 7446, South Africa </span> </p>
                                </div>
                            </body>
                        </html>");

            return sb.ToString();
        }
    }
}