//Will update a current item in a list in the database.
public static void UpdateItemInList(int itemId, string newName, int newQuantity)
{
GroceryItemsController.ItemValidityCheck(newName, newQuantity);
try
{
SqlConnectionStringBuilder builder = DatabaseController.ConnectionBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand query = new SqlCommand(null, connection);
query.CommandText = "UPDATE dbo.Items SET itemName = @name, quantity = @quantity WHERE itemId = @Id;";
SqlParameter namePar = new SqlParameter("@name", SqlDbType.VarChar, 255);
SqlParameter quantityPar = new SqlParameter("@quantity", SqlDbType.Int, 255);
SqlParameter idPar = new SqlParameter("@Id", SqlDbType.Int, 255);
namePar.Value = newName;
quantityPar.Value = newQuantity;
idPar.Value = itemId;
query.Parameters.Add(namePar);
query.Parameters.Add(quantityPar);
query.Parameters.Add(idPar);
query.Prepare();
query.ExecuteNonQuery();
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return;
}
//Will add a new item to a users lists in the the database.
public static void AddItemToList(string name, int quantity, int listId)
{
GroceryItemsController.ItemValidityCheck(name, quantity);
try
{
SqlConnectionStringBuilder builder = DatabaseController.ConnectionBuilder();
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlCommand query = new SqlCommand(null, connection);
query.CommandText = "INSERT INTO dbo.Items(itemName, quantity, listId) VALUES (@name, @quantity, @Id)";
SqlParameter namePar = new SqlParameter("@name", SqlDbType.VarChar, 255);
SqlParameter quantityPar = new SqlParameter("@quantity", SqlDbType.Int, 255);
SqlParameter idPar = new SqlParameter("@Id", SqlDbType.Int, 255);
namePar.Value = name;
quantityPar.Value = quantity;
idPar.Value = listId;
query.Parameters.Add(namePar);
query.Parameters.Add(quantityPar);
query.Parameters.Add(idPar);
query.Prepare();
query.ExecuteNonQuery();
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return;
}