public async Task <ActionResult <int> > PutFormQuestion([FromBody] FormQuestion formQuestion)
{
try
{
if (formQuestion == null || formQuestion.ID <= 0 || formQuestion.FormID <= 0)
{
return(BadRequest());
}
var result = await _consultingService.UpdateFormQuestion(formQuestion);
if (result <= 0)
{
return(NotFound());
}
return(Ok(result));
}
catch (Npgsql.PostgresException ex)
{
return(StatusCode((int)HttpStatusCode.ServiceUnavailable, $"Error with database code: {ex.SqlState}"));
}
catch (System.Net.Sockets.SocketException ex)
{
return(StatusCode((int)HttpStatusCode.ServiceUnavailable, $"Error with database. {ex.Message}"));
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, ex.Message));
}
}
public async Task <FormQuestion> GetFormQuestionById(int id)
{
string sp = StoreProcedures["GetFormQuestionById"];
DynamicParameters parameters = new DynamicParameters();
try
{
parameters.Add("fid", id, DbType.Int32);
var result_query = await _connection.QueryAsync(sp, parameters, commandType : CommandType.StoredProcedure);
FormQuestion result = null;
if (result_query != null && result_query.Any())
{
result = Mapper.FormQuestion.Map(result_query.FirstOrDefault());
}
return(result);
}
catch (Npgsql.PostgresException ex)
{
throw new Npgsql.NpgsqlException($"Error with database code: {ex.SqlState} msg: {ex.MessageText}");
}
catch (System.Net.Sockets.SocketException ex)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
public ActionResult New(string formTypeString)
{
FormType formType;
if (formTypeString == null || !Enum.TryParse(formTypeString, out formType))
{
ViewBag.ErrorMsg = "No such Url exists";
return(View("Error"));
}
if (_rolesManager.SetCurrentEmployee(GetCurrentUserEmail()))
{
if (_rolesManager.IsStaffing())
{
var formQuestion = new FormQuestion
{
FormType = formType
};
ViewBag.ProfilePic = _rolesManager.LoggedInEmployee.ProfilePic;
ViewBag.Staffing = _rolesManager.IsStaffing();
return(View("QuestionForm", formQuestion));
}
ViewBag.ErrorMsg = "You are not authorized to view this page";
return(View("Error"));
}
ViewBag.ErrorMsg = "You are not registered on our system. Plz contact the system administrator if u think this is wrong.";
return(View("Error"));
}
public void EditQuestion(FormQuestion formQuestion)
{
var formQuestionInDb = GetQuestionById(formQuestion.Id);
formQuestionInDb.Title = formQuestion.Title;
formQuestionInDb.Description = formQuestion.Description;
_db.SaveChanges();
}
public FormQuestionViewModel(FormQuestion formQuestion = null)
{
if (formQuestion == null)
{
formQuestion = new FormQuestion();
}
this._formQuestion = formQuestion;
this._multplechoices = formQuestion.Multplechoice.Select(x => x.Option).ToList();
}
public void CreateQuestion(FormQuestion formQuestion)
{
var maxOrderInForm = 0;
try
{
maxOrderInForm = _db.FormQuestions.Where(x => x.FormType == formQuestion.FormType).Max(x => x.OrderInForm);
}
catch { /* Ignore exception (no rows in the table) */ }
formQuestion.OrderInForm = maxOrderInForm + 1;
_db.FormQuestions.Add(formQuestion);
_db.SaveChanges();
}
public ActionResult Save(FormQuestion formQuestion)
{
if (!ModelState.IsValid)
{
ViewBag.ErrorMsg = "Something went wrong with your submission. Please try again later";
return(View("Error"));
}
if (formQuestion.Id == 0)
{
_formQuestionsDataAccess.CreateQuestion(formQuestion);
}
else
{
_formQuestionsDataAccess.EditQuestion(formQuestion);
}
return(RedirectToAction("Index"));
}
public void loadContent(FormQuestion f1)
{
bool Sign = true;
int IDQuestion = 0;
while (Sign)
{
Random randomQuestion = new Random();
IDQuestion = randomQuestion.Next(0, NQuestion - 1);
Sign = Question[IDQuestion].checkSign();
}
Question[IDQuestion].changeSign();
this.recoveryQuestion(IDQuestion);
f1.Content.Text = Question[IDQuestion].getContent();
f1.AnswerA.Text = Question[IDQuestion].getAnswerA();
f1.AnswerB.Text = Question[IDQuestion].getAnswerB();
f1.AnswerC.Text = Question[IDQuestion].getAnswerC();
f1.AnswerD.Text = Question[IDQuestion].getAnswerD();
f1.TrueAnswer = Question[IDQuestion].getTrueAnswer();
if (Question[IDQuestion].Image != null)
f1.pictureBox1.BackgroundImage = Bitmap.FromFile((string)Question[IDQuestion].Image);
}
private void StackPanel_DoubleTapped(object sender, DoubleTappedRoutedEventArgs e)
{
var templateId = Int32.Parse((sender as StackPanel).Tag.ToString());
var template = inspectionViewModel.Templates.Where(t => t.Id == templateId).First();
template.Questions.ForEach(questionVM =>
{
var newModel = new FormQuestion()
{
Question = questionVM.GetModel().Question,
Instructions = questionVM.GetModel().Instructions,
Type = questionVM.GetModel().Type,
Multplechoice = questionVM.GetModel().Multplechoice.Select(x => new Multplechoice()
{
Option = x.Option
}).ToList()
};
var a = new FormQuestionViewModel(newModel);
inspectionViewModel.SelectedInspectionForm.FormQuestions.Add(a);
});
}
public async Task <int> UpdateFormQuestion(FormQuestion formQuestion)
{
string sp = StoreProcedures["UpdateFormQuestion"];
DynamicParameters parameters = new DynamicParameters();
try
{
parameters.Add("fid", formQuestion.ID, DbType.Int32);
parameters.Add("fformid", formQuestion.FormID, DbType.Int32);
parameters.Add("fquestionid", formQuestion.QuestionID, DbType.Int32);
parameters.Add("forder", formQuestion.Order, DbType.Int32);
parameters.Add("fnext", formQuestion.Next, DbType.Int32);
parameters.Add("falternativenext", formQuestion.AlternativeNext, DbType.Int32);
var result_query = await _connection.QueryAsync(sp, parameters, commandType : CommandType.StoredProcedure);
int result = 0;
if (result_query != null && result_query.Any())
{
result = Mapper.Primitive <int> .Map(result_query.FirstOrDefault());
}
return(result);
}
catch (Npgsql.PostgresException ex)
{
throw new Npgsql.NpgsqlException($"Error with database code: {ex.SqlState} msg: {ex.MessageText}");
}
catch (System.Net.Sockets.SocketException ex)
{
throw;
}
catch (Exception ex)
{
throw;
}
}
public IActionResult CreateExam(Exam examModel)
{
try
{
Exam exam = new Exam()
{
Name = examModel.Name,
CreateDate = DateTime.Now,
Article = examModel.Article
};
examRepository.CreateExam(exam);
foreach (var que in examModel.questions)
{
FormQuestion question = new FormQuestion();
question.ExamId = exam.Id;
question.QuestionText = que.QuestionText;
formQuestionRepository.CreateQuestion(question);
foreach (var opt in que.options)
{
FormQuestionOption option = new FormQuestionOption();
option.FormQuestionId = question.Id;
option.OptionText = opt.OptionText;
option.IsAnswer = opt.IsAnswer;
formQuestionOptionRepository.CreateOption(option);
}
}
return(RedirectToAction("Index", "Exam"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void DeleteQuestion(FormQuestion formQuestion)
{
_db.FormQuestions.Remove(formQuestion);
_db.SaveChanges();
RefreshQuestionsOrder(formQuestion.FormType);
}
private void ButtonStartQuiz_Click(object sender, EventArgs e)
{
var q = new FormQuestion(words);
q.Show(this);
}
public void loadContent(int IDCategory, FormQuestion f1)
{
Categories[IDCategory].loadContent(f1);
return;
}
private void SpinButton_Click(object sender, EventArgs e)
{
timer1.Enabled = !timer1.Enabled;
if (!timer1.Enabled)
{
wplayer.controls.stop();
//Bitmap bmp1;
//bmp1 = (Bitmap)Properties.Resources.test1;
//SpinningBoard.Image = (Bitmap)rotateImage(bmp1, 100);
int IDCategory = 0;
if (y >= 0 && y <= 72)
IDCategory = 0; // do - serie
else if (y > 72 && y <= 144)
IDCategory = 1; // xanh duong - cartoon
else if (y > 144 && y <= 216)
IDCategory = 2; // xam - classic
else if (y > 216 && y <= 288)
IDCategory = 3; // xang la - action
else if (y > 288 && y <= 359)
IDCategory = 4; // vang - crown
Thread.Sleep(1000);
if (IDCategory == 4)
{
ShowBadge(turn);
return;
}
form_q = new FormQuestion();
categories.loadContent(IDCategory, form_q);
this.Hide();
form_q.ShowDialog(this);
this.Show();
if (check == true)
{
team[turn] += 1;
switch (turn)
{
case 0: point1_TextChanged(sender, e); result[turn] += 2; result1.Text = Convert.ToString(result[turn]); break;
case 1: point2_TextChanged(sender, e); result[turn] += 2; result2.Text = Convert.ToString(result[turn]); break;
case 2: point3_TextChanged(sender, e); result[turn] += 2; result3.Text = Convert.ToString(result[turn]); break;
case 3: point4_TextChanged(sender, e); result[turn] += 2; result4.Text = Convert.ToString(result[turn]); break;
}
if (team[turn] == 2)
{
ShowBadge(turn);
return;
}
}
else
{
turn++;
if (turn >= 4)
{
Tour.Text = "Tour: " + ++round;
for (int i = 0; i < 4; i++)
{
if (icon[i] < 4)
result[i] -= 10;
}
result1.Text = Convert.ToString(result[0]);
result2.Text = Convert.ToString(result[1]);
result3.Text = Convert.ToString(result[2]);
result4.Text = Convert.ToString(result[3]);
if (round > 8)
Tour.Text = "Jeu terminé";
turn = 0;
}
while (Badge[turn, 0] == 1 && Badge[turn, 1] == 1 && Badge[turn, 2] == 1 && Badge[turn, 3] == 1)
{
turn++;
if (turn >= 4)
{
Tour.Text = "Tour: " + ++round;
for (int i = 0; i < 4; i++)
{
if (icon[i] < 4)
result[i] -= 10;
}
result1.Text = Convert.ToString(result[0]);
result2.Text = Convert.ToString(result[1]);
result3.Text = Convert.ToString(result[2]);
result4.Text = Convert.ToString(result[3]);
if (round > 8)
Tour.Text = "Jeu terminé";
turn = 0;
}
}
}
//Playing.Text = "Équipe: " + (turn + 1);
switch (turn)
{
case 0:
Playing.Text = "Les trois garcons chauds";
break;
case 1:
Playing.Text = "ĐAK";
break;
case 2:
Playing.Text = "Verseau";
break;
case 3:
Playing.Text = "1430";
break;
}
}
else
{
wplayer.URL = "./sound/spin.mp3";
wplayer.controls.play();
}
SavePoint();
}
public void ChooseBadge(int player)
{
team[turn] = 0;
switch (turn)
{
case 0: point1.Text = Convert.ToString(team[turn]); break;
case 1: point2.Text = Convert.ToString(team[turn]); break;
case 2: point3.Text = Convert.ToString(team[turn]); break;
case 3: point4.Text = Convert.ToString(team[turn]); break;
}
form_q = new FormQuestion();
categories.loadContent(IDBadgeChoose, form_q);
this.Hide();
form_q.ShowDialog(this);
this.Show();
if (check == true)
{
switch (player)
{
case 0: GetBadge_P0(); result[0] += 5; icon[0]++; result1.Text = Convert.ToString(result[0]); break;
case 1: GetBadge_P1(); result[1] += 5; icon[1]++; result2.Text = Convert.ToString(result[1]); break;
case 2: GetBadge_P2(); result[2] += 5; icon[2]++; result3.Text = Convert.ToString(result[2]); break;
case 3: GetBadge_P3(); result[3] += 5; icon[3]++; result4.Text = Convert.ToString(result[3]); break;
}
while (Badge[turn, 0] == 1 && Badge[turn, 1] == 1 && Badge[turn, 2] == 1 && Badge[turn, 3] == 1)
{
turn++;
if (turn >= 4)
{
Tour.Text = "Tour: " + ++round;
for (int i = 0; i < 4; i++)
{
if (icon[i] < 4)
result[i] -= 10;
}
result1.Text = Convert.ToString(result[0]);
result2.Text = Convert.ToString(result[1]);
result3.Text = Convert.ToString(result[2]);
result4.Text = Convert.ToString(result[3]);
if (round > 8)
Tour.Text = "Jeu terminé";
turn = 0;
}
}
}
else
{
turn++;
if (turn >= 4)
{
Tour.Text = "Tour: " + ++round;
for (int i = 0; i < 4; i++)
{
if (icon[i] < 4)
result[i] -= 10;
}
result1.Text = Convert.ToString(result[0]);
result2.Text = Convert.ToString(result[1]);
result3.Text = Convert.ToString(result[2]);
result4.Text = Convert.ToString(result[3]);
if (round > 8)
Tour.Text = "Jeu terminé";
turn = 0;
}
while (Badge[turn, 0] == 1 && Badge[turn, 1] == 1 && Badge[turn, 2] == 1 && Badge[turn, 3] == 1)
{
turn++;
if (turn >= 4)
{
Tour.Text = "Tour: " + ++round;
for (int i = 0; i < 4; i++)
{
if (icon[i] < 4)
result[i] -= 10;
}
result1.Text = Convert.ToString(result[0]);
result2.Text = Convert.ToString(result[1]);
result3.Text = Convert.ToString(result[2]);
result4.Text = Convert.ToString(result[3]);
if (round > 8)
Tour.Text = "Jeu terminé";
turn = 0;
}
}
}
//Playing.Text = "Équipe: " + (turn + 1);
switch (turn)
{
case 0:
Playing.Text = "Les trois garcons chauds";
break;
case 1:
Playing.Text = "ĐAK";
break;
case 2:
Playing.Text = "Verseau";
break;
case 3:
Playing.Text = "1430";
break;
}
SavePoint();
Badge0.Hide();
Badge1.Hide();
Badge2.Hide();
Badge3.Hide();
return;
}
public async Task <int> InsertFormQuestion(FormQuestion formQuestion)
{
return(await _consultingRepository.InsertFormQuestion(formQuestion));
}
public async Task <int> UpdateFormQuestion(FormQuestion formQuestion)
{
return(await _consultingRepository.UpdateFormQuestion(formQuestion));
}
