Exemple #1
0
        public static ResultStoreProcedure GetLog()
        {
            var fileName     = $"{AppDomain.CurrentDomain.BaseDirectory}\\App_Data\\log.txt";
            var methodBase   = MethodBase.GetCurrentMethod();
            var resultGetLog = new ResultStoreProcedure
            {
                ClassName = methodBase.DeclaringType?.ToString(),
                Method    = methodBase.Name,
                Status    = Status.Ok,
                Date      = DateTime.Now
            };

            try
            {
                File.Copy(fileName, @"c:\Temp\log.txt", true);

                return(resultGetLog);
            }
            catch (Exception e)
            {
                resultGetLog.Description = e.Message;

                return(resultGetLog);
            }
            finally
            {
                Util.WriteLog(resultGetLog);
            }
        }
Exemple #2
0
        public static void WriteLog(ResultStoreProcedure resultStoreProcedure)
        {
            var fileName = $"{AppDomain.CurrentDomain.BaseDirectory}\\App_Data\\log.txt";

            using (var sw = new System.IO.StreamWriter(fileName, true))
            {
                sw.WriteLine(resultStoreProcedure.ToString());
            }
        }
Exemple #3
0
        public static List <ResultStoreProcedure> InsertCampana(string connectionString, DataInsertTCampana dataInsertTCampana)
        {
            var listResultStoreProcedure = new List <ResultStoreProcedure>();
            var resultStoreProcedure     = new ResultStoreProcedure(MethodBase.GetCurrentMethod(), dataInsertTCampana.ToUri());

            listResultStoreProcedure.Add(resultStoreProcedure);

            try
            {
                using (var sqlConnection = new SqlConnection(connectionString))
                {
                    sqlConnection.Open();
                    using (var sqlCommand = new SqlCommand())
                    {
                        sqlCommand.Connection  = sqlConnection;
                        sqlCommand.CommandType = CommandType.StoredProcedure;
                        sqlCommand.CommandText = "pa_Insert_T_Campañas";

                        sqlCommand.Parameters.Add(new SqlParameter("@nsDescripcion", dataInsertTCampana.Descripcion));
                        sqlCommand.Parameters.Add(new SqlParameter("@dtDesde", dataInsertTCampana.Desde));
                        sqlCommand.Parameters.Add(new SqlParameter("@dtHasta", dataInsertTCampana.Hasta));

                        var returnParam = new SqlParameter
                        {
                            ParameterName = "@return",
                            Direction     = ParameterDirection.ReturnValue
                        };
                        sqlCommand.Parameters.Add(returnParam);

                        sqlCommand.ExecuteNonQuery();
                        resultStoreProcedure.Code = Convert.ToInt64(returnParam.Value);

                        resultStoreProcedure.Status      = resultStoreProcedure.Code > 0 ? Status.Ok : Status.Error;
                        resultStoreProcedure.Description = GetDescriptionError(resultStoreProcedure.Code);
                        Util.WriteLog(resultStoreProcedure);

                        return(listResultStoreProcedure);
                    }
                }
            }
            catch (Exception e)
            {
                resultStoreProcedure.Status      = Status.Exception;
                resultStoreProcedure.Description = e.Message;

                return(listResultStoreProcedure);
            }
        }
Exemple #4
0
        public static ResultStoreProcedure InsertFichaRamasClasificacion(string connectionString, DataFichaRamasClasificacion dataFichaRamasClasificacion)
        {
            var resultStoreProcedure = new ResultStoreProcedure(MethodBase.GetCurrentMethod(), dataFichaRamasClasificacion.ToUri());

            try
            {
                using (var sqlConnection = new SqlConnection(connectionString))
                {
                    sqlConnection.Open();
                    using (var sqlCommand = new SqlCommand())
                    {
                        sqlCommand.Connection  = sqlConnection;
                        sqlCommand.CommandType = CommandType.StoredProcedure;
                        sqlCommand.CommandText = "pa_InsertE2_RAMASCLASIF_FICHAS";

                        sqlCommand.Parameters.Add(new SqlParameter("@sIdInterno", dataFichaRamasClasificacion.IdInterno));
                        sqlCommand.Parameters.Add(new SqlParameter("@sIdClasificacion", dataFichaRamasClasificacion.IdClasificacion));
                        sqlCommand.Parameters.Add(new SqlParameter("@sUsuario", dataFichaRamasClasificacion.UsuarioCreacion));

                        var returnParam = new SqlParameter
                        {
                            ParameterName = "@return",
                            Direction     = ParameterDirection.ReturnValue
                        };
                        sqlCommand.Parameters.Add(returnParam);

                        sqlCommand.ExecuteNonQuery();
                        resultStoreProcedure.Code = Convert.ToInt64(returnParam.Value);

                        resultStoreProcedure.Status      = resultStoreProcedure.Code == 1 ? Status.Ok : Status.Error;
                        resultStoreProcedure.Description = GetDescriptionError(resultStoreProcedure.Code);

                        return(resultStoreProcedure);
                    }
                }
            }
            catch (Exception e)
            {
                resultStoreProcedure.Status      = Status.Exception;
                resultStoreProcedure.Description = e.Message;

                return(resultStoreProcedure);
            }
        }
