// devsolution 2003/6/17: Finished - Added items for calendar control /// <summary> /// devsolution 2003/6/17: /// Change to make a RenderEvents for modularity /// Routine to add show calendar logic /// And Clean up code as now the calendar next and previous /// controls must re-render the display and get the data again /// e.g. modularize the code /// </summary> /// <param name="DisplayMonth">Month to display 1=Jan, 2=Feb, etc</param> /// <param name="DisplayYear">Year to display YYYY, 2003 for 2003</param> private void RenderEvents(int DisplayMonth, int DisplayYear) { EventsDB events = new EventsDB(); myDataList.RepeatDirection = (Settings["RepeatDirectionSetting"].ToString() == "Horizontal" ? RepeatDirection.Horizontal : RepeatDirection.Vertical); myDataList.RepeatColumns = Int32.Parse(Settings["RepeatColumns"].ToString()); if (bool.Parse(Settings["ShowBorder"].ToString())) { //myDataList.BorderWidth=Unit.Pixel(1); myDataList.ItemStyle.BorderWidth = Unit.Pixel(1); } dsEventData = events.GetEvents(ModuleID, Version); myDataList.DataSource = dsEventData; myDataList.DataBind(); // devsolution 2003/6/17: Added items for calendar control if (bool.Parse(Settings["ShowCalendar"].ToString())) { CalendarPanel.Visible = true; string DisplayDate = string.Empty; // devsolution 2003/6/17: Must have Devsolution.Portal.dll in \bin for calendar display functionality EventCalendar eventcalendar = new EventCalendar(); lblCalendar.Text = eventcalendar.GenerateCalendar(ModuleID, DisplayMonth, DisplayYear, out DisplayDate, dsEventData); lblDisplayDate.Text = DisplayDate; } // devsolution 2003/6/17: Finished - Added items for calendar control myDataList.DataSource = dsEventData; myDataList.DataBind(); }
private void LoadItemsCombobox() { // Load ContainerIDs // List <Container> containerList = ContainerDB.GetContainers(connectionstring); foreach (Container container in containerList) { ComboAddContainerID.Items.Add( container.ContainerID.ToString().PadRight(2) + container.Plaats); } // Load DeviceIDs // List <Device> deviceList = DeviceDB.GetDevice(connectionstring); foreach (Device device in deviceList) { ComboAddDeviceID.Items.Add( device.DeviceID.ToString().PadRight(2) + device.Van + device.Tot); } // Load EventIDs // List <Events> eventsList = EventsDB.GetEvents(connectionstring); foreach (Events events in eventsList) { ComboAddEventID.Items.Add( events.EventID.ToString().PadRight(2) + events.Naam.PadRight(10) + events.Locatie); } // Load VerantwoorkelijkeIDs // List <Persoon> persoonList = PersoonDB.GetPeople(connectionstring); foreach (Persoon persoon in persoonList) { ComboAddVerantwoordelijkeID.Items.Add( persoon.PersoonID.ToString().PadRight(2) + persoon.Voornaam.PadRight(10) + persoon.Achternaam); } }
private void updateRightList() { ListData.Items.Clear(); switch (selectedAdd) { case "Container": ListData.Items.Add( "ContainerID".PadRight(13) + "Plaats".PadRight(15) + "Van".PadRight(20) + "Tot"); List <Container> containerList = ContainerDB.GetContainers(myConnectionString); foreach (Container container in containerList) { ListData.Items.Add( container.ContainerID.ToString().PadRight(13) + container.Plaats.PadRight(15) + container.Van.ToString("dd/MM/yyyy").PadRight(20) + container.Tot.ToString("dd/MM/yyyy")); } break; case "Device": ListData.Items.Add( "DeviceID".PadRight(10) + "Van".PadRight(20) + "Tot"); List <Device> deviceList = DeviceDB.GetDevice(myConnectionString); foreach (Device device in deviceList) { ListData.Items.Add( device.DeviceID.ToString().PadRight(10) + device.Van.ToString().PadRight(20) + device.Tot); } break; case "Event": ListData.Items.Add( "ContactpersoonID".PadRight(18) + "Naam".PadRight(15) + "Locatie".PadRight(10) + "ContactpersoonID".PadRight(18) + "VerantwoordelijkeID"); List <Events> eventsList = EventsDB.GetEvents(myConnectionString); foreach (Events events in eventsList) { ListData.Items.Add( events.ContactpersoonID.ToString().PadRight(18) + events.Naam.PadRight(15) + events.Locatie.PadRight(10) + events.ContactpersoonID.ToString().PadRight(18) + events.VerantwoordelijkeID); } break; case "Persoon": ListData.Items.Add( "PersoonID".PadRight(10) + "Functie".PadRight(10) + "Voornaam".PadRight(10) + "Achternaam".PadRight(15) + "GSM"); List <Persoon> persoonList = PersoonDB.GetPeople(myConnectionString); foreach (Persoon persoon in persoonList) { ListData.Items.Add( persoon.PersoonID.ToString().PadRight(10) + persoon.Functie.PadRight(10) + persoon.Voornaam.PadRight(10) + persoon.Achternaam.PadRight(15) + persoon.GSM); } break; } }