コード例 #1
0
 private void GenerarEventos(int Opcion)
 {
     try
     {
         EfideFactoringBE.RobotCobranzasBE oEntity = new EfideFactoringBE.RobotCobranzasBE();
         oEntity.OPCION = Opcion;
         new RobotCobranzasBL().ProcesarRobotCobranzas(oEntity);
     }
     catch (Exception ex)
     {
         //MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
コード例 #2
0
        private void GenerarPlanilla(int Dias, int Opcion)
        {
            try
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("IdPagadora");
                dt.Columns.Add("IdSocio");
                dt.Columns.Add("IdLote");
                dt.Columns.Add("cItem");
                dt.Columns.Add("Pagadora");
                dt.Columns.Add("Socio");

                RobotCobranzasBE oEntity = new EfideFactoringBE.RobotCobranzasBE();
                oEntity.OPCION = Opcion;
                oEntity.Dias   = Dias;
                DataSet ds = new RobotCobranzasBL().ProcesarRobotCobranzas(oEntity);

                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    DataRow dr = dt.NewRow();
                    dr["IdPagadora"] = row["IdPagadora"].ToString();
                    dr["IdSocio"]    = row["IdSocio"].ToString();
                    dr["IdLote"]     = row["IdLote"].ToString();
                    dr["cItem"]      = row["cItem"].ToString();
                    dr["Pagadora"]   = row["IdPagadora_Dsc"].ToString();
                    dr["Socio"]      = row["Socio"].ToString();
                    dt.Rows.Add(dr);
                }

                DataView View = new DataView(dt);
                System.Data.DataTable dtDistinctPagadoras = View.ToTable(true, "IdPagadora", "Pagadora");

                System.Data.DataTable dtDistinctSocio = View.ToTable(true, "IdSocio", "Socio");

                string StrDocumento = string.Empty;
                System.Data.DataTable dtDocumentos = new System.Data.DataTable();

                int Count = 0;
                foreach (DataRow dr in dtDistinctPagadoras.Rows)
                {
                    DataRow[] drDocumentos = dt.Select("IdPagadora = '" + dr["IdPagadora"].ToString() + "'");

                    foreach (DataRow item in drDocumentos)
                    {
                        StrDocumento = StrDocumento + item[2].ToString().Trim() + "_" + item[3].ToString().Trim() + "&";
                    }

                    DataSet dsDatos = new DataSet();
                    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                    {
                        SqlCommand cmd1 = new SqlCommand("dbo.Rpt_AvisoVencTituloValor", con);
                        cmd1.CommandType = CommandType.StoredProcedure;
                        cmd1.Parameters.AddWithValue("@Opcion", 1);
                        cmd1.Parameters.AddWithValue("@IdPagadora", dr["IdPagadora"].ToString());
                        cmd1.Parameters.AddWithValue("@StrDocumento", StrDocumento);
                        SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                        daCab.Fill(dsDatos, "dtVencTituloValor");
                        con.Close();
                    }

                    EfideFactoring.Formula.Crystal.crRptVencTituloValor oRpt = new EfideFactoring.Formula.Crystal.crRptVencTituloValor();
                    oRpt.SetDataSource(dsDatos);
                    oRpt.SetParameterValue("Pagadora", dr["Pagadora"].ToString());

                    string NombreDocumento = dr["IdPagadora"].ToString().Trim() + DateTime.Now.ToString("yyyyMMddmmss");
                    oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ConfigurationManager.AppSettings["RutaAvisoVenc"].ToString() + NombreDocumento + ".pdf");
                    oRpt.Dispose();
                    StrDocumento = string.Empty;

                    /************************************
                     * Enviar correo y generar bitacora
                     ***********************************/
                    if (Dias == -15)
                    {
                        oEntity                 = new EfideFactoringBE.RobotCobranzasBE();
                        oEntity.OPCION          = 1;
                        oEntity.IdPagadora      = dr["IdPagadora"].ToString();
                        oEntity.NombreDocumento = NombreDocumento;
                        new RobotCobranzasBL().ProcesarRobotCobranzas_Correo(oEntity);
                    }
                    else if (Dias == -7)
                    {
                        oEntity                 = new EfideFactoringBE.RobotCobranzasBE();
                        oEntity.OPCION          = 2;
                        oEntity.IdPagadora      = dr["IdPagadora"].ToString();
                        oEntity.NombreDocumento = NombreDocumento;
                        new RobotCobranzasBL().ProcesarRobotCobranzas_Correo(oEntity);
                    }
                    else if (Dias == 0)
                    {
                        oEntity                 = new EfideFactoringBE.RobotCobranzasBE();
                        oEntity.OPCION          = 3;
                        oEntity.IdPagadora      = dr["IdPagadora"].ToString();
                        oEntity.NombreDocumento = NombreDocumento;
                        new RobotCobranzasBL().ProcesarRobotCobranzas_Correo(oEntity);
                    }

                    Count++;

                    if (Count == TotalCola)
                    {
                        Task.Delay(300000).Wait();
                        Count = 0;
                    }
                }


                /********************************
                * Enviar correos por Socios
                ********************************/

                //if (Dias == 0)
                //{
                //    foreach (DataRow dr in dtDistinctSocio.Rows)
                //    {
                //        DataRow[] drDocumentos = dt.Select("IdSocio = '" + dr["IdSocio"].ToString() + "'");

                //        foreach (DataRow item in drDocumentos)
                //        {
                //            StrDocumento = StrDocumento + item[2].ToString().Trim() + "_" + item[3].ToString().Trim() + "&";
                //        }

                //        DataSet dsDatos = new DataSet();
                //        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                //        {
                //            SqlCommand cmd1 = new SqlCommand("dbo.Rpt_AvisoVencTituloValor", con);
                //            cmd1.CommandType = CommandType.StoredProcedure;
                //            cmd1.Parameters.AddWithValue("@Opcion", 1);
                //            cmd1.Parameters.AddWithValue("@IdSocio", dr["IdSocio"].ToString());
                //            cmd1.Parameters.AddWithValue("@StrDocumento", StrDocumento);
                //            SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                //            daCab.Fill(dsDatos, "dtVencTituloValor");
                //            con.Close();
                //        }

                //        EfideFactoring.Formula.Crystal.crRptVencTituloValor oRpt = new EfideFactoring.Formula.Crystal.crRptVencTituloValor();
                //        oRpt.SetDataSource(dsDatos);
                //        oRpt.SetParameterValue("Pagadora", dr["Socio"].ToString());

                //        string NombreDocumento = dr["IdSocio"].ToString().Trim() + DateTime.Now.ToString("yyyMMddmmss");
                //        oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ConfigurationManager.AppSettings["RutaAvisoVenc"].ToString() + "\\tmp\\" + NombreDocumento + ".pdf");
                //        StrDocumento = string.Empty;

                //        /**********************************
                //          Generar bitacora y Enviar correo
                //        ***********************************/
                //        oEntity = new EfideFactoringBE.RobotCobranzasBE();
                //        oEntity.OPCION = 5;
                //        oEntity.Usuario = "RobotCobranza";
                //        oEntity.IdSocio = dr["IdSocio"].ToString();
                //        oEntity.NombreDocumento = NombreDocumento;
                //        new RobotCobranzasBL().ProcesarRobotCobranzas_Correo(oEntity);
                //    }
                //}
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
コード例 #3
0
        private void GenerarCartasNotariales(int Opcion, int _Dias)
        {
            try
            {
                DataTable dt = new DataTable();
                dt.Columns.Add("IdPagadora");
                dt.Columns.Add("IdSocio");
                dt.Columns.Add("IdLote");
                dt.Columns.Add("cItem");
                dt.Columns.Add("Pagadora");
                dt.Columns.Add("Socio");

                RobotCobranzasBE oEntity = new EfideFactoringBE.RobotCobranzasBE();
                oEntity.OPCION = Opcion;
                oEntity.Dias   = _Dias;
                DataSet ds = new RobotCobranzasBL().ProcesarRobotCobranzas(oEntity);

                foreach (DataRow row in ds.Tables[0].Rows)
                {
                    DataRow dr = dt.NewRow();
                    dr["IdPagadora"] = row["IdPagadora"].ToString();
                    dr["IdSocio"]    = row["IdSocio"].ToString();
                    dr["IdLote"]     = row["IdLote"].ToString();
                    dr["cItem"]      = row["cItem"].ToString();
                    dr["Pagadora"]   = row["IdPagadora_Dsc"].ToString();
                    dr["Socio"]      = row["Socio"].ToString();
                    dt.Rows.Add(dr);
                }

                DataView View = new DataView(dt);
                System.Data.DataTable dtDistinctPagadoras = View.ToTable(true, "IdPagadora", "Pagadora");

                //System.Data.DataTable dtDistinctSocio = View.ToTable(true, "IdSocio", "Socio");

                /********************************
                * GENERAR CARTA NOTARIAL PAGADORA
                ********************************/
                foreach (DataRow dr in dtDistinctPagadoras.Rows)
                {
                    DataSet dsDatos = new DataSet();
                    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                    {
                        SqlCommand cmd1 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                        cmd1.CommandType = CommandType.StoredProcedure;
                        cmd1.Parameters.AddWithValue("@Opcion", 2);
                        cmd1.Parameters.AddWithValue("@IdEntidad", dr["IdPagadora"].ToString());
                        SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                        daCab.Fill(dsDatos, "dtCabecera");
                        con.Close();

                        SqlCommand cmd2 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                        cmd2.CommandType = CommandType.StoredProcedure;
                        cmd2.Parameters.AddWithValue("@Opcion", 4);
                        cmd2.Parameters.AddWithValue("@IdEntidad", dr["IdPagadora"].ToString());
                        cmd2.Parameters.AddWithValue("@Dias", _Dias);
                        SqlDataAdapter daCab1 = new SqlDataAdapter(cmd2);
                        daCab1.Fill(dsDatos, "dtDetalle");
                        con.Close();
                    }

                    EfideFactoring.Formula.Crystal.crRpt_CartaNotarialPagadora oRpt = new EfideFactoring.Formula.Crystal.crRpt_CartaNotarialPagadora();
                    oRpt.SetDataSource(dsDatos);

                    string NombreDocumento = "Pagadoras_" + dr["IdPagadora"].ToString().Trim() + DateTime.Now.ToString("yyyyMMddmmss") + ".pdf";
                    oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, ConfigurationManager.AppSettings["RutaCartaNotariales"].ToString() + NombreDocumento);

                    // Generar movimiento de gestion notarial
                    using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                    {
                        DataSet    dsGN = new DataSet();
                        SqlCommand cmd1 = new SqlCommand("dbo.GestionCartaNotarial_Mnt", con);
                        cmd1.CommandType = CommandType.StoredProcedure;
                        cmd1.Parameters.AddWithValue("@Opcion", 2);
                        cmd1.Parameters.AddWithValue("@IdCartaNotarial", string.Empty);
                        cmd1.Parameters.AddWithValue("@IdEntidad", dr["IdPagadora"].ToString());
                        cmd1.Parameters.AddWithValue("@IdEntidad_Dsc", dr["Pagadora"].ToString());
                        cmd1.Parameters.AddWithValue("@vAdjunto", NombreDocumento);
                        cmd1.Parameters.AddWithValue("@Usuario", "RobotCobranzas");
                        SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                        daCab.Fill(dsGN, "dtGN");
                        con.Close();
                    }

                    /********************************
                    * GENERAR CARTA NOTARIAL SOCIO
                    ********************************/
                    DataView ViewSocio = new DataView(dt);
                    ViewSocio.RowFilter = "IdPagadora = '" + dr["IdPagadora"].ToString() + "'";
                    System.Data.DataTable dtDistinctSocio = ViewSocio.ToTable(true, "IdSocio", "Socio");

                    foreach (DataRow drSocios in dtDistinctSocio.Rows)
                    {
                        dsDatos = new DataSet();
                        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                        {
                            SqlCommand cmd1 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                            cmd1.CommandType = CommandType.StoredProcedure;
                            cmd1.Parameters.AddWithValue("@Opcion", 1);
                            cmd1.Parameters.AddWithValue("@IdSocio", drSocios["IdSocio"].ToString());
                            SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                            daCab.Fill(dsDatos, "dtCabecera");
                            con.Close();

                            SqlCommand cmd2 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                            cmd2.CommandType = CommandType.StoredProcedure;
                            cmd2.Parameters.AddWithValue("@Opcion", 4);
                            cmd2.Parameters.AddWithValue("@IdEntidad", dr["IdPagadora"].ToString());
                            cmd2.Parameters.AddWithValue("@IdSocio", drSocios["IdSocio"].ToString());
                            cmd2.Parameters.AddWithValue("@Dias", _Dias);
                            SqlDataAdapter daCab1 = new SqlDataAdapter(cmd2);
                            daCab1.Fill(dsDatos, "dtDetalle");
                            con.Close();
                        }

                        EfideFactoring.Formula.Crystal.crRpt_CartaNotarialSocio oRptSocios = new EfideFactoring.Formula.Crystal.crRpt_CartaNotarialSocio();
                        oRptSocios.SetDataSource(dsDatos);

                        NombreDocumento = "Socio_" + drSocios["IdSocio"].ToString().Trim() + DateTime.Now.ToString("yyyMMddmmss") + ".pdf";
                        oRptSocios.ExportToDisk(ExportFormatType.PortableDocFormat, ConfigurationManager.AppSettings["RutaCartaNotariales"].ToString() + NombreDocumento);

                        // Generar movimiento de gestion notarial
                        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                        {
                            DataSet    dsGN = new DataSet();
                            SqlCommand cmd1 = new SqlCommand("dbo.GestionCartaNotarial_Mnt", con);
                            cmd1.CommandType = CommandType.StoredProcedure;
                            cmd1.Parameters.AddWithValue("@Opcion", 2);
                            cmd1.Parameters.AddWithValue("@IdCartaNotarial", string.Empty);
                            cmd1.Parameters.AddWithValue("@IdEntidad", drSocios["IdSocio"].ToString());
                            cmd1.Parameters.AddWithValue("@IdEntidad_Dsc", drSocios["Socio"].ToString());
                            cmd1.Parameters.AddWithValue("@vAdjunto", NombreDocumento);
                            cmd1.Parameters.AddWithValue("@Usuario", "RobotCobranzas");
                            SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                            daCab.Fill(dsGN, "dtGN");
                            con.Close();
                        }

                        /********************************
                        * GENERAR CARTA NOTARIAL AVAL
                        ********************************/
                        /*dsDatos = new DataSet();
                         * using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConexionStrDBEfideFactoring"].ConnectionString))
                         * {
                         *  SqlCommand cmd1 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                         *  cmd1.CommandType = CommandType.StoredProcedure;
                         *  cmd1.Parameters.AddWithValue("@Opcion", 3);
                         *  cmd1.Parameters.AddWithValue("@IdSocio", drSocios["IdSocio"].ToString());
                         *  SqlDataAdapter daCab = new SqlDataAdapter(cmd1);
                         *  daCab.Fill(dsDatos, "dtCabecera");
                         *  con.Close();
                         *
                         *  if (dsDatos.Tables[0].Rows.Count > 0)
                         *  {
                         *
                         *      SqlCommand cmd2 = new SqlCommand("dbo.Rpt_CartaNotarialCobranza_Qry", con);
                         *      cmd2.CommandType = CommandType.StoredProcedure;
                         *      cmd2.Parameters.AddWithValue("@Opcion", 4);
                         *      cmd2.Parameters.AddWithValue("@IdEntidad", dr["IdPagadora"].ToString());
                         *      cmd2.Parameters.AddWithValue("@IdSocio", drSocios["IdSocio"].ToString());
                         *      cmd2.Parameters.AddWithValue("@Dias", _Dias);
                         *      SqlDataAdapter daCab1 = new SqlDataAdapter(cmd2);
                         *      daCab1.Fill(dsDatos, "dtDetalle");
                         *      con.Close();
                         *
                         *      EfideFactoring.Formula.Crystal.crRpt_CartaNotarialAval oRptAval = new EfideFactoring.Formula.Crystal.crRpt_CartaNotarialAval();
                         *      oRptAval.SetDataSource(dsDatos);
                         *
                         *      NombreDocumento = "Aval_" + drSocios["IdSocio"].ToString().Trim() + DateTime.Now.ToString("yyyMMddmmss") + ".pdf";
                         *      oRptAval.ExportToDisk(ExportFormatType.PortableDocFormat, ConfigurationManager.AppSettings["RutaCartaNotariales"].ToString() + NombreDocumento);
                         *
                         *      // Generar movimiento de gestion notarial
                         *      SqlCommand cmd3 = new SqlCommand("dbo.GestionCartaNotarial_Mnt", con);
                         *      cmd3.CommandType = CommandType.StoredProcedure;
                         *      cmd3.Parameters.AddWithValue("@Opcion", 2);
                         *      cmd3.Parameters.AddWithValue("@IdCartaNotarial", string.Empty);
                         *      cmd3.Parameters.AddWithValue("@IdEntidad", drSocios["IdSocio"].ToString());
                         *      cmd3.Parameters.AddWithValue("@IdEntidad_Dsc", drSocios["Socio"].ToString());
                         *      cmd3.Parameters.AddWithValue("@vAdjunto", NombreDocumento);
                         *      cmd3.Parameters.AddWithValue("@Usuario", "RobotCobranzas");
                         *      SqlDataAdapter daCab2 = new SqlDataAdapter(cmd2);
                         *      daCab2.Fill(dsDatos, "dtGN");
                         *      con.Close();
                         *  }
                         * }*/

                        /**********************************
                         *  Generar bitacora y Enviar correo
                         ***********************************/
                        //oEntity = new EfideFactoringBE.RobotCobranzasBE();
                        //oEntity.OPCION = 5;
                        //oEntity.Usuario = "RobotCobranza";
                        //oEntity.IdSocio = dr["IdSocio"].ToString();
                        //oEntity.NombreDocumento = NombreDocumento;
                        //new RobotCobranzasBL().ProcesarRobotCobranzas_Correo(oEntity);
                    }
                }
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }