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