private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { // popup methods view string columnName = this.dataGridViewStratumStats.Columns[e.ColumnIndex].HeaderText; if (columnName == "Method") { //set binding list using currentStratum_cn currentStratumStats.Used = 0; currentStratumStats.Save(); msStratumStats = new BindingList<StratumStatsDO>(cdDAL.Read<StratumStatsDO>("StratumStats", "Where Stratum_CN = ? ORDER BY Method", currentStratumStats.Stratum_CN)); currentStratum = cdDAL.ReadSingleRow<StratumDO>("Stratum", "Where Stratum_CN = ?", currentStratumStats.Stratum_CN); MethodSelect mDlg = new MethodSelect(this); //mDlg.Owner = this; // strDlg.dalFile = dalPath; mDlg.ShowDialog(this); // recreate stratum list/SampleGroup list with new selection currentStratumStats.Save(); //currentStratum = cdDAL.ReadSingleRow<StratumDO>("Stratum", "Where Stratum_CN = ?", currentStratumStats.Stratum_CN); //currentStratum.Method = currentStratumStats.Method; currentStratum.Save(); InitializeDatabaseTables(); bindingSourceStratumStats.DataSource = cdStratumStats; getSaleError(); } }
private void copyStratumToFScruise(DAL cdDAL) { //loop through design stratum table List<StratumDO> myStr = new List<StratumDO>(cdDAL.Read<StratumDO>("Stratum",null,null)); foreach(StratumDO curStr in myStr) { // create new stratumDO StratumDO fsStr = new StratumDO(fsDAL); // copy stratum information fsStr.Code = curStr.Code; fsStr.Description = curStr.Description; fsStr.Method = curStr.Method; fsStr.BasalAreaFactor = curStr.BasalAreaFactor; fsStr.FixedPlotSize = curStr.FixedPlotSize; fsStr.KZ3PPNT = curStr.KZ3PPNT; fsStr.YieldComponent = curStr.YieldComponent; fsStr.Year = curStr.Year; fsStr.Month = curStr.Month; fsStr.Save(); } }