protected void rgCRPStatus_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
string onlyactive = "yes";
if (rrblRecords.SelectedValue != "active")
{
onlyactive = "no";
}
if (rddlOffice.SelectedIndex > 0)
{
reportOfficeID = Convert.ToInt32(rddlOffice.SelectedValue);
}
else
{
reportOfficeID = 0;
}
var CRPdata = db.SP_CRP_Ult_Data_Aging_Table(reportOfficeID, WSCID, onlyactive).Select(p => new
{
office_cd = p.office_cd,
office_id = p.office_id,
rms_record_id = p.rms_record_id,
site_no = p.site_no,
station_nm = p.station_nm,
category_no = p.category_no,
parm_cd = p.parm_cd,
type_cd = p.type_cd,
type_ds = p.type_ds,
analyzed_period_beg_dt = p.analyzed_period_beg_dt,
analyzed_period_dt = p.analyzed_period_dt,
approved_period_beg_dt = p.approved_period_beg_dt,
approved_period_dt = p.approved_period_dt,
audit_end_dt = p.audit_end_dt,
last_aging_dt = p.last_aging_dt,
DaysSinceAging = p.DaysSinceAging,
SIMSURL = Config.SIMSURL,
site_id = db.Sites.FirstOrDefault(s => s.site_no == p.site_no).site_id
}).OrderBy(p => p.office_cd).ThenBy(p => p.site_no).ThenBy(p => p.type_cd).ToList();
rgCRPStatus.DataSource = CRPdata;
ltlNumberOfRecords.Text = "Number of records returned: <b>" + CRPdata.Count.ToString() + "</b>";
}
