public List <categoriaModel> selectAll()
{
using (SqlConnection connection = new SqlConnection(SQLconnection.ConnectionString())) {
Command.Connection = connection;
Command.CommandText = "SELECT_ALL_CATEGORIES";
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
categorias.Clear();
if (reader.HasRows)
{
while (reader.Read())
{
categorias.Add(new categoriaModel
{
CategoryID = (int)reader["CategoryID"],
CategoryName = (string)reader["CategoryName"],
Description = (string)reader["Description"],
Picture = (byte[])reader["Picture"]
});
}
}
Command.Connection.Close();
return(categorias);
}
}
public int delete(categoriaModel categoria)
{
using (SqlConnection connection = new SqlConnection(SQLconnection.ConnectionString()))
{
Command.Connection = connection;
Command.CommandText = "DELETE_CATEGORIES";
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@CATEGORY_ID", categoria.CategoryID);
Command.Connection.Open();
int affected = Command.ExecuteNonQuery();
Command.Connection.Close();
return(affected);
}
}
public int insert(categoriaModel categoria)
{
using (SqlConnection connection = new SqlConnection(SQLconnection.ConnectionString()))
{
Command.Connection = connection;
Command.CommandText = "INSERT_CATEGORIES";
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@CATEGORY_NAME", categoria.CategoryName);
Command.Parameters.AddWithValue("@DESCRIPTION", categoria.Description);
Command.Parameters.AddWithValue("@PICTURE", categoria.Picture);
Command.Connection.Open();
int affected = Command.ExecuteNonQuery();
Command.Connection.Close();
return(affected);
}
}
public void Testinsert()
{
Assert.True(SQLconnection.Insert($"INSERT INTO Vare (navn, pris, stock) VALUES ('Rasmus', 200, 2)"));
Assert.False(SQLconnection.Insert($"INSERT INTO Vare (navn, pris, stock) VALUES ('Rasmus', 'jacob')"));
}
public void Testupdate()
{
Assert.True(SQLconnection.Insert($"UPDATE Vare SET navn ='Kage', pris = '200', stock = '3222' WHERE id = 3"));
Assert.False(SQLconnection.Insert($"UPDATE Vare SET navn ='Kage', pris = Mans WHERE id = 44"));
}