Exemple #5
0
        public long?pa_Insert_T_Campanas(DataInsertTCampana dataInsertTCampana)
        {
            var resultStoreProcedure =
                new ResultStoreProcedure(MethodBase.GetCurrentMethod(), dataInsertTCampana.ToUri());

            try
            {
                var returnParam = new SqlParameter
                {
                    ParameterName = "@return",
                    Direction     = ParameterDirection.ReturnValue
                };

                Context.Database.SqlQuery <long>(
                    "exec dbo.[pa_Insert_T_Campañas] @nsDescripcion, @dtDesde, @dtHasta",
                    new SqlParameter("@nsDescripcion", dataInsertTCampana.Descripcion),
                    new SqlParameter("@dtDesde", dataInsertTCampana.Desde),
                    new SqlParameter("@dtHasta", dataInsertTCampana.Hasta),
                    returnParam);

                resultStoreProcedure.Code = Convert.ToInt64(returnParam.Value);

                resultStoreProcedure.Status = resultStoreProcedure.Code == 1 ? Status.Ok : Status.Error;

                return(resultStoreProcedure.Code);
            }
            catch (Exception e)
            {
                resultStoreProcedure.Status      = Status.Exception;
                resultStoreProcedure.Description = e.Message;

                throw;
            }
            finally
            {
                var fileName = $"{AppDomain.CurrentDomain.BaseDirectory}\\App_Data\\log.txt";
                using (var sw = new System.IO.StreamWriter(fileName, true))
                {
                    sw.WriteLine(resultStoreProcedure.ToString());
                }
            }
        }
