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