public Int16 CartaoParaImpressaoFamiliar()
        {
            Int16 CartaoLote = 100;

            try
            {
                PessoaDAO   DAO   = new PessoaDAO();
                LogNegocios Log_N = new LogNegocios();

                //Definir novo lote
                CartaoLote = DAO.RecuperarCartaoLote();
                CartaoLote++;

                //Recupera Cartões gerados;
                List <PessoaController> Cartoes = DAO.CartoesParaImpressao(CartaoLote, 1);

                /*Enviar Email*/
                if (Cartoes.Count > 0)
                {
                    string str_from_address = ParametrosNegocios.EmailSaidaLogin;//sender
                    string str_name         = ParametrosNegocios.NomeConta;
                    //The To address (Email ID)
                    string str_to_address = "*****@*****.**";//recipient
                    //string str_to_address = "*****@*****.**";//recipient

                    System.Net.Mail.MailMessage email_msg = new MailMessage();

                    //Specifying From,Sender & Reply to address
                    email_msg.From   = new MailAddress(str_from_address, str_name);
                    email_msg.Sender = new MailAddress(str_from_address, str_name);
                    //email_msg.ReplyTo = new MailAddress(str_from_address, str_name);

                    //The To Email id
                    email_msg.To.Add(str_to_address);

                    email_msg.Subject = "Cartões para impressão (Plano Familiar)";//Subject of email
                    StringBuilder HTML = new StringBuilder();

                    HTML.Append("<!DOCTYPE html>");


                    HTML.Append("<html xmlns='http://www.w3.org/1999/xhtml'>");
                    HTML.Append("<head runat='server'>");
                    HTML.Append("<meta http-equiv='Content -Type' content='text/html; charset=utf-8'/>");
                    HTML.Append("<title>Cartões para Impressão Plano Familiar</title>");
                    HTML.Append("<style>");
                    HTML.Append("body");
                    HTML.Append("{");
                    HTML.Append("margin: 0px");
                    HTML.Append("}");
                    HTML.Append(".container");
                    HTML.Append("{");
                    HTML.Append("width: 100 %;");
                    HTML.Append("height: 100 %;");
                    HTML.Append("background: #EDEDED;");
                    HTML.Append("display:flex;");
                    HTML.Append("flex-direction:row;");
                    HTML.Append("justify-content:center;");
                    HTML.Append("align-items:center");
                    HTML.Append("}");
                    HTML.Append(".box {");
                    HTML.Append("width:760px;");
                    HTML.Append("height:300px;");
                    HTML.Append("background:#FFFFFF;");
                    HTML.Append("}");
                    HTML.Append(".auto-style1 {");
                    HTML.Append("text-align:left;");
                    HTML.Append("}");
                    HTML.Append("</style>");
                    HTML.Append("</head>");
                    HTML.Append("<body>");
                    HTML.Append("<div class='container'>");
                    HTML.Append("<div class='box'>");
                    HTML.Append("<div style='background-color:#0071C5; font-size: 26px; font-weight: bold; color: #FFFFFF;'>");
                    HTML.Append("Clube Conteza");
                    HTML.Append("</div>");
                    HTML.Append("<br/>");
                    HTML.Append("<div style='background-color:#F3F3F3; text-align: center;' >");
                    HTML.Append("Cartões para Impressão</div>");
                    HTML.Append("<br/>");
                    HTML.Append("<div> ");
                    HTML.Append("Segue lista para impressão de cartões do Plano Familiar</div>");
                    HTML.Append("<br/>");
                    HTML.Append("<div>");
                    HTML.Append("<table style='padding: 2px; margin: inherit; border: medium solid #000000; width:100%; table-layout: auto; border-spacing: inherit; border-collapse: collapse;'>");
                    HTML.Append("<tr>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Contrato</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>ID Pessoa</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Cartão</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Lote</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Nome Completo</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Celular</td>");
                    HTML.Append("<td style='border-style: solid; background-color: #4472C4;'>Ponto de Venda</td>");
                    HTML.Append("</tr>");
                    int Linha = 0;

                    foreach (PessoaController Cartao in Cartoes)
                    {
                        HTML.Append("<tr>");
                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }
                        HTML.Append(Cartao.TB012_Id);
                        HTML.Append("</td>");

                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }
                        HTML.Append(Cartao.TB013_id);
                        HTML.Append("</td>");

                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }
                        HTML.Append(Cartao.TB013_Cartao);
                        HTML.Append("</td>");

                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }

                        /**/
                        HTML.Append(Cartao.TB013_CartaoLote);
                        HTML.Append("</td>");

                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }

                        /**/
                        HTML.Append(Cartao.TB013_NomeCompleto);
                        //HTML.Append("</td>");
                        //HTML.Append("</tr>");
                        /**/
                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }
                        HTML.Append(Cartao.Contato.TB009_Contato);
                        HTML.Append("</td>");
                        /*Ponto de Venda*/
                        if (Linha == 0)
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#D9E2F3'>");
                        }
                        else
                        {
                            HTML.Append("<td style='border-style: solid; background-color:#FFFFFF'>");
                        }
                        HTML.Append(Cartao.PontoDeVenda.TB002_Ponto.TrimEnd());
                        HTML.Append("</td>");

                        /*Fim ponto de venda*/

                        HTML.Append("</tr>");

                        /*Rotina para o Log*/
                        LogController Log_C = new LogController();

                        Log_C.TB012_Id        = Cartao.TB012_Id;
                        Log_C.TB011_Id        = 0;
                        Log_C.TB000_IdTabela  = 13;
                        Log_C.TB000_Tabela    = "Cartao";
                        Log_C.TB000_Data      = DateTime.Now;
                        Log_C.TB000_Descricao = string.Format(MensagensLog.L0021.ToString(), Cartao.TB013_Cartao);
                        Log_N.LogInsert(Log_C);
                        /**/
                    }


                    HTML.Append("</table>");
                    HTML.Append("</div>");
                    HTML.Append("<div>");
                    HTML.Append("</div>");
                    HTML.Append("</div>");
                    HTML.Append("</div>");
                    HTML.Append("</body>");
                    HTML.Append("</html>");

                    email_msg.IsBodyHtml = true;
                    email_msg.Body       = HTML.ToString(); //body
                                                            //Create an object for SmtpClient class
                    SmtpClient mail_client = new SmtpClient();

                    //Providing Credentials (Username & password)
                    NetworkCredential network_cdr = new NetworkCredential();
                    network_cdr.UserName = str_from_address;
                    network_cdr.Password = ParametrosNegocios.EmailSaidaSenha;

                    mail_client.Credentials = network_cdr;

                    //Specify the SMTP Port
                    mail_client.Port = ParametrosNegocios.EmailSaidaPorta;

                    //Specify the name/IP address of Host
                    mail_client.Host = ParametrosNegocios.EmailSaidaSMTP;

                    //Uses Secure Sockets Layer(SSL) to encrypt the connection
                    mail_client.EnableSsl = true;

                    //Now Send the message
                    mail_client.Send(email_msg);
                    /*Apos Enviar Email Atualizar Status do Cartão*/
                    DAO.CartoesUpdateStatus(CartaoLote, 2);
                }
                /*Fim Email*/

                if (Cartoes.Count == 0)
                {
                    CartaoLote = 0;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }


            return(CartaoLote);
        }