public void refreshMasterEventHeader() { masterEventHeader = new FSRESTAURANT.EVENT_HEADERDataTable(); adapterMgr.EVENT_HEADERTableAdapter.Fill(masterEventHeader); foreach (DataRow item in masterEventHeader.Rows) { listBox1.Items.Add(item[1]); } }
public EventSearch(FSRESTAURANT.EVENT_HEADERDataTable dt) { InitializeComponent(); this.dt = dt; DockContent dc = new DockContent(); dc.Controls.Add(monthView1); monthView1.Dock = DockStyle.Fill; dc.DockPanel = dockPanel1; dc.DockState = DockState.DockLeftAutoHide; dockPanel1.AllowEndUserDocking = false; dockPanel1.ActiveAutoHideContent = dc; dockPanel1.Controls.Add(EventCalendar); dockPanel1.Dock = DockStyle.Fill; EventCalendar.Dock = DockStyle.Fill; foreach (FSRESTAURANT.EVENT_HEADERRow item in dt) { TimeSpan ts = item.EVENT_STOP.Subtract(item.EVENT_START); CalendarItem ci = new CalendarItem(EventCalendar, item.EVENT_START, ts, item.EVENT_NAME); ci.Tag = item.EVENT_ID.ToString(); if (item.EVENT_STATUS == "Y") { ci.ApplyColor(Color.LightGreen); } else { if (item.EVENT_STOP < DateTime.Now) { ci.ApplyColor(Color.Black); } else { ci.ApplyColor(Color.DarkCyan); } } _items.Add(ci); } PlaceItems(); }