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