public void getTotal(LocationEquips locationEquips)
{
connection.open();
command = new SqlCommand("select total from LocationEquips where locationID = '" + locationEquips.getLocationID() + "'", connection.getConnection());
locationEquips.setTotal((double)command.ExecuteScalar());
connection.close();
}
public void update(double total, string locationName)
{
locationControl = new LocationControl();
locationEquips = new LocationEquips();
locationEquipsDB = new LocationEquipsDB();
int ID = locationControl.getID(locationName);
locationEquips.setLocationID(ID);
locationEquips.setTotal(total);
locationEquipsDB.updateTotal(locationEquips);
}