public bool AddEvent(Event evnt) { evnt.EventID = LastEventIndex + 1; //give it the biggest ID //evnt.EventID = EventsDB.Events.Last().EventID + 1; try { EventsDB.Events.InsertOnSubmit(evnt); EventsDB.SubmitChanges(); LastEventIndex++; return true; } catch (Exception exc) { return false; } }
private void Add_Click(object sender, RoutedEventArgs e) { Event evnt = new Event(); evnt.EventID = 0;//to be set in the DB class evnt.EventName = TextBoxEventName.Text.ToString(); evnt.EventPlace = TextBoxPlace.Text.ToString(); try { evnt.DateFrom = new DateTime(int.Parse(TextBoxFromYear.Text.ToString()), int.Parse(TextBoxFromMonth.Text.ToString()), int.Parse(TextBoxFromDay.Text.ToString()), int.Parse(TextBoxFromHour.Text.ToString()), int.Parse(TextBoxFromMinute.Text.ToString()), 0); evnt.DateTo = new DateTime(int.Parse(TextBoxToYear.Text.ToString()), int.Parse(TextBoxToMonth.Text.ToString()), int.Parse(TextBoxToDay.Text.ToString()), int.Parse(TextBoxToHour.Text.ToString()), int.Parse(TextBoxToMinute.Text.ToString()), 0); DatabaseClass databaseClass = new DatabaseClass(); if (databaseClass.AddEvent(evnt)) { MessageBox.Show("Event added successfully!"); NavigationService.Navigate(new Uri("/PivotPage1.xaml", UriKind.Relative)); //when navigating to PivotPage1, the UI will // be automaticlally updated } else { MessageBox.Show("Error occured when trying to add event to Database!"); } } catch (Exception exc) { MessageBox.Show("Error in DateTime format!" + exc.ToString()); } }
public bool EditEvent(Event evnt) { try { // Query for a specific Event IQueryable<Event> EvntQuery = from ev in EventsDB.Events where ev.EventID == evnt.EventID select ev; //Event evntEdit = EvntQuery.FirstOrDefault(); EvntQuery.First().DateFrom = evnt.DateFrom; EvntQuery.First().DateTo = evnt.DateTo; EvntQuery.First().EventID = evnt.EventID; EvntQuery.First().EventName = evnt.EventName; EvntQuery.First().EventPlace = evnt.EventPlace; EventsDB.SubmitChanges(); return true; } catch (Exception exc) { return false; } }
protected override void OnNavigatedFrom(System.Windows.Navigation.NavigationEventArgs e) { base.OnNavigatedTo(e); if (e.Content is EditEventPage) { //get the event with the specified ID Event vnt = new Event(); foreach(Event ev in eventsListPerDay) { if (ev.EventID == selectedEventId) { vnt = ev; break; } } //pass the event to the EditEventPage (e.Content as EditEventPage).evntToEdit = vnt; } }