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();
}
}
