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