public List <CategoriaProduct> getAllCategoryProducts()
{
List <CategoriaProduct> ListCategory = new List <CategoriaProduct>();
string Query = "SELECT id, name FROM categoriaproducto;";
MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection());
MySqlDataReader reader;
reader = Cmm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
newCategory = new CategoriaProduct();
newCategory.Id = (int)reader["id"];
newCategory.Name = (string)reader["name"];
ListCategory.Add(newCategory);
}
}
Cmm.Connection.Close();
return(ListCategory);
}
public void insertCatproduct(CategoriaProduct _CatProduct)
{
try
{
if (ExistCatProduct(_CatProduct.Id))
{
Query = "UPDATE categoriaproducto SET name='" + _CatProduct.Name.Trim() + "' WHERE id='" + _CatProduct.Id + "';";
}
else
{
Query = "INSERT INTO categoriaproducto(name) values('" + _CatProduct.Name.Trim() + "');";
}
MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection());
Cmm.ExecuteNonQuery();
Cmm.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\ninsertCatProducto", "Error del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
