private void getScore()
{
//重新答对，不计分
if (!AllStaticVariable.isAgain)
{
createPingFenItem();
pingFen.GetComponent <PingFenItem>().operate.text = "选择题： 答题正确。";
pingFen.GetComponent <PingFenItem>().score.text = "0";
MonoWay.Instance.starUp(1);
pingFen.GetComponent <PingFenItem>().gou.SetActive(true);
}
else
{
AllStaticVariable.isAgain = false;
}
GameObject correctGo = (GameObject)Instantiate(Resources.Load("Prefabs/all/Panel_right"));
correctGo.transform.parent = GameObject.Find("Canvas").transform;
correctGo.transform.localScale = Vector3.one;
correctGo.transform.localPosition = Vector3.zero;
correctGo.transform.localEulerAngles = Vector3.zero;
Button btn = correctGo.GetComponentInChildren <Button>();
btn.onClick.AddListener(() =>
{
Destroy(correctGo);
if (AllStaticVariable.isInPingFen == false)
{
QuestionBank.scorePoint6();
}
});
}
public QuestionBank GetQuestionBankDetails(int id)
{
QuestionBank existingQuestionBank = new QuestionBank();
try
{
existingQuestionBank = _questionbank_object.GetQuestionBankDetails(id);
if (existingQuestionBank != null)
{
return(existingQuestionBank);
}
else
{
throw new OASCustomException("Null data encountered.");
}
}
catch (SqlException sqlex)
{
log.Error(sqlex);
}
catch (OASCustomException customex)
{
log.Error(customex.Message);
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(existingQuestionBank);
}
public void AddQuestionTest()
{
// prerequisite method call
bool returnValue = UserAuthentication.Login(UserData.Username, UserData.Password);
// prerequisite check
Assert.IsTrue(returnValue, "\"Login\" method returns false");
User user = UserAuthentication.LoggedInUser;
Assert.IsNotNull(user, "\"LoggedInUser\" is null");
// initialization
Topic returnTopic = TopicBank.AddTopic(QuestionData.TopicName);
Assert.IsNotNull(returnTopic, "\"AddTopic\" method returns null");
// test method call
Q_Zone.Models.Question.Question question = QuestionBank.AddQuestion(returnTopic);
// initial check
Assert.IsNotNull(question, "\"AddQuestion\" method returns null");
// extended check
Assert.AreEqual(UserAuthentication.LoggedInUser, question.Owner, "Question owner is not same as created");
Assert.AreEqual(QuestionData.TopicName, question.Topic.TopicName, "Question's topic is not same as created");
// security check
UserAuthentication.Logout();
question = QuestionBank.AddQuestion(returnTopic);
Assert.IsNull(question, "\"AddQuestion\" method does not return null even after logout");
}
public int UpdateQuestionBank(QuestionBank questionBank)
{
int result = 0;
try
{
result = _questionbank_object.UpdateQuestionBank(questionBank);
if (result > 0)
{
return(result);
}
else
{
throw new OASCustomException("Operation failed.");
}
}
catch (SqlException sqlex)
{
log.Error(sqlex);
}
catch (OASCustomException customex)
{
log.Error(customex.Message);
}
catch (Exception ex)
{
log.Error(ex.Message);
}
return(result);
}
private void numItemNo_ValueChanged(object sender, EventArgs e)
{
int questionNo = (int)numItemNo.Value;
_question = _questionBankList.Where(q => q.QuestionNumber == questionNo)
.SingleOrDefault();
lblStatus.Text = string.Empty;
if (string.IsNullOrWhiteSpace(_question.Question))
{
lblStatus.Text = " Please complete this item no.";
}
txtQuestion.Text = _question.Question;
txtCorrectAnswer.Text = _question.CorrectAnswer;
txtWrongAnswer1.Text = _question.WrongAnswer1;
txtWrongAnswer2.Text = _question.WrongAnswer2;
txtWrongAnswer3.Text = _question.WrongAnswer3;
if (_frmHistory != null && _frmHistory.Visible == true)
{
SetItemHistory();
}
}
public string EditQues(QuestionsEntity questions)
{
UserSessionInfo sessionInfo = new UserSessionInfo();
int uid = sessionInfo.UserId;
object input = null;
QuestionBank qs = null;
string strResponse = string.Empty;
using (EvolutyzCornerDataEntities db = new EvolutyzCornerDataEntities())
{
qs = db.Set <QuestionBank>().Where(s => s.QBID == questions.Qid).FirstOrDefault <QuestionBank>();
// change required details in disconnected mode (out of DBContext scope)
if (qs != null)
{
qs.QBID = questions.Qid;
qs.TechnologyStackId = questions.TechnologyStackId;
qs.Question = questions.Question1;
qs.Option1 = questions.Option1;
qs.Option2 = questions.Option2;
qs.Option3 = questions.Option3;
qs.Option4 = questions.Option4;
qs.Answer = questions.Answer;
qs.CreatedDate = System.DateTime.Now;
qs.ModifiedBy = uid;
qs.ModifiedDate = System.DateTime.Now;
// db.Entry(qs).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
strResponse = "Record successfully updated";
}
return(strResponse);
}
}
//第三天检查漏做选择题
private void CheckMissChoicDay3()
{
if (!AllStaticVariable.IsDone33)
{
GameObject pingFen1 = createMissChoicePingFen();
pingFen1.GetComponent <PingFenItem>().qusetionButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint33();
});
pingFen1.GetComponent <PingFenItem>().analysisButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint33Analysis();
});
GameObject pingFen2 = createMissChoicePingFen();
pingFen2.GetComponent <PingFenItem>().qusetionButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint34();
});
pingFen2.GetComponent <PingFenItem>().analysisButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint34Analysis();
});
}
}
/// <summary>
/// 修改题库的题
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public int Update(QuestionBankinherit questionBankinherit)
{
SqlSugarClient sugarClient = Educationcontext.GetClient();
//修改题库
QuestionBank questionBank = new QuestionBank();
questionBank.Subject = questionBankinherit.Subject;
questionBank.Answer = questionBankinherit.Answer;
questionBank.Photo = questionBankinherit.Photo;
questionBank.TypeOfExam = questionBankinherit.TypeOfExam;
questionBank.Enable = questionBankinherit.Enable;
questionBank.Id = questionBankinherit.Id;
var questionBankId = questionBankinherit.Id;
var resultquestionBank = sugarClient.Updateable <QuestionBank>(questionBank).ExecuteCommand();
if (resultquestionBank != 0)
{
//修改选项
Option option = sugarClient.SqlQueryable <Option>("select * from `Option` where QuestionBankId = " + questionBankinherit.Id).First();
option.AnswerA = questionBankinherit.AnswerA;
option.AnswerB = questionBankinherit.AnswerB;
option.AnswerC = questionBankinherit.AnswerC;
option.AnswerD = questionBankinherit.AnswerD;
option.AnswerE = questionBankinherit.AnswerE;
var resultoption = sugarClient.Updateable <Option>(option).ExecuteCommand();
if (resultoption != 0)
{
return(1);
}
}
return(0);
}
/// <summary>
/// 单条添加题
/// </summary>
/// <param name="questionBank"></param>
/// <returns></returns>
public int ADD(QuestionBankinherit questionBankinherit)
{
try
{
//添加到题库
QuestionBank questionBank = new QuestionBank();
questionBank.Subject = questionBankinherit.Subject;
questionBank.Answer = questionBankinherit.Answer;
questionBank.Photo = questionBankinherit.Photo;
questionBank.TypeOfExam = questionBankinherit.TypeOfExam;
questionBank.Enable = questionBankinherit.Enable;
SqlSugarClient sugarClient = Educationcontext.GetClient();
var resultquestionBank = QuestionBankDB.Insert(questionBank);
//获取最后一个Id
questionBank = sugarClient.SqlQueryable <QuestionBank>("select id from QuestionBank order by id DESC limit 1").First();
var resultQuestionBankId = questionBank.Id;
//添加到选项
Option option = new Option();
option.QuestionBankId = resultQuestionBankId;
option.AnswerA = questionBankinherit.AnswerA;
option.AnswerB = questionBankinherit.AnswerB;
option.AnswerC = questionBankinherit.AnswerC;
option.AnswerD = questionBankinherit.AnswerD;
option.AnswerE = questionBankinherit.AnswerE;
var resultoption = OptionDB.Insert(option);
return(1);
}
catch (Exception ex)
{
//return ex.Message;
return(0);
}
}
private void BindQBList()
{
StringBuilder outHtml = new StringBuilder();
List <ActivityQuestionBankInfo> listAQB = new List <ActivityQuestionBankInfo>();
if (!Id.Equals(Guid.Empty))
{
ActivityQuestionBank bllAQB = new ActivityQuestionBank();
ParamsHelper parms = new ParamsHelper();
string sqlWhere = "and ActivityReleaseId like @ActivityReleaseId ";
SqlParameter parm = new SqlParameter("@ActivityReleaseId", SqlDbType.UniqueIdentifier);
parm.Value = Id;
parms.Add(parm);
listAQB = bllAQB.GetList(sqlWhere, parms == null ? null : parms.ToArray()).ToList();
}
QuestionBank bll = new QuestionBank();
List <QuestionBankInfo> list = bll.GetList().ToList();
foreach (QuestionBankInfo info in list)
{
int count = 0;
if (listAQB.Count > 0)
{
Guid qbId = Guid.Parse(info.Id.ToString());
ActivityQuestionBankInfo model = listAQB.Find(p => p.QuestionBankId == qbId);
count = model == null ? 0 : model.QuestionCount;
}
outHtml.AppendFormat("<div style=\"padding-top:5px\"><label>{0}</label> <input type=\"text\" id=\"{1}\" name=\"qbList\" value=\"{2}\" class=\"easyui-numberbox\"" +
"data-options=\"required:true,missingMessage:'必填项'\" style=\"width:60px\" /> 道</div>", info.Named, info.Id, count);
}
qbList.InnerHtml = outHtml.ToString();
}
public ResponseMessageExt QuestionBankImport()
{
int qbid;
if (!int.TryParse(_request.Form["QuestionBank_Id"], out qbid))
{
return(Framework.ExtJs.ResponseMessageExt.Failed("参数错误！"));
}
QuestionBank qbank = _questionBankService.GetQuestionBankById(qbid);
if (qbank == null || _request.Files.Count == 0)
{
return(Framework.ExtJs.ResponseMessageExt.Failed("数据错误！"));
}
var file = _request.Files[0];
ExcelReader ereader = new ExcelReader(file.InputStream);
string msg;
var questionlist = ereader.Read <Question>("题目", "Q_Question", out msg);
var questionitemlist = ereader.Read <QuestionItem>("选择题选项", "Q_QuestionItem", out msg);
var answerlist = ereader.Read <QuestionAnswer>("答案关联", "Q_QuestionAnswer", out msg);
foreach (var q in questionlist)
{
q.QuestionBank_Id = qbid;
q.QType = default(QuestionType).ToString();
q.AType = CommonHelper.GetEnumValueByDesc <AnswerType>(q.AType).ToString();
q.MType = CommonHelper.GetEnumValueByDesc <MatchingType>(q.MType).ToString();
q.QuestionAnswerList = answerlist.Where(x => x.Sort == q.Sort).ToList();
q.QuestionItemList = questionitemlist.Where(x => x.Sort == q.Sort).ToList();
}
_questionBankService.ImportQuestion(questionlist);
return(Wei.Web.Framework.ExtJs.ResponseMessageExt.Success());
}
private void numItemNo_ValueChanged(object sender, EventArgs e)
{
rdbTrue.Checked = false;
rdbFalse.Checked = false;
int questionNumber = (int)numItemNo.Value;
_question = _questionBankList.Where(q => q.QuestionNumber == questionNumber)
.SingleOrDefault();
lblStatus.Text = string.Empty;
if (string.IsNullOrWhiteSpace(_question.Question))
{
lblStatus.Text = " Please complete this item no.";
}
txtQuestion.Text = _question.Question;
if (_question.CorrectAnswer == "True")
{
rdbTrue.Checked = true;
}
else if (_question.CorrectAnswer == "False")
{
rdbFalse.Checked = true;
}
if (_frmHistory != null && _frmHistory.Visible == true)
{
SetItemHistory();
}
}
//题46出现
public void OccurScore46()
{
if (AllNeedUI.Instance.ZhiLiaoLeftLabel.text == "0")
{
QuestionBank.scorePoint46();
}
}
public bool AddQuestion(QuestionBankVM model)
{
if (model == null)
{
throw new Exception("There is no Entry!");
}
var addQuestion = new QuestionBank
{
Question = model.question,
CreatedBy = model.createdBy,
IsDeleted = model.isDeleted,
TestCategoryId = model.testCategoryId,
DateOfDeletion = model.dateOfDeletion,
DeletedBy = model.deletedBy,
OptionA = model.optionA,
OptionB = model.optionB
};
var que = _context.QuestionBank.Add(addQuestion);
if (_context.SaveChanges() > 0)
{
_context.QuestionOption.Add(new QuestionOption {
QuestionBankId = que.QuestionBankId, QuetionOptionName = model.optionA, OptionLabel = "A"
});
_context.QuestionOption.Add(new QuestionOption {
QuestionBankId = que.QuestionBankId, QuetionOptionName = model.optionB, OptionLabel = "B"
});
}
return(_context.SaveChanges() > 0);
}
public HttpResponseMessage PutQuestionBank(QuestionBank questionbank)
{
int result = 0;
try
{
if (ModelState.IsValid)
{
result = _blquestionbank.UpdateQuestionBank(questionbank);
if (result > 0)
{
return(Request.CreateResponse(HttpStatusCode.OK));
}
else
{
log.Error("Question bank failed to update");
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
}
else
{
log.Error("Invalid model state encountered.");
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
log.Error(ex);
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public ResponseMessageWrap <int> Update([FromBody] QuestionBank questionBank)
{
return(new ResponseMessageWrap <int>
{
Body = QuestionBankService.Update(questionBank)
});
}
private void CheckMissChoicDay8()
{
if (!AllStaticVariable.IsDone46)
{
GameObject pingFen1 = createMissChoicePingFen();
pingFen1.GetComponent <PingFenItem>().qusetionButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint46();
});
pingFen1.GetComponent <PingFenItem>().analysisButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint46Analysis();
});
}
else if (!AllStaticVariable.IsDone51)
{
GameObject pingFen1 = createMissChoicePingFen();
pingFen1.GetComponent <PingFenItem>().qusetionButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint51();
});
pingFen1.GetComponent <PingFenItem>().analysisButton.GetComponent <Button>().onClick.AddListener(() =>
{
QuestionBank.scorePoint51Analysis();
});
}
}
public ActionResult ReviewTest(string review, string testexit)
{
if (review != null)
{
List <QuestionBank> list = new List <QuestionBank>();
var varlist = Session["listOfObjects"] as List <QuestionBank>;
string selected = Session["selectedoptions"].ToString();
string[] selectedArray = selected.Split(',');
int i = 0;
foreach (var p in varlist)
{
QuestionBank obj = new QuestionBank();
obj.QuestionID = p.QuestionID;
obj.Question = p.Question;
obj.Options = p.Options;
obj.qno = p.qno;
obj.CorrectAnswer = p.CorrectAnswer;
obj.selectoptions = selectedArray[i];
list.Add(obj);
i++;
}
return(View(list));
}
else if (testexit != null)
{
return(View("TakeTest"));
}
else
{
return(View());
}
}
public bool Delete(QuestionBank question)
{
db.QuestionBanks.Remove(question);
bool isDeleted = db.SaveChanges() > 0;
return(isDeleted);
}
public bool Add(QuestionBank question)
{
db.QuestionBanks.Add(question);
bool isAdded = db.SaveChanges() > 0;
return(isAdded);
}
public static QuestionBank loadJSON(string text)
{
QuestionBank bank = JsonUtility.FromJson <QuestionBank>(text);
bank.init();
return(bank);
}
private void Bind()
{
if (!Id.Equals(Guid.Empty))
{
Page.Title = "编辑题库";
QuestionBank bll = new QuestionBank();
var model = bll.GetModel(Id);
if (model != null)
{
txtName.Value = model.Named;
hId.Value = Id.ToString();
if (model.IsDisable)
{
rdFalse.Checked = false;
rdTrue.Checked = true;
}
else
{
rdFalse.Checked = true;
rdTrue.Checked = false;
}
}
}
}
private void SetQuestionLabelText()
{
int questionId = _examineeExamList[_index].ExamineeAnswer.Skip(_questionNumber).Take(1).Single().QuestionId;
_questionBank = _questionBankList.Single(q => q.QuestionId == questionId);
lblQuestion.Text = _questionBank.Question;
}
public IActionResult DeleteQuestionBank(int id)
{
try
{
if (isAdmin)
{
QuestionBank objtblQuestionBank = _auditToolContext.QuestionBank
.Where(a => a.QuestionId == id && a.IsActive == true)
.FirstOrDefault();
objtblQuestionBank.IsActive = false;
objtblQuestionBank.ModifiedBy = _authService.LoggedInUserInfo().Result.LoggedInFullName;
objtblQuestionBank.ModifiedDate = DateTime.Now;
_auditToolContext.QuestionBank.Update(objtblQuestionBank);
_auditToolContext.SaveChanges();
return(View("Details", GetDetails()));
}
}
catch (Exception ex)
{
_logger.LogInformation($"Exception in DeleteQuestionBank method");
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "QuestionsController_DeleteQuestionBank", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
return(RedirectToAction("Index", "Home"));
}
public ResponseMessageExt UpdateQuestionBank(object obj)
{
if (obj is JObject)
{
JObject jobj = obj as JObject;
var qbviewmodel = jobj.ToObject <QuestionBankViewModel>();
QuestionBank qbmodel = this._questionBankService.GetQuestionBankById(qbviewmodel.id.ToInt());
if (qbmodel == null)
{
return(ResponseMessageExt.Failed("参数错误！"));
}
CommonHelper.UpdateT <QuestionBank>(qbmodel, jobj);
if (qbviewmodel.userattributes != null && qbviewmodel.userattributes.Length > 0)
{
string[] tmpArray = qbviewmodel.userattributes.Split(',');
foreach (var item in tmpArray)
{
int tmpid = item.ToInt();
if (qbmodel.UserAttributeList.Any(x => x.Id == tmpid))
{
continue;
}
var ua = this._userAttributeService.Get(tmpid);
qbmodel.UserAttributeList.Add(ua);
}
}
this._questionBankService.UpdateQuestionBank(qbmodel);
}
else if (obj is JArray)
{
JArray jarray = obj as JArray;
foreach (JObject jobj in jarray)
{
var qbviewmodel = jobj.ToObject <QuestionBankViewModel>();
QuestionBank qbmodel = this._questionBankService.GetQuestionBankById(qbviewmodel.id.ToInt());
if (qbmodel == null)
{
return(ResponseMessageExt.Failed("参数错误！"));
}
CommonHelper.UpdateT <QuestionBank>(qbmodel, jobj);
if (qbviewmodel.userattributes != null && qbviewmodel.userattributes.Length > 0)
{
string[] tmpArray = qbviewmodel.userattributes.Split(',');
foreach (var item in tmpArray)
{
int tmpid = item.ToInt();
if (qbmodel.UserAttributeList.Any(x => x.Id == tmpid))
{
continue;
}
var ua = this._userAttributeService.Get(tmpid);
qbmodel.UserAttributeList.Add(ua);
}
}
this._questionBankService.UpdateQuestionBank(qbmodel);
}
}
return(ResponseMessageExt.Success());
}
//关闭报告tip
IEnumerator ICloseReportTip()
{
AllNeedUI.Instance.ReportTip.SetActive(false);
yield return(new WaitForSeconds(1));
AllNeedUI.Instance.BingQingRecord.SetActive(false);
QuestionBank.scorePoint20();
}
public ActionResult DeleteConfirmed(int id)
{
QuestionBank questionBank = db.QuestionBank.Find(id);
db.QuestionBank.Remove(questionBank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/*public void CreateQuestion(QuestionBank questionBank)
* {
* if(questionBank == null){
* throw new ArgumentNullException(nameof(questionBank));
* }
* _context.Questions.Add(questionBank);
* }*/
public void DeleteQuestion(QuestionBank questionBank)
{
if (questionBank == null)
{
throw new ArgumentNullException(nameof(questionBank));
}
_context.Questions.Remove(questionBank);
}
public void CreateQuestions(QuestionBank questionBank)
{
if (questionBank == null)
{
throw new ArgumentNullException(nameof(questionBank));
}
_context.Questions.Add(questionBank);
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="entity"></param>
public void CreateQuestionBank(QuestionBank entity)
{
if (entity == null)
{
throw new System.ArgumentNullException("QuestionBank.CreateQuestionBank");
}
this._questionBankRepository.Insert(entity);
}