Exemple #6
0
        public static List <ResultStoreProcedure> InsertFichaBase(string connectionString, DataFichasBase dataFichasBase)
        {
            var listResultStoreProcedure = new List <ResultStoreProcedure>();
            var resultStoreProcedure     = new ResultStoreProcedure(MethodBase.GetCurrentMethod(), dataFichasBase.ToUri());

            listResultStoreProcedure.Add(resultStoreProcedure);

            try
            {
                using (var sqlConnection = new SqlConnection(connectionString))
                {
                    sqlConnection.Open();
                    using (var sqlCommand = new SqlCommand())
                    {
                        sqlCommand.Connection  = sqlConnection;
                        sqlCommand.CommandType = CommandType.StoredProcedure;
                        sqlCommand.CommandText = "pa_InsertFichasBase";

                        sqlCommand.Parameters.Add(new SqlParameter("@sIdInterno", dataFichasBase.IdInterno));
                        sqlCommand.Parameters.Add(new SqlParameter("@nsTitulo", dataFichasBase.Titulo));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdLineaNegocio", dataFichasBase.IdLineaNegocio));
                        sqlCommand.Parameters.Add(new SqlParameter("@nCoeditorial", dataFichasBase.Coeditorial ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdioma", dataFichasBase.Idioma));
                        sqlCommand.Parameters.Add(new SqlParameter("@sCodLinea_P", dataFichasBase.CodLinea_P));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdTipoMaterialSAP", dataFichasBase.IdTipoMaterialSAP));
                        sqlCommand.Parameters.Add(new SqlParameter("@sCodigoGrupo", dataFichasBase.CodigoGrupo));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdProyecto", dataFichasBase.IdProyecto ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdProyectoAdicional", dataFichasBase.IdProyectoAdicional ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdProyectoGestion", dataFichasBase.IdProyectoGestion ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdCampaña", dataFichasBase.IdCampana));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdUsoComercial", dataFichasBase.IdUsoComercial ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@dtFechaComerializacion", dataFichasBase.FechaComerializacion));
                        sqlCommand.Parameters.Add(new SqlParameter("@dtNecesidadInfo", dataFichasBase.NecesidadInfo ?? string.Empty));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdColeccion", dataFichasBase.IdColeccion ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nNumColeccion", dataFichasBase.NumColeccion));
                        sqlCommand.Parameters.Add(new SqlParameter("@nIdSerie", dataFichasBase.IdSerie ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nNumSerie", dataFichasBase.NumSerie));
                        sqlCommand.Parameters.Add(new SqlParameter("@nZGeografica", dataFichasBase.ZGeografica ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nsUsuarioCreacion", dataFichasBase.UsuarioCreacion));
                        sqlCommand.Parameters.Add(new SqlParameter("@sIdInternoOrigen", dataFichasBase.IdInternoOrigen ?? string.Empty));
                        sqlCommand.Parameters.Add(new SqlParameter("@sIdInternoOrigenSAP", dataFichasBase.IdInternoOrigenSAP ?? string.Empty));
                        sqlCommand.Parameters.Add(new SqlParameter("@iIdPais", dataFichasBase.IdPais));
                        sqlCommand.Parameters.Add(new SqlParameter("@nPorcentajeCoedicion", dataFichasBase.PorcentajeCoedicion ?? (object)DBNull.Value));
                        sqlCommand.Parameters.Add(new SqlParameter("@nTipoMaterialEducativo", dataFichasBase.TipoMaterialEducativo ?? (object)DBNull.Value));

                        var returnParam = new SqlParameter
                        {
                            ParameterName = "@return",
                            Direction     = ParameterDirection.ReturnValue
                        };
                        sqlCommand.Parameters.Add(returnParam);

                        sqlCommand.ExecuteNonQuery();
                        resultStoreProcedure.Code = Convert.ToInt64(returnParam.Value);

                        resultStoreProcedure.Status      = resultStoreProcedure.Code == 1 ? Status.Ok : Status.Error;
                        resultStoreProcedure.Description = GetDescriptionError(resultStoreProcedure.Code);
                        Util.WriteLog(resultStoreProcedure);

                        if (resultStoreProcedure.Status == Status.Ok)
                        {
                            resultStoreProcedure = InsertFichaRamasClasificacion(connectionString,
                                                                                 new DataFichaRamasClasificacion
                            {
                                IdInterno       = dataFichasBase.IdInterno,
                                IdClasificacion = dataFichasBase.JerarquiaProducto,
                                UsuarioCreacion = dataFichasBase.UsuarioCreacion
                            });

                            listResultStoreProcedure.Add(resultStoreProcedure);
                            Util.WriteLog(resultStoreProcedure);
                        }

                        return(listResultStoreProcedure);
                    }
                }
            }
            catch (Exception e)
            {
                resultStoreProcedure.Status      = Status.Exception;
                resultStoreProcedure.Description = e.Message;

                return(listResultStoreProcedure);
            }
        }
