// Adds raw material to database with given name and quantity
public void AddRawMaterial(RawMaterial rawMaterial)
{
try
{
// Create a SQL command that takes user input -- raw material name, quantity -- and inputs into RawMaterials database
Cn.Open();
cmd = new SqlCommand("Insert into RawMaterials(RawMaterialName, Quantity) Values(@RawMaterialName, @Quantity);", Cn);
cmd.Parameters.AddWithValue("@RawMaterialName", rawMaterial.rawMaterialName);
cmd.Parameters.AddWithValue("@Quantity", rawMaterial.quantity);
cmd.ExecuteNonQuery(); // Execute the sql command
}
catch (Exception err)
{
MessageBox.Show(err.Message, "Warning!");
}
finally
{
Cn.Close();
}
}
// Function to return a list of products from the product database
public List <RawMaterial> CreateRawMaterialList()
{
// Create a new list of Products
List <RawMaterial> rawMaterials;
rawMaterials = new List <RawMaterial>();
try
{
RawMaterial tempMaterial;
// Create the sql command
Cn.Open();
cmd = new SqlCommand("SELECT TRIM(RawMaterialName) AS RawMaterialName, Quantity FROM RawMaterials", Cn);
reader = cmd.ExecuteReader();
// Get the information from the Products databse and add it to the list of Product objects
while (reader.Read())
{
string name = (string)reader["RawMaterialName"];
int quantity = (int)reader["Quantity"];
tempMaterial = new RawMaterial(name, quantity);
rawMaterials.Add(tempMaterial);
}
reader.Close();
}
catch (Exception err)
{
throw;
}
finally
{
Cn.Close();
}
return(rawMaterials);
}
