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);
}
