Exemple #1
0
        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 + @"', " +
                    conferenceID + ")";
                ExecuteNonQuery(command);
            }
        }
Exemple #2
0
        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); /*new Visitor()
                                                             * {
                                                             * FullName = r["FullName"].ToString(),
                                                             * Major = r["Major"].ToString(),
                                                             * Country = r["Country"].ToString(),
                                                             * VisitorStatus = r["Status"].ToString() == Status.Teacher.ToString() ? Status.Teacher :
                                                             * r["Status"].ToString() == Status.Student.ToString() ? Status.Student : Status.Proffessional,
                                                             * IsSpeaker = bool.Parse(r["Speaker"].ToString()),
                                                             * CheckInDate = DateTime.Parse(r["CheckinDate"].ToString())
                                                             * };*/
                //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", "No Selection", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }