public async Task <bool> SendClientBilling(Client client, ClientBilling clientBilling)
        {
            string subject        = String.Format("{0} - {1}", _boxSettings.APPLICATION_NAME, "Faturamento");
            string dataVencimento = clientBilling.PaymentDueDate?.ToString("dd/MM/yyyy");

            // create the template
            dynamic data = _templateService.CreateBasicModel();

            data.subject        = subject;
            data.paymentDueDate = dataVencimento;
            var body = await _templateService.RenderTemplate("ClientBilling", data, lang : "pt");

            try
            {
                await _emailSender.SendEmailAsync(
                    client.Email,
                    subject,
                    body);

                _log.Log($"E-mail enviado para o cliente {client.Email} com faturamento que vence em {dataVencimento}.", saveParameters: false);
                return(true);
            }
            catch (Exception ex)
            {
                _log.Log($"Erro no envio do faturamento do cliente {client.Name} com vencimento em {dataVencimento}.", ex.Message, saveParameters: false);
                return(false);
            }
        }
Exemplo n.º 2
0
        public ClientBilling CreateBilling(Client client)
        {
            var clientBilling = new ClientBilling()
            {
                ClientBillingUId = Guid.NewGuid().ToString(),
                ClientUId        = client.ClientUId,
                Create           = DateTime.Now,
                PaymentDueDate   = Convert.ToDateTime($"{client.DueDay}-{DateTime.Now.Month}-{DateTime.Now.Year}"),
                PaymentDate      = null,
                Sended           = false
            };

            // criar o faturamento na gerencia-net
            GerenciaNetViewModels.ChargeResponse chargeResponse = CreateBillet(client, clientBilling);

            // verificar se sucesso, pode gravar o billing
            if (chargeResponse.code.Equals(200))
            {
                clientBilling.ExternalId = chargeResponse.data.charge_id;
                clientBilling.BarCode    = chargeResponse.data.barcode;
                clientBilling.LinkPdf    = chargeResponse.data.pdf.charge;
                clientBilling.Status     = chargeResponse.data.status;
                clientBilling.Sended     = true;
                _context.ClientsBillings.Add(clientBilling);
                _context.SaveChanges();
                _log.Log($"Faturamento do cliente {client.Name} com vencimento em {clientBilling.PaymentDueDate.Value.ToShortDateString()} foi criando.");

                return(clientBilling);
            }

            return(null);
        }
Exemplo n.º 3
0
        public void addClientBilling()
        {
            ClientBilling _clientBilling = new ClientBilling
            {
                ClientBillingRateTypeID = 1,
                ClientID                  = 27,
                ClientIsPrivateLabel      = false,
                ClientInvoiceNumber       = "JSYTG643T764",
                ClientAttentionToID       = 1,
                ClientAttentionToFreeText = null
            };
            var _id = _clientRepository.addClientBilling(_clientBilling);

            Assert.IsTrue(_id > 0, "failed");
        }
