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