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