Exemple #7
0
        public long pa_InsertFichasBase(DataFichasBase dataFichasBase)
        {
            var resultStoreProcedure = new ResultStoreProcedure(MethodBase.GetCurrentMethod(), dataFichasBase.ToUri());

            try
            {
                var result = Context.Database.SqlQuery <long>("exec dbo.[pa_InsertFichasBase] " +
                                                              "@sIdInterno, " +
                                                              "@nsTitulo, " +
                                                              "@nIdLineaNegocio, " +
                                                              "@nCoeditorial, " +
                                                              "@nIdioma, " +
                                                              "@sCodLinea_P, " +
                                                              "@nIdTipoMaterialSAP, " +
                                                              "@sCodigoGrupo, " +
                                                              "@nIdProyecto, " +
                                                              "@nIdProyectoAdicional, " +
                                                              "@nIdProyectoGestion, " +
                                                              "@nIdCampaña, " +
                                                              "@nIdUsoComercial, " +
                                                              "@dtFechaComerializacion, " +
                                                              "@dtNecesidadInfo, " +
                                                              "@nIdColeccion, " +
                                                              "@nNumColeccion, " +
                                                              "@nIdSerie, " +
                                                              "@nNumSerie, " +
                                                              "@nZGeografica, " +
                                                              "@nsUsuarioCreacion, " +
                                                              "@sIdInternoOrigen, " +
                                                              "@sIdInternoOrigenSAP, " +
                                                              "@iIdPais, " +
                                                              "@nPorcentajeCoedicion, " +
                                                              "@nTipoMaterialEducativo",
                                                              new SqlParameter("@sIdInterno", dataFichasBase.IdInterno),
                                                              new SqlParameter("@nsTitulo", dataFichasBase.Titulo),
                                                              new SqlParameter("@nIdLineaNegocio", dataFichasBase.IdLineaNegocio),
                                                              new SqlParameter("@nCoeditorial", dataFichasBase.Coeditorial ?? (object)DBNull.Value),
                                                              new SqlParameter("@nIdioma", dataFichasBase.Idioma),
                                                              new SqlParameter("@sCodLinea_P", dataFichasBase.CodLinea_P),
                                                              new SqlParameter("@nIdTipoMaterialSAP", dataFichasBase.IdTipoMaterialSAP),
                                                              new SqlParameter("@sCodigoGrupo", dataFichasBase.CodigoGrupo),
                                                              new SqlParameter("@nIdProyecto", dataFichasBase.IdProyecto ?? (object)DBNull.Value),
                                                              new SqlParameter("@nIdProyectoAdicional", dataFichasBase.IdProyectoAdicional ?? (object)DBNull.Value),
                                                              new SqlParameter("@nIdProyectoGestion", dataFichasBase.IdProyectoGestion ?? (object)DBNull.Value),
                                                              new SqlParameter("@nIdCampaña", dataFichasBase.IdCampana),
                                                              new SqlParameter("@nIdUsoComercial", dataFichasBase.IdUsoComercial ?? (object)DBNull.Value),
                                                              new SqlParameter("@dtFechaComerializacion", dataFichasBase.FechaComerializacion),
                                                              new SqlParameter("@dtNecesidadInfo", dataFichasBase.NecesidadInfo ?? string.Empty),
                                                              new SqlParameter("@nIdColeccion", dataFichasBase.IdColeccion ?? (object)DBNull.Value),
                                                              new SqlParameter("@nNumColeccion", dataFichasBase.NumColeccion),
                                                              new SqlParameter("@nIdSerie", dataFichasBase.IdSerie ?? (object)DBNull.Value),
                                                              new SqlParameter("@nNumSerie", dataFichasBase.NumSerie),
                                                              new SqlParameter("@nZGeografica", dataFichasBase.ZGeografica ?? (object)DBNull.Value),
                                                              new SqlParameter("@nsUsuarioCreacion", dataFichasBase.UsuarioCreacion),
                                                              new SqlParameter("@sIdInternoOrigen", dataFichasBase.IdInternoOrigen ?? string.Empty),
                                                              new SqlParameter("@sIdInternoOrigenSAP", dataFichasBase.IdInternoOrigenSAP ?? string.Empty),
                                                              new SqlParameter("@iIdPais", dataFichasBase.IdPais),
                                                              new SqlParameter("@nPorcentajeCoedicion", dataFichasBase.PorcentajeCoedicion ?? (object)DBNull.Value),
                                                              new SqlParameter("@nTipoMaterialEducativo", dataFichasBase.TipoMaterialEducativo ?? (object)DBNull.Value));

                var code = result.Single();
                resultStoreProcedure.Code = code;

                resultStoreProcedure.Status = code == 1 ? Status.Ok : Status.Error;

                return(code);
            }
            catch (Exception e)
            {
                resultStoreProcedure.Status      = Status.Exception;
                resultStoreProcedure.Description = e.Message;

                throw;
            }
            finally
            {
                var fileName = $"{AppDomain.CurrentDomain.BaseDirectory}\\App_Data\\log.txt";
                using (var sw = new System.IO.StreamWriter(fileName, true))
                {
                    sw.WriteLine(resultStoreProcedure.ToString());
                }
            }
        }