public void VerifyEmail(string id, string email)
{
using (var context = new safetyquizbotContext())
{
var user = context.UserTable.Single(e => e.Id == id);
if (user.Verified == "true")
{
SendMessage(GenericMessage("We already have your email address.\n" +
"Thanks for taking the quiz. Goodbye, and Stay Safe!", id).ToJson());
}
else
{
context.UserTable.Attach(user);
user.Email = email;
user.Verified = "true";
context.Entry(user).Property(x => x.Verified).IsModified = true;
context.Entry(user).Property(x => x.Email).IsModified = true;
context.SaveChanges();
SendMessage(GenericMessage($"Your email address has been recorded", user.Id).ToJson());
SendMessage(
GenericMessage($"Thanks for taking the quiz. Goodbye, and Stay Safe!", user.Id).ToJson());
}
}
}
public async Task ProfileInfoHandler(string ID)
{
try
{
Stopwatch stop = new Stopwatch();
stop.Start();
using (var context = new safetyquizbotContext())
{
if (context.UserTable.Where(e => e.Id == ID).Select(p => p).FirstOrDefault() == null)
{
var xt = await GetPageProfileAsync(ID);
xt.Verified = "false";
context.UserTable.Add(xt);
context.SaveChanges();
Console.WriteLine("Added ProfileInfo");
}
Console.WriteLine($"Profileinfo: {stop.Elapsed.Seconds}");
stop.Stop();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public void FinishScorecard(string PSID)
{
var context = new safetyquizbotContext();
if (context.ScoreBoard.Where(e => (e.Psid == PSID) && (e.State == Startup.BotContext.Start.ToString())).Select(p => p).LastOrDefault() != null)
{
var lastScore = context.ScoreBoard.Where(e => (e.Psid == PSID) && (e.State == Startup.BotContext.Start.ToString())).Select(p => p).LastOrDefault();
lastScore.State = Startup.BotContext.Finish.ToString();
context.SaveChanges();
Console.WriteLine("Passed Scorecard");
}
}
public void SetState(string PSID, int state, string chatcontext)
{
using (safetyquizbotContext context = new safetyquizbotContext())
{
if (context.QuizState.Where(e => e.Uid == PSID).Select(p => p).FirstOrDefault() == null)
{
context.QuizState.Add(new QuizState()
{
Uid = PSID,
LastState = -1,
CurrentContext = chatcontext
});
context.SaveChanges();
}
else
{
var user = context.QuizState.Where(e => e.Uid == PSID).Select(p => p).FirstOrDefault();
user.LastState = state;
user.CurrentContext = chatcontext;
context.SaveChanges();
Console.WriteLine("Passed context handler");
}
}
}
public void CalculateInputScore(string PSID, bool correct)
{
var context = new safetyquizbotContext();
var lastScore = context.ScoreBoard.Where(e => (e.Psid == PSID) && (e.State == Startup.BotContext.Start.ToString())).Select(p => p).LastOrDefault();
lastScore.Input++;
if (correct)
{
lastScore.CorrectTap += 1;
}
else
{
lastScore.IncorrectTap += 1;
}
context.SaveChanges();
}
public void CreateScorecard(string PSID)
{
var context = new safetyquizbotContext();
context.ScoreBoard.Add(new ScoreBoard()
{
SessionId = PSID + (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds,
Timestamp = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds,
Psid = PSID,
CorrectInput = 0,
CorrectTap = 0,
IncorrectInput = 0,
IncorrectTap = 0,
PartialInput = 0,
State = Startup.BotContext.Start.ToString(),
Tap = 0,
Input = 0
});
context.SaveChanges();
Console.WriteLine("Created Scorecard");
}
private int InsertComments(string PSID, string comment)
{
try
{
if (comment == Startup.Force_Wrong)
{
return(100);
}
else
{
using (var context = new safetyquizbotContext())
{
context.FeedBack.Add(new FeedBack()
{
FeedbackId =
PSID + (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds,
UserId = PSID,
Comment = comment
});
context.SaveChanges();
}
return(1);
}
}
catch (Exception e)
{
if (e.InnerException != null && e.InnerException.Message.Contains("Incorrect string value"))
{
return(99);
}
else
{
return(0);
}
}
}
