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