public List <CategoryMovements> getAllCategoryMovements() { List <CategoryMovements> ListCategories = new List <CategoryMovements>(); string Query = "SELECT * FROM categoriamovimientos;"; MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection()); MySqlDataReader reader; reader = Cmm.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CatMovement = new CategoryMovements(); CatMovement.Id = (int)reader["id"]; CatMovement.Name = (string)reader["name"]; CatMovement.Description = (string)reader["description"]; ListCategories.Add(CatMovement); } } Cmm.Connection.Close(); return(ListCategories); }
//Metodo de inserccion de Categorias public void insertCatproduct(CategoryMovements _CatMovement) { try { if (ExistCatMovement(_CatMovement.Id)) { Query = "UPDATE categoriamovimientos SET name='" + _CatMovement.Name.Trim() + "', description='" + _CatMovement.Description + "' WHERE id='" + _CatMovement.Id + "';"; } else { Query = "INSERT INTO categoriamovimientos(name, description) VALUES('" + _CatMovement.Name.Trim() + "','" + _CatMovement.Description + "');"; } MySqlCommand Cmm = new MySqlCommand(Query, ConectDB.getConection()); Cmm.ExecuteNonQuery(); Cmm.Connection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message + "\ninsertCatMoviments", "Error del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Error); } }