Exemplo n.º 4
0
        public void updateClientBilling()
        {
            ClientBilling _clientBilling = new ClientBilling
            {
                ClientBillingRateTypeID = 1,
                ClientID                  = 43,
                ClientIsPrivateLabel      = true,
                ClientBillingID           = 17,
                ClientInvoiceNumber       = "KYU45UN4ER54",
                ClientAttentionToID       = 3,
                ClientAttentionToFreeText = "ji jvdjd db dfb jdb jdbjhf jhbj jdbvj dfvjd jd jfhdv jdffjdv fjdvb jdfvbfjdvb jfbhv jhdbv jhfbv jdfbv hbfvd fjbvf vdjfk vbdjfvb dkfjvbjdf vfjdbv jbvjd fvbj dfhb"
            };
            var _id = _clientRepository.updateClientBilling(_clientBilling);

            Assert.IsTrue(_id > 0, "failed");
        }
        private static StringBuilder GenerateHtmlBilling(ClientBilling clientBilling)
        {
            string _htmlTemplateHeader = @"
                                <!DOCTYPE html>
                                <html>
                                    <head>
                                        <style>
                                            body {
                                              font-family: Arial, Helvetica, sans-serif; 
                                              font-size: 12px;
                                            }
                                            table {
                                                border-collapse: collapse;
                                                width: 100%;
                                            }
                                            th, td {
                                                text-align: center;
                                                padding: 4px;
                                            }
                                            tr:nth-child(even){
                                                background-color: #f2f2f2
                                            }
                                        </style>
                                    </head>
                                    <body>
                                        Wykaz rozmów abonenta <B>[CLIENT]</B> <BR>
                                        dla numeracji <B>[CLIDS]</B><BR>
                                        za okres od <B>[START_DATE]</B> do <B>[END_DATE]</B><BR>
                                        Koszt: netto <B>[PRICE_NETTO]</B> zł, vat <B>[PRICE_VAT]</B> zł, brutto <B>[PRICE_GROSS]</B> zł<BR>
                                        <P></P>
                                        <table>
                                          <tr>
                                            <th>Lp.</th>
                                            <th>Data i godzina</th>
                                            <th>Numer docelowy</th>
                                            <th>Czas trwania (min:s)</th>
                                            <th>Wartość netto (PLN)</th>
                                          </tr>";

            string _htmlTemplateBody = @" <tr>
                                            <td>[NO]</td>
                                            <td>[START_DATE]</td>
                                            <td>[DESTINATION]</td>
                                            <td>[DURATION]</td>
                                            <td>[PRICE_NETTO]</td>
                                          </tr>";

            string _htmlTemplateFooter = @"</table>
                                        </body>
                                    </html>";

            StringBuilder _htmlClientBilling  = new StringBuilder(_htmlTemplateHeader);
            StringBuilder _htmlBillingRecords = new StringBuilder();
            double        _priceNettoSum      = 0;

            foreach (var(index, billingRecord) in clientBilling.BillingRecords.Enumerate())
            {
                StringBuilder _htmlBillingRecord = new StringBuilder(_htmlTemplateBody);
                _htmlBillingRecord.Replace("[NO]", (index + 1).ToString());
                _htmlBillingRecord.Replace("[START_DATE]", billingRecord.StartDate.ToString());
                _htmlBillingRecord.Replace("[DESTINATION]", billingRecord.Destination.ToString());
                _htmlBillingRecord.Replace("[DURATION]", billingRecord.Duration.ToMinutesAndSeconds().ToString());
                _htmlBillingRecord.Replace("[PRICE_NETTO]", Math.Round(billingRecord.Price, 2).ToString("0.00"));
                _htmlBillingRecords.Append(_htmlBillingRecord);

                _priceNettoSum = _priceNettoSum + billingRecord.Price;
            }

            string clids = "";

            foreach (string clid in Utils.RangifyLiteralValues(clientBilling.Client.LiteralShortClids()))
            {
                clids += clid;
                if (!clid.Equals(Utils.RangifyLiteralValues(clientBilling.Client.LiteralShortClids()).Last()))
                {
                    clids += ", ";
                }
            }

            _htmlClientBilling.Replace("[CLIENT]", clientBilling.Client.Name);
            _htmlClientBilling.Replace("[CLIDS]", clids);
            _htmlClientBilling.Replace("[START_DATE]", clientBilling.StartDate.ToString());
            _htmlClientBilling.Replace("[END_DATE]", clientBilling.EndDate.ToString());
            _htmlClientBilling.Replace("[PRICE_NETTO]", Math.Round(_priceNettoSum, 2).ToString("0.00"));
            _htmlClientBilling.Replace("[PRICE_VAT]", Math.Round(_priceNettoSum * 0.23, 2).ToString("0.00"));
            _htmlClientBilling.Replace("[PRICE_GROSS]", Math.Round(_priceNettoSum * 1.23, 2).ToString("0.00"));
            _htmlClientBilling.Append(_htmlBillingRecords);
            _htmlClientBilling.Append(_htmlTemplateFooter);

            return(_htmlClientBilling);
        }
        public dynamic CreateBillet(Client client, ClientBilling clientBilling)
        {
            _log.Log("Executando método CreateBillet para gerar boleto.");
            dynamic endpoints = new GerenciaNetEndpoints(_sgiSettings.GERENCIA_NET_CLIENT_ID, _sgiSettings.GERENCIA_NET_CLIENT_SECRET, true);
            var     _value    = $"{((int)client.Value).ToString()}00";

            dynamic response = null;

            if (client.DocumentType != (int)DocumentType.CPF)
            {
                var body = new
                {
                    items = new[]
                    {
                        new {
                            name   = client.Item,
                            value  = Convert.ToInt32(_value),
                            amount = 1
                        }
                    },
                    payment = new
                    {
                        banking_billet = new
                        {
                            customer = new
                            {
                                name             = client.Name,
                                email            = client.Email,
                                cpf              = client.Cpf,
                                birth            = FormatDate(client.Birth.Value),
                                phone_number     = client.Phone,
                                juridical_person = new
                                {
                                    corporate_name = client.Name,
                                    cnpj           = client.Document
                                }
                            },
                            expire_at = FormatDate(clientBilling.PaymentDueDate.Value)
                        }
                    },
                    metadata = new
                    {
                        custom_id        = clientBilling.ClientBillingUId,
                        notification_url = _sgiSettings.GERENCIA_NET_URL_CALL_BACK
                    }
                };

                response = endpoints.OneStep(null, body);
            }
            else
            {
                var body = new
                {
                    items = new[]
                    {
                        new {
                            name   = client.Item,
                            value  = Convert.ToInt32(_value),
                            amount = 1
                        }
                    },
                    payment = new
                    {
                        banking_billet = new
                        {
                            customer = new
                            {
                                name         = client.Name,
                                email        = client.Email,
                                cpf          = client.Cpf,
                                birth        = FormatDate(client.Birth.Value),
                                phone_number = client.Phone
                            },
                            expire_at = FormatDate(clientBilling.PaymentDueDate.Value),
                        }
                    },
                    metadata = new
                    {
                        custom_id        = clientBilling.ClientBillingUId,
                        notification_url = _sgiSettings.GERENCIA_NET_URL_CALL_BACK
                    }
                };

                response = endpoints.OneStep(null, body);
            }

            _log.Log("Finalizando método CreateBillet para gerar boleto.");
            return(JsonConvert.DeserializeObject <ChargeResponse>(response.ToString()));
        }
