public StringBuilder createInsertQuery(StewProductCosts st)
{
StringBuilder queryString = new StringBuilder();
queryString.Append("INSERT INTO StewProductCosts ");
queryString.Append("(costUnit,costSpecies,costProduct,costPounds,costCost,scalePC,includeInReport)");
// enter the actual values for the record
queryString.Append(" VALUES ('");
queryString.Append(st.costUnit);
queryString.Append("','");
queryString.Append(st.costSpecies);
queryString.Append("','");
queryString.Append(st.costProduct);
queryString.Append("','");
queryString.Append(st.costPounds);
queryString.Append("','");
queryString.Append(st.costCost);
queryString.Append("','");
queryString.Append(st.scalePC);
queryString.Append("','");
queryString.Append(st.includeInReport);
queryString.Append("');");
return(queryString);
} // end createInsertQuery
public void setupDialog()
{
// pull unique cutting unit, species and primary product to put in stewList
foreach (TreeDO js in Global.BL.getUniqueStewardGroups())
{
StewProductCosts spc = new StewProductCosts();
spc.costUnit = js.CuttingUnit.Code;
spc.costSpecies = js.Species;
spc.costProduct = js.SampleGroup.PrimaryProduct;
stewList.Add(spc);
} // end foreach loop
stewProductCostsBindingSource.DataSource = stewList;
StewardCosts.DataSource = stewProductCostsBindingSource;
return;
} // end setupDialog
