protected SQLParamList GetFilters()
{
Dashboard dm = Master as Dashboard;
SQLParamList sqlParams = new SQLParamList();
if (dm != null)
{
sqlParams = dm.GetFilters();
if (dm.IsPropertyUser)
{
SQLParamList sp2 = new SQLParamList();
foreach (SqlParameter sp in sqlParams.ToArray())
{
if (sp.ParameterName.Equals("@Property"))
{
sp2.Add("@PropertyID", (int)User.PropertyShortCode);
}
else
{
sp2.Add(sp);
}
}
sqlParams = sp2;
}
else
{
sqlParams.Add("@PropertyID", (int)PropertyShortCode);
}
}
else
{
sqlParams.Add("@PropertyID", (int)PropertyShortCode);
}
return(sqlParams);
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
DateRangeFilterControl dr = Master.Filters[0] as DateRangeFilterControl;
if (dr != null)
{
bool change = false;
if (dr.BeginDate.HasValue && dr.EndDate.HasValue)
{
TimeSpan ts = dr.EndDate.Value - dr.BeginDate.Value;
if (ts.TotalDays < 90 || ts.TotalDays > 90)
{
change = true;
}
}
else
{
change = true;
}
if (change)
{
dr.BeginDate = DateTime.Now.AddMonths(-5).AddDays(-DateTime.Now.AddMonths(-1).Day + 1).Date;
dr.EndDate = DateTime.Now.Date;
dr.Save();
TopMessage.WarningMessage = "In order to show more meaningful data, the date filter has been updated to show the past six months.";
}
}
SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120;
SQLParamList sqlParams = Master.GetFilters();
if (Master.IsPropertyUser)
{
SQLParamList sp2 = new SQLParamList();
foreach (SqlParameter sp in sqlParams.ToArray())
{
if (sp.ParameterName.Equals("@Property"))
{
sp2.Add("@PropertyID", (int)User.PropertyShortCode);
}
else
{
sp2.Add(sp);
}
}
sqlParams = sp2;
}
else
{
sqlParams.Add("@PropertyID", (int)PropertyShortCode);
}
DataSet ds = sql.ExecStoredProcedureDataSet("[spReports_PropertyDashboard]", sqlParams);
if (!sql.HasError)
{
Data = ds;
if (Data.Tables.Count > DATA_CURRENT_STATS)
{
StatRow = Data.Tables[DATA_CURRENT_STATS].Rows[0];
}
if (Data.Tables[DATA_TOTAL].Rows.Count > 0)
{
Master.RecordCount = ds.Tables[DATA_TOTAL].Rows[0]["TotalRecordsForFilter"].ToString();
}
}
}
