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