Esempio n. 1
0
        public void Monitoreo(EventLog poLog)
        {
            try
            {
                Sesion   poSesion          = (Sesion)EstablecerSesion(poLog);
                string[] lsClaveSucursales = ConfigurationManager.AppSettings["ClaveSucursales"].Split(new Char[] { ';' });
                string   lsCorreoAsunto    = ConfigurationManager.AppSettings["CorreoAsunto"];
                string   lsCorreoAlerta    = ConfigurationManager.AppSettings["CorreoAlerta"];

                for (int lnSucursal = 0; lnSucursal <= lsClaveSucursales.Length - 1; lnSucursal++)
                {
                    string          lsCorreoDestinatario = ConfigurationManager.AppSettings["CorreoDestinatario" + lsClaveSucursales[lnSucursal]];
                    HelperMOSGestor loMonitoreoSaldos    = new HelperMOSGestor();
                    DataTable       loClientes           = loMonitoreoSaldos.BuscarSaldosClientes(poSesion, int.Parse(lsClaveSucursales[lnSucursal]));
                    bool            loInactivarClientes  = loMonitoreoSaldos.InactivarClientes(poSesion, loClientes, poLog);

                    if (loInactivarClientes)
                    {
                        DataSet loClientesSaldoVencido = new DataSet();
                        loClientesSaldoVencido.Merge(loClientes.Select("(SALDO_PADRE > 0 OR SALDO_HIJO > 0)"));

                        if (loClientesSaldoVencido.Tables.Count > 0)
                        {
                            AgruparClientePersonal(loClientes, lsCorreoAsunto, poLog);
                            ObtenerMensaje(loClientes, lsCorreoDestinatario, lsCorreoAsunto, poLog);
                            ObtenerMensaje(loClientes,
                                           NotificarPersonal(poSesion, loClientes, lsCorreoDestinatario, int.Parse(lsClaveSucursales[lnSucursal])),
                                           lsCorreoAsunto, poLog);
                        }
                        else
                        {
                            loClientes.Clear();
                            ObtenerMensaje(loClientes,
                                           NotificarPersonal(poSesion, loClientes, lsCorreoDestinatario, int.Parse(lsClaveSucursales[lnSucursal])),
                                           lsCorreoAsunto, poLog);
                        }
                    }
                    else
                    {
                        EnviarEmail("Ocurrio un problema al inactivar clientes con saldo vencido.", lsCorreoAsunto, lsCorreoAlerta, poLog);
                    }
                }
            }
            catch (Exception ex)
            {
                poLog.WriteEntry("ERROR METODO MONITOREO SALDOS." + ex, EventLogEntryType.Information);
            }
            GC.Collect();
        }
Esempio n. 2
0
        private string NotificarPersonal(Sesion poSesion, DataTable loClientes, string lsCorreoDestinatario, int lnSucursal)
        {
            string          lsCorreoDestinatarioTemp = string.Empty;
            HelperMOSGestor loGestor    = new HelperMOSGestor();
            DataTable       loResultado = loGestor.ObtenerEmailPersonal(poSesion, lnSucursal);

            if (loClientes.Rows.Count > 0)
            {
                string[] lsDestinatarios = lsCorreoDestinatario.Split(new Char[] { ';' });
                lsCorreoDestinatario = "E_MAIL NOT IN( ";

                foreach (string poDestinatarios in lsDestinatarios)
                {
                    lsCorreoDestinatario = lsCorreoDestinatario + "'" + poDestinatarios + "' ,";
                }
                foreach (DataRow lsEmailPersonal in loClientes.Rows)
                {
                    lsCorreoDestinatario = lsCorreoDestinatario + "'" + lsEmailPersonal["EMAIL_PERSONAL"].ToString() + "' ,";
                }

                lsCorreoDestinatario = lsCorreoDestinatario.TrimEnd(',');

                foreach (DataRow lsCliente in loResultado.Select(lsCorreoDestinatario + ")"))
                {
                    lsCorreoDestinatarioTemp = lsCorreoDestinatarioTemp + lsCliente["E_MAIL"].ToString() + ";";
                }
            }
            else
            {
                foreach (DataRow lsCliente in loResultado.Rows)
                {
                    lsCorreoDestinatario = lsCorreoDestinatario + ";" + lsCliente["E_MAIL"];
                }
                lsCorreoDestinatarioTemp = lsCorreoDestinatario;
            }

            loClientes.Clear();
            return(lsCorreoDestinatarioTemp.TrimEnd(';'));
        }