protected void rgRecentActions_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
DateTime startDt = DateTime.Now.AddDays(-1), endDt = DateTime.Now;
if (rdpStartDt.SelectedDate != null)
{
startDt = Convert.ToDateTime(rdpStartDt.SelectedDate);
}
if (rdpEndDt.SelectedDate != null)
{
endDt = Convert.ToDateTime(rdpEndDt.SelectedDate);
}
if (rddlOffice.SelectedIndex > 0)
{
reportOfficeID = Convert.ToInt32(rddlOffice.SelectedValue);
}
else
{
reportOfficeID = 0;
}
var ActionsData = db.SP_RMS_RecentActions(reportOfficeID, WSCID, startDt, endDt).Select(p => new
{
origin_va = p.origin_va,
status_set_to_va = p.status_set_to_va,
dialog_by = p.dialog_by,
dialog_dt = p.dialog_dt,
period_beg_dt = p.period_beg_dt,
period_end_dt = p.period_end_dt,
office_id = p.record_office_id,
station_nm = p.station_nm,
site_no = p.site_no,
site_id = p.site_id,
type_cd = p.type_cd,
type_ds = p.type_ds,
SIMSURL = Config.SIMSURL
}).OrderBy(p => p.dialog_dt).ToList();
rgRecentActions.DataSource = ActionsData;
ltlNumberOfRecords.Text = "Number of records returned: <b>" + ActionsData.Count.ToString() + "</b>";
}
