public void PopulateRecordPeriods(string showing) { if (site.Records != null) { foreach (var rec in site.Records) { if (DateTime.Now.Month > 9) { WY = DateTime.Now.AddYears(-1).Year; } else { WY = DateTime.Now.Year; } DateTime start_dt = Convert.ToDateTime(String.Format("10/1/{0}", WY - 1)); DateTime end_dt = Convert.ToDateTime(String.Format("9/30/{0}", DateTime.Now.Year)); var dsPeriods = db.SP_RMS_Periods_per_WY(rec.rms_record_id, start_dt, end_dt, "0").ToList(); int period_count = dsPeriods.Count(); if (rec.RecordAnalysisPeriods != null) { if (period_count > 0) { DataList dlPeriods = ConstructDL(rec.RecordType.type_ds, period_count, WY.ToString()); dlPeriods.DataSource = db.SP_RMS_Periods_per_WY(rec.rms_record_id, start_dt, end_dt, "0").ToList(); dlPeriods.DataBind(); phPeriods.Controls.Add(dlPeriods); } else { int lastWY = WY - 1; start_dt = Convert.ToDateTime(String.Format("10/1/{0}", lastWY - 1)); end_dt = Convert.ToDateTime(String.Format("9/30/{0}", lastWY)); var dsPeriods_lastWY = db.SP_RMS_Periods_per_WY(rec.rms_record_id, start_dt, end_dt, "0").ToList(); int period_count_lastWY = dsPeriods_lastWY.Count(); if (period_count_lastWY > 0) { DataList dlPeriods = ConstructDL(rec.RecordType.type_ds, period_count_lastWY, lastWY.ToString()); dlPeriods.DataSource = dsPeriods_lastWY; dlPeriods.DataBind(); phPeriods.Controls.Add(dlPeriods); } else { int last2WY = lastWY - 1; start_dt = Convert.ToDateTime(String.Format("10/1/{0}", last2WY - 1)); end_dt = Convert.ToDateTime(String.Format("9/30/{0}", last2WY)); var dsPeriods_last2WY = db.SP_RMS_Periods_per_WY(rec.rms_record_id, start_dt, end_dt, "0").ToList(); int period_count_last2WY = dsPeriods_last2WY.Count(); if (period_count_last2WY > 0) { DataList dlPeriods = ConstructDL(rec.RecordType.type_ds, period_count_last2WY, last2WY.ToString()); dlPeriods.DataSource = dsPeriods_last2WY; dlPeriods.DataBind(); phPeriods.Controls.Add(dlPeriods); } } } } else { lblNoRecs.Visible = true; pnlEnterSite.Visible = true; pnlEditStatus.Visible = false; return; } } lblSiteNo.Text = "Records for <a href=\"" + Config.SIMSURL + "StationInfo.aspx?site_id=" + site.site_id.ToString() + "\" target=\"_blank\">" + site.site_no + " " + db.vSITEFILEs.FirstOrDefault(s => s.site_id == site.nwisweb_site_id).station_nm + "</a>"; lblNoRecs.Visible = false; pnlEnterSite.Visible = false; pnlEditStatus.Visible = true; if (showing == "view") { pnlInstructions.Visible = true; pnlEdit.Visible = false; } else if (showing == "confirm") { pnlInstructions.Visible = false; } else { pnlInstructions.Visible = false; PopulateEditStatusArea(); } } else { lblNoRecs.Visible = true; pnlEnterSite.Visible = true; pnlEditStatus.Visible = false; } }