public ActionResult Edit([Bind(Include = "QuesterID,FCategoryID,FQUserID,Question,Answer,Hint,AdditionalInfo,IsShareOnline,IsFavourite,IsSkip,Appearance,WAppearance,Score")] Quester quester, bool chkShare)
{
if (ModelState.IsValid)
{
ViewBag.chkShare = chkShare;
if (chkShare)
{
quester.IsShareOnline = true;
}
else
{
quester.IsShareOnline = false;
}
quester.FQUserID = userid;
ViewBag.FCategoryID = new SelectList(db.Categories, "CategoryID", "Name", quester.FCategoryID);
db.Entry(quester).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.FQUserID = new SelectList(db.Users, "UserID", "Forename", quester.FQUserID);
// ViewBag.FCategoryID = new SelectList(db.Categories, "CategoryID", "Name");
return(View(quester));
}
public ActionResult SaveDatabase(int[] IDs)
{
if (IDs != null)
{
//var countOfRows = db.WTests.Count();
//var lastRow = db.WTests.Skip(countOfRows - 1).FirstOrDefault();
// var last = db.WTests.LastOrDefault();
Quester Qt = new Quester();
for (int j = 0; j < IDs.Length; j++)
{
var id = IDs[j];
var r = (from t in db.Questers
where t.QuesterID == id
select t).FirstOrDefault();
Qt.Question = r.Question;
Qt.Answer = r.Answer;
Qt.Hint = r.Hint;
Qt.AdditionalInfo = r.AdditionalInfo;
Qt.FQUserID = userid; //Wr.FWuserid=Session["userID"]
db.Questers.Add(Qt);
db.SaveChanges();
}
return(RedirectToAction("Index", "Quester"));
}
return(View());
}
// GET: Quester/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Quester quester = db.Questers.Find(id);
if (quester.IsShareOnline == true)
{
ViewBag.chkShare = true;
}
else
{
ViewBag.chkShare = false;
}
if (quester == null)
{
return(HttpNotFound());
}
ViewBag.FCategoryID = new SelectList(db.Categories, "CategoryID", "Name", quester.FCategoryID);
//ViewBag.FQUserID = new SelectList(db.Users, "UserID", "Forename", quester.FQUserID);
// ViewBag.FCategoryID = new SelectList(db.Categories, "CategoryID", "Name");
return(View(quester));
}
public ActionResult Create([Bind(Include = "QuesterID,FCategoryID,FQUserID,Question,Answer,Hint,AdditionalInfo,IsShareOnline,IsFavourite,IsSkip,Appearance,WAppearance,Score")] Quester quester, bool checkResp = false)
{
if (ModelState.IsValid)
{
if (Session["UserID"] != null)
{
if (checkResp == true)
{
quester.IsShareOnline = true;
}
else
{
quester.IsShareOnline = false;
}
quester.FQUserID = userid;
db.Questers.Add(quester);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.FCategoryID = new SelectList(db.Categories, "CategoryID", "Name", quester.FCategoryID);
//ViewBag.FQUserID = new SelectList(db.Users, "UserID", "Forename", quester.FQUserID);
return(View(quester));
}
public void Setup(QuestRequirement req, Quester quester)
{
requirement = req;
requirement.OnQuestRequirementUpdated += UpdateRequirementDescription;
requirement.OnQuestRequirementCompleted += Complete;
SetText(requirement.GetDescription);
this.quester = quester;
}
public ActionResult DeleteConfirmed(int id)
{
Quester quester = db.Questers.Find(id);
db.Questers.Remove(quester);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void SetUpNewQuester(Quester newQuester)
{
if (newQuester == null)
{
return;
}
ShowQuest(newQuester.TopPriorityQuest);
quester.OnTopPriorityQuestSet += ShowQuest;
}
public static void SetQuester(Quester newQuester)
{
if (newQuester == null)
{
return;
}
quester = newQuester;
OnQuesterSet?.Invoke(newQuester);
}
// GET: Quester/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Quester quester = db.Questers.Find(id);
if (quester == null)
{
return(HttpNotFound());
}
return(View(quester));
}
public virtual void GiveReward(Quester c)
{
}
private void ActionReward(Quester c) => OnActionReward?.Invoke(c);
public override void GiveReward(Quester c)
{
ActionReward(c);
}
private void GiveQuest(Quester quester, Quest q) => quester.AcceptQuest(q);
//public ActionResult Testhome()
//{
// //if (Session["Rem_Time"] == null)
// //{
// // Session["Rem_Time"] = DateTime.Now.AddMinutes(0.5).ToString("dd-MM-yyyy h:mm:ss tt");
// //}
// //ViewBag.Rem_Time = Session["Rem_Time"];
// //int testID = ViewBag.TestID;
// ViewBag.Message = "Modify this template to jump-start your MVC application.";
// return View();
//}
// WTest start tomorrow, send data to answer view wothout timer
public ActionResult Answer(int?id)
{
var r = (from t in db.QTests
where t.FQTuserID == userid
orderby t.QTestID descending
select t).First();
double time = Convert.ToDouble(r.Score);
bool minute = r.TestTime ?? false;
bool second = r.TimePerWord ?? false;
if (minute == true)
{
if (Session["EndDate"] == null)
{
Session["EndDate"] = DateTime.Now.AddMinutes(time).ToString("dd-MM-yyyy h:mm:ss tt");
}
}
else if (second == true)
{
Session["EndDate"] = DateTime.Now.AddSeconds(time).ToString("dd-MM-yyyy h:mm:ss tt");
}
// Session["EndDate"] = DateTime.Now.AddMinutes(minute).ToString("dd-MM-yyyy h:mm:ss tt");
ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";
ViewBag.EndDate = Session["EndDate"];
int value = id ?? default(int);
if (value == 1)
{
int wid = fwords[true_count];
QuestTest wt = db.QuestTests.Where(t => (t.FQuesterID == wid) && (t.FQTestID == r.QTestID)).FirstOrDefault();
wt.Result = true;
db.SaveChanges();
true_count = true_count + 1;
}
// var d = db.WordTests.Where(t => t.FWtestID==1).FirstOrDefault(); // working
//int turnfirst = 0;
if (turnfirst == 0)
{
v = 0;
//testid = (from t in db.WTests
// orderby t.WTestID descending
// select t.WTestID).First();
Quester w = new Quester();
var IDs = db.QuestTests.Where(t => t.FQTestID == r.QTestID).ToArray().Select(t => t.FQuesterID);
int index = 0;
k = IDs.Count(); // k = total no words
foreach (var c in IDs)
{
w = db.Questers.Find(c);
definitions[index] = w.Answer;
hint[index] = w.Hint;
wordlist[index] = w.Question;
fwords[index] = w.QuesterID;
index = index + 1;
}
turnfirst = 1;
}
if (v < k)
{
ViewBag.Definition = definitions[v];
ViewBag.Hint = hint[v];
ViewBag.Word = wordlist[v];
v = v + 1;
}
else
{
ViewBag.Status = "complete";
ViewBag.EndDate = null;
return(RedirectToAction("Result", new { id = r.QTestID }));
}
return(View());
}
