public void update(MODEL.HQ hq) { SqlConnection conexao = new SqlConnection(strCon); string sql = "Update HQ set titulo=@titulo, "; sql += " autor=@autor, quantidade=@quantidade, valor=@valor "; sql += " where id=@id"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@titulo", hq.Titulo); cmd.Parameters.AddWithValue("@autor", hq.Autor); cmd.Parameters.AddWithValue("@quantidade", hq.Qtd); cmd.Parameters.AddWithValue("@valor", hq.Valor); conexao.Open(); try { cmd.ExecuteNonQuery(); } catch { Console.WriteLine("Erro na atualização do produto"); } finally { conexao.Close(); } }
public List <MODEL.HQ> SelectByNome(string nome) { List <MODEL.HQ> lstHQ = new List <MODEL.HQ>(); SqlConnection conexao = new SqlConnection(strCon); string sql = "Select * from HQ where (titulo like @titulo)"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@titulo", nome.Trim() + "%"); conexao.Open(); try { SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { MODEL.HQ HQ = new MODEL.HQ(); HQ.Id__Hq = Convert.ToInt32(reader[0].ToString()); HQ.Titulo = reader["titulo"].ToString(); HQ.Autor = reader["autor"].ToString(); HQ.Qtd = Convert.ToInt32(reader["quantidade"].ToString()); HQ.Valor = Convert.ToInt32(reader["valor"].ToString()); lstHQ.Add(HQ); } } catch { Console.WriteLine("Deu erro na Seleção de HQ por Nome..."); } finally { conexao.Close(); } return(lstHQ); }
public void Insert(MODEL.HQ hq) { SqlConnection conexao = new SqlConnection(strCon); string sql = "Insert into HQ values (@titulo, @autor,@quantidade, @valor)"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@titulo", hq.Titulo); cmd.Parameters.AddWithValue("@autor", hq.Autor); cmd.Parameters.AddWithValue("@quantidade", hq.Qtd); cmd.Parameters.AddWithValue("@valor", hq.Valor); conexao.Open(); try { cmd.ExecuteNonQuery(); //hq.Qtd++; } catch { Console.WriteLine("Erro ao inserir produto!"); } finally { conexao.Close(); } }
public List <MODEL.HQ> Select() { List <MODEL.HQ> lstHQ = new List <MODEL.HQ>(); SqlConnection conexao = new SqlConnection(strCon); string sql = "Select * from HQ"; SqlCommand cmd = new SqlCommand(sql, conexao); conexao.Open(); try { SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { MODEL.HQ hq = new MODEL.HQ(); hq.Id__Hq = Convert.ToInt32(reader[0].ToString()); hq.Titulo = reader["Titulo"].ToString(); hq.Autor = reader["Autor"].ToString(); hq.Qtd = Convert.ToInt32(reader["quantidade"].ToString()); hq.Valor = Convert.ToDouble(reader["Valor"].ToString()); lstHQ.Add(hq); } } catch { Console.WriteLine("Erro na seleção de produtos!"); } finally { conexao.Close(); } return(lstHQ); }
public void Delete(MODEL.HQ hq) { SqlConnection conexao = new SqlConnection(strCon); string sql = "Delete from HQ where id=@id;"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@id", hq.Id__Hq); conexao.Open(); try { cmd.ExecuteNonQuery(); } catch { Console.WriteLine("Erro na Remoção de Produtos!"); } finally { conexao.Close(); } }
public void Delete(MODEL.HQ hq) { DAL.HQ dalHQ = new DAL.HQ(); dalHQ.Delete(hq); }
public void Update(MODEL.HQ hq) { DAL.HQ dalHQ = new DAL.HQ(); dalHQ.update(hq); }
public void Insert(MODEL.HQ hq) { DAL.HQ dalHQ = new DAL.HQ(); dalHQ.Insert(hq); }