protected void eventsWidgetPanel_Load(object sender, EventArgs e) { if (Request.IsAuthenticated) { EventsWidget eventWidget = (EventsWidget)LoadControl("~/UserControls/Widgets/EventsWidget.ascx"); if (PrincipalHelper.IsUserSalesman() || PrincipalHelper.IsUserUser())//if user is salesman we filter events by salesman { eventWidget.eventData = CheckModelValidation(GetDatabaseConnectionInstance().GetAllEvents(PrincipalHelper.GetUserPrincipal().ID)); } else//otherwise we get all events { eventWidget.eventData = CheckModelValidation(GetDatabaseConnectionInstance().GetAllEvents()); } if (eventWidget.eventData != null) { var result = from myRows in eventWidget.eventData.AsEnumerable() where myRows.Field <DateTime>("Rok").CompareTo(DateTime.Now) >= 0 select myRows; if (result.Count() > 0) { eventWidget.eventData = result.CopyToDataTable(); } else { eventWidget.eventData = new DataTable(); } eventsWidgetPanel.Controls.Clear(); eventsWidgetPanel.Controls.Add(eventWidget); } } }