public int StartSession(string user, bool isFirstLogin)
{
int count = _db.UserQuestions.Count();
int total = _db.Phrases.Count();
var currentUser = _db.Users.First();
if (total != count)
{
int minUserQuestion = _db.UserQuestions.Max(uq => uq.PhraseId);
var newPhrases = _db.Phrases.Where(p => p.PhraseId > minUserQuestion);
foreach (var phrase in newPhrases)
{
var newUserQuestion = new UserQuestions()
{
User = currentUser, Phrase = phrase
};
_db.UserQuestions.Add(newUserQuestion);
}
_db.SaveChanges();
}
return(1);
}
static void Main(string[] args)
{
ConsoleWriter writer = null;
try //BugFix #2b
{
HttpClient httpClient = new HttpClient();
JokeRepository jokeRepository = new JokeRepository(httpClient);
NameRepository nameRepository = new NameRepository(httpClient);
writer = new ConsoleWriter();
IReader reader = new ConsoleReader(writer);
UserQuestions userQuestions = new UserQuestions(reader, writer);
UserInteractions userInteractions = new UserInteractions(writer, userQuestions);
JokeService jokeService = new JokeService();
ProgramRunner programRunner = new ProgramRunner(userInteractions, jokeRepository, nameRepository, jokeService);
programRunner.Run();
}
catch (Exception)
{
if (writer != null)
{
writer.WriteLine("Something went terribly wrong.");
writer.WriteLine("Are you sure you're connected to the internet?");
}
}
}
public JsonResult SubmitAnswer(int answer)
{
int qid = (int)Session["currentQuestion"];
int correctAnswer = (from q in db.Questions
where q.QuestionId == qid
select q.Correct).FirstOrDefault();
int uid = (int)Session["currentUser"];
UserQuestions uq = (from u in db.UserQuestions
where u.UserId == uid && u.QuestionId == qid
select u).FirstOrDefault();
uq.answered += 1;
if (correctAnswer == answer)
{
uq.correct = true;
db.SaveChanges();
return(Json(new { redirectToUrl = Url.Action("AnswerCorrect", "Game") }));
//return Json(new { redirectToUrl = "http://quiz-6.apphb.com/Game/AnswerCorrect" });
}
else
{
uq.correct = false;
db.SaveChanges();
return(Json(new { redirectToUrl = Url.Action("AnswerWrong", "Game") }));
//return Json(new { redirectToUrl = "http://quiz-6.apphb.com/Game/AnswerWrong" });
}
}
private void searchAncwer(string question)
{
double minVal = 0;
int minId = -1;
List <Double> q = new List <double>();
q = token(question);
var a = (from p in model.DemandDescriptions
where p.TypeDemand.GroupDemand.SystemCollectionId == systemCollection.Id
select p).ToList();
for (int i = 0; i < a.Count; i++)
{
List <Double> answer = new List <double>();
answer = token(a[i].Description);
double rast = 0;
double znamenat1 = 0;
double znamenat2 = 0;
double cheslit = 0;
for (int o = 0; o < answer.Count; o++)
{
cheslit = q[o] * answer[o] + cheslit;
znamenat1 = Math.Pow(q[o], 2) + znamenat1;
znamenat2 = Math.Pow(answer[o], 2) + znamenat2;
}
rast = Math.Sqrt(znamenat1) * Math.Sqrt(znamenat2);
rast = Math.Abs(cheslit) / rast;
if (rast >= minVal && rast != 0)
{
minId = a[i].Id;
minVal = rast;
}
}
if (minId != -1)
{
UserQuestions userQuestions = new UserQuestions();
userQuestions.QuestionBody = question;
userQuestions.UserSystemsId = systemCollection.Id;
userQuestions.DemandDescriptionId = minId;
userQuestions.DemandDescription = model.DemandDescriptions.Find(minId);
model.UserQuestions.Add(userQuestions);
model.SaveChanges();
richTextBox1.SelectionColor = Color.Teal;
richTextBox1.AppendText(userQuestions.DemandDescription.Description);
}
else
{
UserQuestions userQuestions = new UserQuestions();
userQuestions.QuestionBody = question;
userQuestions.UserSystemsId = systemCollection.Id;
userQuestions.DemandDescriptionId = null;
model.UserQuestions.Add(userQuestions);
model.SaveChanges();
richTextBox1.SelectionColor = Color.Teal;
richTextBox1.AppendText("Нет ответа на данный вопрос");
}
}
public static DataProviderResultModel GetUserQuestions(UserInfoRequestBody userInfo)
{
DataProviderResultModel result = new DataProviderResultModel();
DataBaseOperator dbo = null;
try
{
dbo = new DataBaseOperator();
ParamCollections pc = new ParamCollections();
string sqlStr = "select id,userId, content, url, feedback, adminId, createTime, replyTime from IFUserQuestions where userId = @iUserId";
pc.Add("@iUserId", userInfo.userId);
DataTable dt = dbo.GetTable(sqlStr, pc.GetParams(true));
List <UserQuestions> list = new List <UserQuestions>();
if (null != dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
UserQuestions questions = new UserQuestions();
questions.userId = Convert.ToString(dt.Rows[i]["userId"]);
questions.id = Convert.ToString(dt.Rows[i]["id"]);
questions.content = Convert.ToString(dt.Rows[i]["content"]);
questions.feedback = Convert.ToString(dt.Rows[i]["feedback"]);
questions.createTime = Convert.ToString(dt.Rows[i]["createTime"]);
questions.replyTime = Convert.ToString(dt.Rows[i]["replyTime"]);
questions.url = Convert.ToString(dt.Rows[i]["url"]);
list.Add(questions);
}
result.data = list;
result.result = Result.SUCCESS;
}
else
{
result.result = Result.ERROR;
result.message = "The database logic error.Return data is null";
}
}
catch (Exception ex)
{
result.result = MainErrorModels.DATABASE_REQUEST_ERROR;
result.message = "The database logic error.";
Log.WriteErrorLog("v2::MineProvider::GetUserQuestions", "Error：{0}, {1}", JsonConvert.SerializeObject(userInfo), ex.Message);
}
finally
{
if (null != dbo)
{
dbo.Close();
dbo = null;
}
}
return(result);
}
public ActionResult AnswerCorrect()
{
int uid = (int)Session["currentUser"];
UserBet ub = db.UserBet.Find(uid);
int cq = (int)Session["currentQuestion"];
UserQuestions uq = (from q in db.UserQuestions
where q.QuestionId == cq && q.UserId == uid
select q).FirstOrDefault();
ub.BetAmt += 2 * uq.betAmount;
db.SaveChanges();
return(View());
}
public HttpResponseMessage PostProduct(UserQuestions item)
{
item.question = db.Questions.Find(item.QuestionId);
item.user = db.UserProfiles.Find(item.UserId);
if (item.question.Correct == item.answered)
{
item.correct = true;
}
else
{
item.correct = false;
}
item = db.UserQuestions.Add(item);
db.SaveChanges();
var response = Request.CreateResponse <UserQuestions>(HttpStatusCode.Created, item);
return(response);
}
public async Task <int> AddAsync(UserQuestions userQuestions)
{
int id = 0;
try
{
DataContext dataContext = new DataContext();
var entity = await dataContext.UserQuestions.AddAsync(userQuestions);
await dataContext.SaveChangesAsync();
id = entity.Entity.Id;
}
catch (Exception e)
{
ClassLoger.Error("UserQuestionsDal.AddAsync", e);
}
return(id);
}
public virtual void Dispose(bool disposing)
{
if (!_disposed)
{
if (disposing)
{
Answers.Dispose();
Questions.Dispose();
Results.Dispose();
Tests.Dispose();
Themes.Dispose();
UserInfoes.Dispose();
TempResults.Dispose();
UserQuestions.Dispose();
UserAnswers.Dispose();
ApplicationRoleManagers.Dispose();
ApplicationRoleManagers.Dispose();
}
_disposed = true;
}
}
public bool Post(UserQuestions changed)
{
return(impl.changeRating(changed.Id, changed.Rating));
}
public ActionResult EnterDiaryData()
{
if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
{
//Setting up the Selection for the questions
DiaryDataViewClass viewModel = new DiaryDataViewClass();
viewModel.QUESTIONSELECTION = new QuestionsSelections();
//Getting the current User for DB lookup
string userId = System.Web.HttpContext.Current.User.Identity.GetUserId();
// 20170213 Pandita: why is this maginc number 5 ???
DateTime dateStop = DateTime.UtcNow.Date.AddDays(-5);
//Looking up the questions for the user
UserQuestions userQuestion = (from table in Db.UserQuestions
where table.AspNetUserId.Equals(userId)
select table).First();
viewModel.UserQuestion = userQuestion;
//Looking up for previously saved data
// 20171023 Pandita: refactoring from LINQ-to-SQL to EF
// IEnumerable<DiaryData> dataQuery = from table in Db.DiaryData
// where table.AspNetUserId.Equals(userId) && table.DateStamp.Date == DateTime.UtcNow.Date
// select table;
var currentTime = DateTime.UtcNow.Date;
IEnumerable <DiaryData> dataQuery = from table in Db.DiaryData
where table.AspNetUserId.Equals(userId) && System.Data.Entity.DbFunctions.TruncateTime(table.DateStamp) == currentTime
select table;
bool todaysData = false;
foreach (DiaryData diaryData in dataQuery)
{
viewModel.DiaryData = diaryData;
todaysData = true;
}
if (!todaysData)
{
viewModel.DiaryData = new DiaryData()
{
AspNetUserId = userId
};
}
//Checking if the data is valid and directing to the page
if (userQuestion.AspNetUserId == userId)
{
//For AM/PM based questions - not yet fully implemented
// if (DateTime.UtcNow.AddHours(10).ToString("tt") == "AM") viewModel.Morning = true;
return(View(viewModel));
}
//Clean error Handeling - takes user back to home page - may be changes to setup later on
return(RedirectToAction("Index", "Home"));
}
else
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public async Task <int> AddAsync(UserQuestions userQuestions)
{
return(await UserQuestionsDal.Ins.AddAsync(userQuestions));
}
public JsonResult SubmitBet(int questionId, int betAmt)
{
HttpResponseMessage res;
int uid = (int)Session["currentUser"];
new LogEvent("questionId | SubmitBet " + questionId).Raise();
new LogEvent("betAmt | SubmitBet " + betAmt).Raise();
new LogEvent("uid | SubmitBet " + uid).Raise();
if (questionId != null && betAmt != null && uid != null)
{
new LogEvent("In If | SubmitBet ").Raise();
UserProfile up = (from u in db.UserProfiles
where u.UserId == uid
select u).FirstOrDefault();
//UserProfile up = db.UserProfiles.Find(uid);
new LogEvent("up | SubmitBet " + up.UserName).Raise();
//Check if the question is already in UserQuestion table
UserQuestions uq = (from u in db.UserQuestions
where u.UserId == uid && u.QuestionId == questionId
select u).FirstOrDefault();
new LogEvent("uq | SubmitBet " + uq).Raise();
//If not, create the UserQuestion
if (uq == null)
{
new LogEvent("Creating uq | SubmitBet ").Raise();
uq = new UserQuestions {
UserId = uid, QuestionId = questionId, betAmount = betAmt
};
uq.answered = 0;
uq.correct = false;
uq.question = db.Questions.Find(uq.QuestionId);
uq.question.CategoryId = uq.question.Category.CategoryId;
uq.user = up;
db.UserQuestions.Add(uq);
if (uq.question == null)
{
uq.question = db.Questions.Find(uq.QuestionId);
}
new LogEvent("Created uq | SubmitBet " + uq.QuestionId).Raise();
}
if (uq.question == null)
{
uq.question = db.Questions.Find(uq.QuestionId);
}
//check if the User and Category combo is already in the table
var query = from u in db.UserCategories
where u.UserId == uid && u.CategoryId == uq.question.CategoryId
select u;
UserCategories uc = query.FirstOrDefault();
//if not, add the user and category combo into the table
if (uc == null)
{
uc = new UserCategories {
UserId = uid, totalQuestionsAnswered = 0
};
uc.category = uq.question.Category;
uc.CategoryId = uq.question.CategoryId;
uc.user = up;
uc.totalQuestionsAnswered = 0;
db.UserCategories.Add(uc);
// db.SaveChanges();
}
//increment the answered questions in the in the user category combo
uc.totalQuestionsAnswered += 1;
//get the UserBet and subtract the betAmt for the user
UserBet ub = db.UserBet.Find(uid);
ub.BetAmt -= betAmt;
db.SaveChanges();
res = new HttpResponseMessage();
res.StatusCode = HttpStatusCode.Accepted;
new LogEvent("Working | SubmitBet").Raise();
}
else
{
res = new HttpResponseMessage();
res.StatusCode = HttpStatusCode.ExpectationFailed;
new LogEvent("Failure | SubmitBet").Raise();
}
//return RedirectToAction("ShowQuestion", "Game");
new LogEvent("coming to an end | SubmitBet").Raise();
return(Json(new { redirectToUrl = Url.Action("ShowQuestion", "Game") }));
//return Json(new { redirectToUrl = "http://quiz-6.apphb.com/Game/ShowQuestion" });
}
/// <summary>
/// 开始答题
/// </summary>
/// <returns></returns>
public async Task <IActionResult> StartAnswer()
{
QuestionsBll bll = new QuestionsBll();
var list1 = await bll.GetList(QuestionsTypeEnum.ChoiceOne, 90);
var list2 = await bll.GetList(QuestionsTypeEnum.ChoiceMore, 10);
var list3 = await bll.GetList(QuestionsTypeEnum.FillInTheBlanks, 5);
List <Questions> list = new List <Questions>();
if (list1 != null)
{
list.AddRange(list1);
}
if (list2 != null)
{
list.AddRange(list2);
}
list = list.OrderBy(x => x.Id).ToList();
UserAnswerLog log = new UserAnswerLog();
UserAnswerLogBll logBll = new UserAnswerLogBll();
log.CreateTime = DateTime.Now;
log.UserId = User.ID;
int logid = await logBll.AddAsync(log);
int index = 1;
UserQuestionsBll uqbll = new UserQuestionsBll();
OptionBll obll = new OptionBll();
List <Option> optionList = new List <Option>();
List <UserQuestions> uoList = new List <UserQuestions>();
foreach (Questions questionse in list)
{
UserQuestions userQuestions = new UserQuestions();
userQuestions.LogId = logid;
userQuestions.QIndex = index;
userQuestions.QuestionsId = questionse.Id;
userQuestions.Id = await uqbll.AddAsync(userQuestions);
index++;
var olist = await obll.GetList(questionse.Id);
if (olist != null)
{
optionList.AddRange(olist);
}
uoList.Add(userQuestions);
}
if (list3 != null)
{
foreach (Questions questionse in list3)
{
UserQuestions userQuestions = new UserQuestions();
userQuestions.LogId = logid;
userQuestions.QIndex = index;
userQuestions.QuestionsId = questionse.Id;
userQuestions.Id = await uqbll.AddAsync(userQuestions);
index++;
uoList.Add(userQuestions);
}
}
ViewBag.optionList = optionList;
list.AddRange(list3);
ViewBag.list = list;
return(View(uoList));
}
