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