internal bool CreateCategory(Category category)
{
//Maken van een categorie
using (NpgsqlCommand cmd = new NpgsqlCommand())
{
cmd.Connection = _connection;
_transaction = cmd.Connection.BeginTransaction();
cmd.CommandText = "INSERT INTO category(name) VALUES(@name);";
cmd.Parameters.AddWithValue("name", category.Name);
bool success = parseNonqueryResult(cmd.ExecuteNonQuery());
if (success)
{
_transaction.Commit();
_transaction.Dispose();
return success; //Commit als het sucessvol is
}
_transaction.Rollback();
_transaction.Dispose();
return success;
}
}
public ActionResult UpdateCategory(Category category)
{
try
{
using (DatabaseQuery query = new DatabaseQuery())
{
if (ModelState.IsValid) //check of de modelstate goed is
{
query.UpdateCategory(category);
return RedirectToAction("CategoryOverview");
}
}
}
catch (Exception e)
{
ViewBag.Error = "Er is iets fout gegaan met het updaten van de categorie: " + e;
return RedirectToAction("ChangeCategory", category);
}
return RedirectToAction("category");
}
public ActionResult AddCategory()
{
Category model = new Category();
return View(model); //Geef pagina weer
}
public ActionResult NewCategory(Category category)
{
try
{
if (ModelState.IsValid) //check of de modelstate goed is
{
using (DatabaseQuery query = new DatabaseQuery())
{
query.CreateCategory(category);
return RedirectToAction("index"); //Laat de Admin zien als het goed gaat
}
}
}
catch (Exception error)
{
ModelState.AddModelError("Product is niet toegevoegd aan de Database", error);
//Adds a model error to the errors collection for the model-state dictionary.
}
return RedirectToAction("AddCategory", category);
}
internal bool UpdateCategory(Category category)
{
using (NpgsqlCommand cmd = new NpgsqlCommand())
{
cmd.Connection = this._connection;
_transaction = cmd.Connection.BeginTransaction();
cmd.CommandText = "UPDATE category SET name=@name where id = @id;";
cmd.Parameters.AddWithValue("id", (long)category.Id);
cmd.Parameters.AddWithValue("name", category.Name);
//Parameters
bool success = parseNonqueryResult(cmd.ExecuteNonQuery());
if (success)
{
_transaction.Commit();
_transaction.Dispose();
}
return success;
}
}
internal Category GetCategory(ulong categoryId)
{
using (NpgsqlCommand cmd = new NpgsqlCommand())
{
cmd.Connection = _connection;
cmd.CommandText = "SELECT * FROM category where id = @categoryId";
cmd.Parameters.AddWithValue("categoryId", (long)categoryId);
NpgsqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
Category category = new Category()
{
Id = (ulong)categoryId,
Name = reader.GetString(reader.GetOrdinal("name"))
};
return category;
}
reader.Close();
return null;
}
}
internal List<Category> GetCategories()
{
using (NpgsqlCommand cmd = new NpgsqlCommand())
{
cmd.Connection = this._connection;
cmd.CommandText = "SELECT * from category;";
NpgsqlDataReader reader = cmd.ExecuteReader();
List<Category> categories = new List<Category>();
while (reader.Read())
{
Category c = new Category();
c.Id = (ulong)reader.GetInt32(reader.GetOrdinal("id"));
c.Name = reader.GetString(reader.GetOrdinal("name"));
categories.Add(c);
}
reader.Close();
return categories;
}
}
internal List<Category> GetCategories(string pattern = null)
{
//Krijg een lijst met categorien
using (NpgsqlCommand cmd = new NpgsqlCommand())
{
cmd.Connection = this._connection;
cmd.CommandText = "SELECT * FROM category;";
NpgsqlDataReader reader = cmd.ExecuteReader(); //intialiseren
List<Category> categories = new List<Category>();
while (reader.Read())
{
Category category = new Category();
category.Id = (ulong)reader.GetInt32(reader.GetOrdinal("id"));
category.Name = reader.GetString(reader.GetOrdinal("name"));
categories.Add(category); //Blijf categorien toeveogen
}
reader.Close();
return categories; //return alle categorien
}
}