private void BtnEditVisitorInfo_Click(object sender, RoutedEventArgs e) { if (gridDbData.SelectedIndex > 0 && gridDbData.SelectedIndex != gridDbData.Items.Count) { DataRowView r = gridDbData.SelectedItem as DataRowView; Visitor existing = GetVisitorObject(r); //MessageBox.Show(gridDbData.SelectedItem.ToString()); VisitorsWindow modifyVisitor = new VisitorsWindow(ds.Tables["Countries"].Rows, existing); if (modifyVisitor.ShowDialog().Value) { Visitor v = modifyVisitor.VisitorInfo; string command = "UPDATE Visitors SET " + @"FullName ='" + v.FullName + @"', " + @"Major ='" + v.Major + @"', " + @"Country ='" + v.Country + @"', " + @"Status ='" + v.VisitorStatus.ToString() + @"', " + @"Speaker ='" + v.IsSpeaker + @"', " + @"CheckinDate ='" + v.CheckInDate + @"' WHERE Id =" + r["Id"]; ExecuteNonQuery(command); } } else { MessageBox.Show("Please select a record first"); } }
private void BtnAddVisitor_Click(object sender, RoutedEventArgs e) { VisitorsWindow newVisitorWindow = new VisitorsWindow(ds.Tables["Countries"].Rows); if (newVisitorWindow.ShowDialog().Value) { //Add to the database Visitor v = newVisitorWindow.VisitorInfo; string command = "INSERT into Visitors" + "(FullName, Major, Country, Status, Speaker, CheckinDate, ConferenceID) VALUES (" + @"'" + v.FullName + @"', " + @"'" + v.Major + @"', " + @"'" + v.Country + @"', " + @"'" + v.VisitorStatus.ToString() + @"', " + @"'" + v.IsSpeaker + @"', " + @"'" + v.CheckInDate + @"', " + ConferenceInfo.Id + ")"; ExecuteNonQuery(command); } }