public void Atualizar(Models.Filmes.Filme movie) { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd; if (movie.Foto != null) { cmd = new SqlCommand("update item set CdBarra = @1, Titulo = @2, Ano = @3, Tipo = @4, Preco = @5, DtAdquirida = @6, ValorCusto = @7, Situacao = @8, Foto = @10 where Id = @11"); SqlParameter param = cmd.Parameters.Add("@10", SqlDbType.VarBinary); param.Value = movie.Foto; } else { cmd = new SqlCommand("update item set CdBarra = @1, Titulo = @2, Ano = @3, Tipo = @4, Preco = @5, DtAdquirida = @6, ValorCusto = @7, Situacao = @8, where Id = @11"); } cmd.Connection = conn; cmd.Parameters.AddWithValue("@1", movie.Cdbarras); cmd.Parameters.AddWithValue("@2", movie.Titulo); cmd.Parameters.AddWithValue("@3", movie.Ano); cmd.Parameters.AddWithValue("@4", movie.Tipo); cmd.Parameters.AddWithValue("@5", movie.Preco); cmd.Parameters.AddWithValue("@6", movie.DtAdquirida); cmd.Parameters.AddWithValue("@7", movie.ValorCusto); cmd.Parameters.AddWithValue("@8", movie.Situacao); cmd.Parameters.AddWithValue("@11", movie.Id); cmd.ExecuteNonQuery(); }
public void Inserir(Models.Filmes.Filme movie) { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand("insert into item values(@1, @2, @3, @4, @5, @6, @7, @8, @10)"); cmd.Connection = conn; cmd.Parameters.AddWithValue("@1", movie.Cdbarras); cmd.Parameters.AddWithValue("@2", movie.Titulo); cmd.Parameters.AddWithValue("@3", movie.Ano); cmd.Parameters.AddWithValue("@4", movie.Tipo); cmd.Parameters.AddWithValue("@5", movie.Preco); cmd.Parameters.AddWithValue("@6", movie.DtAdquirida); cmd.Parameters.AddWithValue("@7", movie.ValorCusto); cmd.Parameters.AddWithValue("@8", movie.Situacao); SqlParameter param = cmd.Parameters.Add("@10", SqlDbType.VarBinary); param.Value = movie.Foto; cmd.ExecuteNonQuery(); }
public Models.Filmes.Filme Buscar(string query, bool ehId) { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd; if (ehId) { cmd = new SqlCommand("select * from item where Id = @1"); } else { cmd = new SqlCommand("select * from item where CdBarra = @1"); } cmd.Connection = conn; cmd.Parameters.AddWithValue("@1", query); SqlDataReader d = cmd.ExecuteReader(); Models.Filmes.Filme movie = new Models.Filmes.Filme(); while (d.Read()) { movie.Cdbarras = d["CdBarra"].ToString(); movie.Titulo = d["Titulo"].ToString(); movie.Ano = Convert.ToInt32(d["Ano"].ToString()); movie.Tipo = d["Tipo"].ToString(); movie.Preco = Convert.ToInt32(d["Preco"].ToString()); movie.DtAdquirida = Convert.ToDateTime(d["DtAdquirida"].ToString()); movie.ValorCusto = Convert.ToInt32(d["ValorCusto"].ToString()); movie.Situacao = d["Situacao"].ToString(); movie.Foto = (byte[])d["Foto"]; movie.Id = Convert.ToInt32(d["Id"].ToString()); } return(movie); }