public bool DelCategory(DBKategorie categories) { var result = _dbConnection.Execute("DELETE from mg.Kategorie WHERE IDkategorii = @IDkat", new { IDkat = categories.IDkategorii }); return(result == 1); }
public bool UpdateCategory(DBKategorie categories) { var result = _dbConnection.Execute("UPDATE mg.Kategorie SET NazwaKategorii = @newName, Opis = @newDescription WHERE IDkategorii = @IDkat", new { newName = categories.NazwaKategorii, newDescription = categories.Opis, IDkat = categories.IDkategorii }); return(result == 1); }
public bool AddCategory(DBKategorie categories) { var result = _dbConnection.Execute("INSERT INTO mg.Kategorie (IDkategorii, NazwaKategorii, Opis) VALUES (@IDkat, @Nkat, @Op)", new { IDkat = categories.IDkategorii, Nkat = categories.NazwaKategorii, Op = categories.Opis }); return(result == 1); }