//MessageBox로 currentEvent 값 확인 private void PrintCurrentEvent(EventVO currentEvent) { //VO 객체 값 할당된 거 확인하는 용도, 나중에 지울 것 MessageBox.Show(currentEvent.EventCODE + "\n" + currentEvent.EventOPERATOR + "\n" + currentEvent.EventSTARTTIME + "\n" + currentEvent.EventENDTIME + "\n" + currentEvent.EventLOCATION + "\n" + currentEvent.EventPHONENUMBER + "\n" + currentEvent.EventCALLERNAME + "\n" + currentEvent.EventPROBLEM + "\n" + currentEvent.EventCODE + "\n" + currentEvent.EventFirstANSWER + "\n" + currentEvent.EventSecondANSWER + "\n" + currentEvent.EventThirdANSWER + "\n" + currentEvent.EventFourthANSWER + "\n" + currentEvent.EventFifthANSWER + "\n" + currentEvent.EventSixthANSWER + "\n" + currentEvent.EventSeventhANSWER + "\n" + currentEvent.EventEighthANSWER); }
//UI 초기화 private void ResetEvent() { currentEvent = new EventVO(); additionalQuestion = new AdditionalQuestion(toastViewModel, loadingProcess, currentEvent); mainQuestion = new MainQuestion(additionalQuestion, toastViewModel, loadingProcess, currentEvent); nextButton.Content = "Next"; speechRecognition.Text = ""; callerStatement.Text = ""; mainFrame.Content = mainQuestion; }
private void nextButton_Click(object sender, RoutedEventArgs e) { if (nextButton.Content.Equals("Next")) { //근무자가 임의로 분류된 코드를 바꿨을 시에 변경한 코드로 매뉴얼을 제시해줌 additionalQuestion.ShowClassifiedManuals(mainQuestion.codeText.Text); SaveCurrentEventVO(); if (currentEvent.EventLOCATION == "") { toastViewModel.ShowError("Location data is missing. Ask where is the accident scene."); return; } else if (currentEvent.EventPROBLEM == "") { toastViewModel.ShowError("Problem data is missing. Ask what is the problem."); return; } additionalQuestion.location.Text = currentEvent.EventLOCATION; //MainPage, MainQuestion, AdditionalQuestion CurrentEvent VO 동기화 작업 mainQuestion.CurrentEventVO = currentEvent; additionalQuestion.CurrentEventVO = currentEvent; //PrintCurrentEvent(currentEvent);//VO 객체 값 할당된 거 확인하는 용도, 나중에 지울 것 mainFrame.Content = additionalQuestion; nextButton.Content = "Previous"; } else { SynchronizeEventData(); //MainPage, MainQuestion, AdditionalQuestion CurrentEvent VO 동기화 작업 currentEvent = additionalQuestion.CurrentEventVO; mainQuestion.CurrentEventVO = currentEvent; //카테고리가 나오기 전에 다음 화면으로 넘어갔을 경우 현재사건VO 객체에 코드 정보가 저장이 안 되어있기 때문에, //다음 화면(AdditionalQuestion 화면)에서 카테고리 결과가 출력되면 VO 객체에 값을 넣어줌 currentEvent.EventCODE = mainQuestion.classifiedResult; mainQuestion.codeText.Text = currentEvent.EventCODE; //PrintCurrentEvent(currentEvent);//VO 객체 값 할당된 거 확인하는 용도, 나중에 지울 것 mainFrame.Content = mainQuestion; nextButton.Content = "Next"; } }
public MainQuestion(AdditionalQuestion additionalQuestion, ToastViewModel toastViewModel, LoadingAnimation loadingAnimation, EventVO currentEvent) { InitializeComponent(); //azureDatabase = new AzureDatabase(); //Manual xaml 매뉴얼 this.simpleManualGrid.Children.Add(simpleManual); this.standardManualGrid.Children.Add(standardManual); this.additionalQuestion = additionalQuestion; this.toastViewModel = toastViewModel; this.loadingAnimation = loadingAnimation; this.currentEvent = currentEvent; mainColorSolidColorBrush = (SolidColorBrush)(new BrushConverter().ConvertFrom("#FF3580BF")); pointColorSolidColorBrush = (SolidColorBrush)(new BrushConverter().ConvertFrom("#FFFF5E00")); }
public AdditionalQuestion(ToastViewModel toastViewModel, LoadingAnimation loadingAnimation, EventVO currentEvent) { InitializeComponent(); this.classifiedManualGrid.Children.Add(classifiedManual); this.medicalManualGrid.Children.Add(medicalManual); this.toastViewModel = toastViewModel; this.loadingAnimation = loadingAnimation; this.currentEvent = currentEvent; firstQuestion.Content = currentEvent.EventFirstQUESTION; secondQuestion.Content = currentEvent.EventSecondQUESTION; thirdQuestion.Content = currentEvent.EventThirdQUESTION; fourthQuestion.Content = currentEvent.EventFourthUESTION; fifthQuestion.Content = currentEvent.EventFifthQUESTION; sixthQuestion.Content = currentEvent.EventSixthQUESTION; seventhQuestion.Content = currentEvent.EventSeventhQUESTION; eighthQuestion.Content = currentEvent.EventEighthQUESTION; mainColorSolidColorBrush = (SolidColorBrush)(new BrushConverter().ConvertFrom("#FF3580BF")); pointColorSolidColorBrush = (SolidColorBrush)(new BrushConverter().ConvertFrom("#FFFF5E00")); }
public void InsertData(EventVO currentEvent) { try { if (currentEvent.EventSecondANSWER == null) { currentEvent.EventSecondANSWER = "empty"; } if (currentEvent.EventEighthANSWER == null) { currentEvent.EventEighthANSWER = "empty"; } var cb = new SqlConnectionStringBuilder(); /* * cb.DataSource = "jangwonserver.database.windows.net"; * cb.UserID = "jangwon"; * cb.Password = "******"; * cb.InitialCatalog = "emergencycallDatabase"; */ cb.DataSource = "mynewserver-20171214.database.windows.net"; cb.UserID = "ServerAdmin"; cb.Password = "******"; cb.InitialCatalog = "mySampleDatabase"; string sql; using (var connection = new SqlConnection(cb.ConnectionString)) { connection.Open(); /* * sql = "insert into ECALL(EventOperator,eventStartTime,eventEndTime, eventLocation,eventPhoneNumber,eventCallerName,eventProblem,eventCode," + * "eventFirstAnswer,eventSecondAnswer,eventThirdAnswer,eventFourthAnswer,eventFifthAnswer,eventSixthAnswer,eventSeventhAnswer,eventEightAnswer) " + * "values(@EventOPERATOR,@EventSTARTTIME,@EventENDTIME,@EventLOCATION,@EventPHONENUMBER,@EventCALLERNAME,@EventPROBLEM,@EventCODE," + * "@FirstAnswer,@SecondAnswer,@ThirdAnswer,@FourthAnswer,@FifthAnswer,@SixthAnswer,@SeventhAnswer,@EightAnswer)"; */ sql = "insert into ECALL(EventOperator,eventStartTime,eventEndTime, eventLocation,eventPhoneNumber,eventCallerName,eventProblem,eventCode) " + "values(@EventOPERATOR,@EventSTARTTIME,@EventENDTIME,@EventLOCATION,@EventPHONENUMBER,@EventCALLERNAME,@EventPROBLEM,@EventCODE)"; SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@EventOPERATOR", currentEvent.EventOPERATOR); cmd.Parameters.AddWithValue("@EventSTARTTIME", currentEvent.EventSTARTTIME); cmd.Parameters.AddWithValue("@EventENDTIME", currentEvent.EventENDTIME); cmd.Parameters.AddWithValue("@EventLOCATION", currentEvent.EventLOCATION); cmd.Parameters.AddWithValue("@EventPHONENUMBER", currentEvent.EventPHONENUMBER); cmd.Parameters.AddWithValue("@EventCALLERNAME", currentEvent.EventCALLERNAME); cmd.Parameters.AddWithValue("@EventPROBLEM", currentEvent.EventPROBLEM); cmd.Parameters.AddWithValue("@EventCODE", currentEvent.EventCODE); /* * cmd.Parameters.AddWithValue("@FirstAnswer", currentEvent.EventFirstANSWER); * cmd.Parameters.AddWithValue("@SecondAnswer", currentEvent.EventSecondANSWER); * cmd.Parameters.AddWithValue("@ThirdAnswer", currentEvent.EventThirdANSWER); * cmd.Parameters.AddWithValue("@FourthAnswer", currentEvent.EventFourthANSWER); * cmd.Parameters.AddWithValue("@FifthAnswer", currentEvent.EventFifthANSWER); * cmd.Parameters.AddWithValue("@SixthAnswer", currentEvent.EventSixthANSWER); * cmd.Parameters.AddWithValue("@SeventhAnswer", currentEvent.EventSeventhANSWER); * cmd.Parameters.AddWithValue("@EightAnswer", currentEvent.EventEighthANSWER); */ if (cmd.ExecuteNonQuery() == 1) { //MessageBox.Show("Enroll!"); } else { //MessageBox.Show("Database Error!"); } } } catch (SqlException er) { //MessageBox.Show(er.ToString()); } }
//MessageBox로 currentEvent 값 확인 private void InsertCurrentEvent(EventVO currentEvent) { //azureDatabase.InsertData(currentEvent); }