public string UpdateQNA([FromBody] QNA QNA) { UserModel userInfo = SessionExtensionTool.GetObject <UserModel>(HttpContext.Session, "userInfo"); Dictionary <string, string> param = new Dictionary <string, string>(); // QNA 데이터 파싱 param.Add("SelectSubj", QNA.SelectSubj); param.Add("Title", QNA.Title); param.Add("OthbcAt", QNA.OthbcAt); param.Add("Content", QNA.Content); param.Add("bbs_id", QNA.Bbs_id); param.Add("AtchFileId", QNA.AtchFileId); param.Add("user_id", userInfo.user_id); string query = ""; query = "UPDATE OP_BBS SET " + "TITLE = @Title:VARCHAR" + ", UPDATE_DT = TO_CHAR(SYSDATE, 'yyyy/mm/dd hh:mi')" + ", CONTENTS = @Content:VARCHAR" + ", UPDUSR = @user_id:VARCHAR" + ", DOC_ID = @AtchFileId:VARCHAR" + ", OTHBC_AT = @OthbcAt:VARCHAR WHERE BBS_ID = @bbs_id:NUMBER"; //cud 처리할 때는 트랜잭션 시작해주어야함 using var transaction = _context.Database.BeginTransaction(); _commonDao.Update(query, param); transaction.Commit(); return("ok"); }
private async void ImDoneBitches_Click(object sender, RoutedEventArgs e) { var Happyness = 0; var amountofQs = _generatedTest.Questions.Count; for (int i = 0; i < amountofQs; i++) { var controller = (TextBox)QNA.FindName($"answerBox_{i}"); var fuckingUsersAnswer = controller.Text; if (fuckingUsersAnswer == _generatedTest.Answers[i]) { Happyness++; } } var Results = new Results() { Difficulty = _generatedTest.Difficulty, Grade = _generatedTest.Grade, Person = _generatedTest.Person, TestResults = $"{Happyness}/{_generatedTest.Questions.Count}" }; /// var myResults = JsonConvert.SerializeObject(Results); await WriteResults(myResults); Frame.Navigate(typeof(Welcome), _myHacko.Account); }
private void showMeTheMoney_clicked(object sender, Windows.UI.Xaml.RoutedEventArgs e) { var myButton = ((Button)sender).Name; //returns two values in array 0 = name of control 1 = controlIDNumber var myChosenItem = myButton.Split('_'); var answer = _generatedTest.Answers[Convert.ToInt32(myChosenItem[1])]; TextBox TheTextBoxYaChecking = (TextBox)QNA.FindName($"answerBox_{myChosenItem[1]}"); // GET MY VALUE :::: var bobbys_answer = TheTextBoxYaChecking.Text; TheTextBoxYaChecking.Text = answer; Debug.WriteLine(answer); }
public string InsertQNA([FromBody] QNA QNA) { UserModel userInfo = SessionExtensionTool.GetObject <UserModel>(HttpContext.Session, "userInfo"); Dictionary <string, string> param = new Dictionary <string, string>(); // QNA 데이터 파싱 param.Add("SelectSubj", QNA.SelectSubj); param.Add("Title", QNA.Title); param.Add("OthbcAt", QNA.OthbcAt); param.Add("Content", QNA.Content); param.Add("AtchFileId", QNA.AtchFileId); param.Add("user_id", userInfo.user_id); string query = ""; query = "INSERT INTO OP_BBS " + "VALUES(NOTICE_SEQ.NEXTVAL" + ", @SelectSubj:VARCHAR" + ", '" + _codeMngTool.getCode("BBS", "QNA") + "'" + ", @Title:VARCHAR" + ", TO_CHAR(SYSDATE, 'yyyy/mm/dd hh:mi')" + ", 0" + ", @Content:VARCHAR" + ", @user_id:VARCHAR" + ", @AtchFileId:VARCHAR" + ", @OthbcAt:VARCHAR" + ", NULL" + ", NULL" + ", NULL)"; //cud 처리할 때는 트랜잭션 시작해주어야함 using var transaction = _context.Database.BeginTransaction(); _commonDao.Insert(query, param); transaction.Commit(); return("ok"); }
private async Task CrowdSourcingInJH(IDialogContext context, IAwaitable <string> result) { var res = await result; switch (res) { case Prompts.NO: await context.PostAsync($"I am sorry. That is the extend of my knowledge for now. {Constants.ASKUSERFORNEXTQUESTION}"); context.Done(this); //Finish this dialog break; default: // Get Answer from QnAMaker service var answer = QNA.CallQnAService(QNAQuestions.ASKABOUTCROWDSOURCINGINJH); await context.PostAsync(answer); await context.PostAsync(Constants.ASKUSERFORNEXTQUESTION); context.Done(this); //Finish this dialog break; } }
private async Task WhatIsCrowdsourcing(IDialogContext context, IAwaitable <string> result) { //await context.PostAsync("CrowdSourceDialog.AfterSelectOption"); var res = await result; switch (res) { case Prompts.NO: PromptDialog.Choice(context, CrowdSourcingInJH, new string[] { Prompts.YES, Prompts.NO }, "do you mean about crowdsourcing at JH?"); break; default: // Get Answer from QnAMaker service var answer = QNA.CallQnAService(QNAQuestions.ASKABOUTCROWDSOURCING); await context.PostAsync(answer); await context.PostAsync(Constants.ASKUSERFORNEXTQUESTION); context.Done(this); //Finish this dialog break; } }
private void Awake() { pC = Player.GetComponent <PlayerController>(); qNA = GetComponent <QNA>(); }