Пример #1
0
        public GenericAnswer CreateEntidad(EntidadesModel entity)
        {
            GenericAnswer response = new GenericAnswer();

            SqlParameter[] parameters =
            {
                new SqlParameter {
                    Value = entity.nombre, ParameterName = "@nombre"
                },
                new SqlParameter {
                    Value = entity.direccion, ParameterName = "@direccion"
                },
                new SqlParameter {
                    Value = entity.telefono, ParameterName = "@telefono"
                },
                new SqlParameter {
                    Value = entity.ciudad, ParameterName = "@ciudad"
                },
                new SqlParameter {
                    Value = entity.pais, ParameterName = "@pais"
                },
                new SqlParameter {
                    Value = entity.correo, ParameterName = "@correo"
                },
                new SqlParameter {
                    SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output, ParameterName = "@OutIdEntidad"
                }
            };
            string messageError = string.Empty;

            connectionManager.AcctionRun(insertEntidad, ref messageError, parameters);
            if (Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString()) > 0)
            {
                entity.id = Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString());
            }
            if (!string.IsNullOrEmpty(messageError))
            {
                response.error      = messageError;
                response.successful = false;

                return(response);
            }
            response.error      = messageError;
            response.entity     = entity;
            response.successful = true;

            return(response);
        }
Пример #2
0
        public GenericAnswer CreateEmpleado(EmpleadosModel entity)
        {
            GenericAnswer response = new GenericAnswer();

            SqlParameter[] parameters =
            {
                new SqlParameter {
                    Value = entity.nombres, ParameterName = "@nombres"
                },
                new SqlParameter {
                    Value = entity.apellidos, ParameterName = "@apellidos"
                },
                new SqlParameter {
                    Value = entity.genero, ParameterName = "@genero"
                },
                new SqlParameter {
                    Value = entity.edad, ParameterName = "@edad"
                },
                new SqlParameter {
                    Value = entity.cargo, ParameterName = "@cargo"
                },
                new SqlParameter {
                    Value = entity.salario, ParameterName = "@salario"
                },
                new SqlParameter {
                    Value = entity.direccion, ParameterName = "@direccion"
                },
                new SqlParameter {
                    Value = entity.telefono, ParameterName = "@telefono"
                },
                new SqlParameter {
                    Value = entity.correo, ParameterName = "@correo"
                },
                new SqlParameter {
                    Value = entity.tipoDocumento, ParameterName = "@tipoDocumento"
                },
                new SqlParameter {
                    Value = entity.documento, ParameterName = "@documento"
                },
                new SqlParameter {
                    Value = entity.idEntidad, ParameterName = "@idEntidad"
                },
                new SqlParameter {
                    Value = entity.idUsuario, ParameterName = "@idUsuario"
                },
                new SqlParameter {
                    SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output, ParameterName = "@OutIdEmpleado"
                }
            };
            string messageError = string.Empty;

            connectionManager.AcctionRun(insertEmpleado, ref messageError, parameters);
            if (Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString()) > 0)
            {
                entity.id = Convert.ToInt32(parameters[parameters.Length - 1].Value.ToString());
            }
            if (!string.IsNullOrEmpty(messageError))
            {
                response.error      = messageError;
                response.successful = false;

                return(response);
            }
            response.error      = messageError;
            response.entity     = entity;
            response.successful = true;

            return(response);
        }