Beispiel #1
0
        /// <summary>
        /// Hace un Insert en la BD, guardando el obj instrumento pasado por parametro en la misma. Tiene que llamar a InsertarSaxofon o InsertarPiano  ya que estás son tablas derivadas de Instrumento.
        /// </summary>
        /// <param name="instrumento"></param>
        /// <returns></returns>
        public bool InsertarInstrumento(Instrumento instrumento)
        {
            bool rta = true;

            try
            {
                if (this.MarcaId(instrumento.Marca) < 1)
                {
                    this.InsertarMarca(instrumento.Marca);
                }

                StringBuilder sql = new StringBuilder();
                sql.Append("INSERT INTO Instrumento (Modelo, Calidad, Usado, idMarca, Precio, Stock) VALUES(");
                StringBuilder stringBuilder = sql.AppendLine("'" + instrumento.Modelo + "'," + instrumento.Calidad + "," + "," + this.MarcaId(instrumento.Marca) + "," + instrumento.Precio.ToString(System.Globalization.CultureInfo.InvariantCulture) + "," + instrumento.Stock + ")");

                this.comando = new SqlCommand();

                this.comando.CommandType = CommandType.Text;
                this.comando.CommandText = sql.ToString();
                this.comando.Connection  = this.conexion;

                this.conexion.Open();

                int filasAfectadas = this.comando.ExecuteNonQuery();

                if (filasAfectadas == 0)
                {
                    rta = false;
                }

                this.conexion.Close();

                if (instrumento is Saxofon)
                {
                    this.InsertarSaxofon(instrumento);
                }
                else
                {
                    this.InsertarPiano(instrumento);
                }
            }
            catch (Exception)
            {
                rta = false;
            }
            finally
            {
                if (this.conexion.State == ConnectionState.Open)
                {
                    this.conexion.Close();
                }
            }

            return(rta);
        }
Beispiel #2
0
        /// <summary>
        /// Busca y devuelve el ID del instrumento pasado por parametro en la BD, si no se encuentra devuelve -1.
        /// </summary>
        /// <param name="instrumento"></param>
        /// <returns></returns>
        private int GetInstrumentoId(Instrumento instrumento)
        {
            try
            {
                this.comando = new SqlCommand();

                this.comando.CommandType = CommandType.Text;
                this.comando.CommandText = "SELECT a.id AS idInstrumento, b.id AS idMarca, * FROM Instrumento a JOIN Marca b ON a.idMarca = b.id";
                this.comando.Connection  = this.conexion;

                this.conexion.Open();

                this.lector = comando.ExecuteReader();

                while (this.lector.Read())
                {
                    bool equal = true;
                    if (instrumento.Modelo != this.lector["Modelo"].ToString())
                    {
                        equal = false;
                    }

                    if (instrumento.Marca != new Marca(this.lector["Nombre"].ToString(), (EPais)this.lector["Pais"]))
                    {
                        equal = false;
                    }
                    if (instrumento.Precio != (double)this.lector["Precio"])
                    {
                        equal = false;
                    }

                    if (equal)
                    {
                        return((int)this.lector["id"]);
                    }
                }

                return(-1);
            }
            catch (Exception)
            {
                return(-1);
            }
            finally
            {
                if (this.conexion.State == ConnectionState.Open)
                {
                    this.conexion.Close();
                }
            }
        }
Beispiel #3
0
        /// <summary>
        /// Hace una entrada en la tabla Piano de la BD
        /// </summary>
        /// <param name="piano"></param>m>
        /// <returns></returns>
        private bool InsertarPiano(Instrumento piano)
        {
            bool rta = true;

            try
            {
                StringBuilder sql = new StringBuilder();
                sql.Append("INSERT INTO Piano (idInstrumento, Tipo) VALUES(");
                sql.AppendLine("'" + this.GetInstrumentoId(piano) + (piano as Piano).TipoPiano + ")");

                this.comando = new SqlCommand();

                this.comando.CommandType = CommandType.Text;
                this.comando.CommandText = sql.ToString();
                this.comando.Connection  = this.conexion;

                this.conexion.Open();

                int filasAfectadas = this.comando.ExecuteNonQuery();

                if (filasAfectadas == 0)
                {
                    rta = false;
                }
            }
            catch (Exception)
            {
                rta = false;
            }
            finally
            {
                if (this.conexion.State == ConnectionState.Open)
                {
                    this.conexion.Close();
                }
            }

            return(rta);
        }