Exemplo n.º 7
0
        public ActionResult AddClientBilling(ClientBilling _ClientBilling, ClientBillingRetailRate _ClientBillingRetailRate, ClientBillingWholesaleRate _ClientBillingWholesaleRate)
        {
            try
            {
                int      _ClientBillingID = 0;
                string[] _Ids             = new string[4];
                if (_ClientBilling.ClientBillingID > 0)
                {
                    _Ids[0] = GlobalConst.Mode.Update;

                    if (_ClientBilling.ClientAttentionToID != 3)
                    {
                        _ClientBilling.ClientAttentionToFreeText = null;
                    }

                    _ClientBillingID = _iClientService.updateClientBilling(Mapper.Map <MMC.MMCService.ClientService.ClientBilling>(_ClientBilling));

                    _Ids[1] = _ClientBilling.ClientBillingID.ToString();;

                    _ClientBillingRetailRate.ClientBillingID = _ClientBilling.ClientBillingID;
                    _ClientBillingRetailRate.CreatedBy       = MMCUser.UserId;
                    _ClientBillingRetailRate.CreatedOn       = System.DateTime.Now;

                    _Ids[2] = _ClientBillingRetailRate.ClientBillingRetailRateID.ToString();

                    _iClientService.updateClientBillingRetailRate(Mapper.Map <MMC.MMCService.ClientService.ClientBillingRetailRate>(_ClientBillingRetailRate));



                    if (_ClientBilling.ClientIsPrivateLabel == true)
                    {
                        _ClientBillingWholesaleRate.ClientBillingID = _ClientBilling.ClientBillingID;
                        _ClientBillingWholesaleRate.CreatedBy       = MMCUser.UserId;
                        _ClientBillingWholesaleRate.CreatedOn       = System.DateTime.Now;
                        _Ids[3] = _ClientBillingWholesaleRate.ClientBillingWholesaleRateID.ToString();
                        _iClientService.updateClientBillingWholesaleRate(Mapper.Map <MMC.MMCService.ClientService.ClientBillingWholesaleRate>(_ClientBillingWholesaleRate));
                    }
                    else
                    {
                        if (_ClientBillingWholesaleRate.ClientBillingWholesaleRateID > 0)
                        {
                            _iClientService.deleteClientBillingWholesaleRate(_ClientBillingWholesaleRate.ClientBillingWholesaleRateID);
                        }
                        // delete the Client Private Label
                        _iClientService.deleteClientPrivateLabelByClientID(_ClientBilling.ClientID);
                    }
                }
                else
                {
                    _Ids[0] = GlobalConst.Mode.Add;

                    if (_ClientBilling.ClientAttentionToID != 3)
                    {
                        _ClientBilling.ClientAttentionToFreeText = null;
                    }

                    _ClientBilling.ClientBillingID = _iClientService.addClientBilling(Mapper.Map <MMC.MMCService.ClientService.ClientBilling>(_ClientBilling));


                    _Ids[1] = _ClientBilling.ClientBillingID.ToString();

                    _ClientBillingRetailRate.ClientBillingID = _ClientBilling.ClientBillingID;
                    _ClientBillingRetailRate.CreatedBy       = MMCUser.UserId;
                    _ClientBillingRetailRate.CreatedOn       = System.DateTime.Now;

                    _ClientBillingRetailRate.ClientBillingRetailRateID = _iClientService.addClientBillingRetailRate(Mapper.Map <MMC.MMCService.ClientService.ClientBillingRetailRate>(_ClientBillingRetailRate));

                    _Ids[2] = _ClientBillingRetailRate.ClientBillingRetailRateID.ToString();
                    if (_ClientBilling.ClientIsPrivateLabel == true)
                    {
                        _ClientBillingWholesaleRate.ClientBillingID = _ClientBilling.ClientBillingID;
                        _ClientBillingWholesaleRate.CreatedBy       = MMCUser.UserId;
                        _ClientBillingWholesaleRate.CreatedOn       = System.DateTime.Now;

                        _ClientBillingWholesaleRate.ClientBillingWholesaleRateID = _iClientService.addClientBillingWholesaleRate(Mapper.Map <MMC.MMCService.ClientService.ClientBillingWholesaleRate>(_ClientBillingWholesaleRate));
                        _Ids[3] = _ClientBillingWholesaleRate.ClientBillingWholesaleRateID.ToString();
                    }
                }
                return(Json(_Ids, GlobalConst.ContentTypes.TextHtml));
            }
            catch
            {
                return(Json(0));
            }
        }
Exemplo n.º 8
0
 public int updateClientBilling(ClientBilling _ClientBilling)
 {
     return(_clientRepository.updateClientBilling(Mapper.Map <DTO.ClientBilling, MMC.Core.Data.Model.ClientBilling>(_ClientBilling)));
 }
Exemplo n.º 9
0
 public int updateClientBilling(ClientBilling _clientBilling)
 {
     return(_clientBillingRepo.Update(_clientBilling));
 }
Exemplo n.º 10
0
 public int addClientBilling(ClientBilling _clientBilling)
 {
     return(_clientBillingRepo.Add(_clientBilling).ClientBillingID);
 }