public ChallengeController(PrepContext context, UserManager <ApplicationUser> userManager, IHttpContextAccessor accessor)
{
var usr = User ?? accessor.HttpContext.User;
var userId = userManager.GetUserId(usr);
_currentUser = context.Users.Find(userId);
_context = context;
_context.Database.SetCommandTimeout(int.MaxValue);
}
public static void ImportTrivia(string fileName, PrepContext context)
{
DataSet ds = GetDatasetFromExcel(fileName);
foreach (DataTable table in ds.Tables)
{
Score currentCatgory = (Score)Enum.Parse(typeof(Score), table.TableName.Trim());
var category = new QuestionCategory
{
CategoryName = table.TableName.Trim(),
ScoreWeight = (int)currentCatgory
};
context.QuestionCategories.Add(category);
context.SaveChanges();
foreach (DataRow row in table.Rows)
{
//3 columns of quesiton/answer pairs per sheet
var question_col1 = row[0].ToString();
var question_col2 = row[3].ToString();
var question_col3 = row[6].ToString();
var answer_col1 = row[1].ToString();
var answer_col2 = row[4].ToString();
var answer_col3 = row[7].ToString();
if (!string.IsNullOrEmpty(question_col1) && !string.IsNullOrEmpty(answer_col1))
{
var question1 = new Question
{
QuestionCategoryId = category.QuestionCategoryId,
QuestionBody = question_col1,
Answer = answer_col1.SanitizeAnswer()
};
context.Questions.Add(question1);
}
if (!string.IsNullOrEmpty(question_col2) && !string.IsNullOrEmpty(answer_col2))
{
var question2 = new Question
{
QuestionCategoryId = category.QuestionCategoryId,
QuestionBody = question_col2,
Answer = answer_col2.SanitizeAnswer()
};
context.Questions.Add(question2);
}
if (!string.IsNullOrEmpty(question_col3) && !string.IsNullOrEmpty(answer_col3))
{
var question3 = new Question
{
QuestionCategoryId = category.QuestionCategoryId,
QuestionBody = question_col3,
Answer = answer_col3.SanitizeAnswer()
};
context.Questions.Add(question3);
}
}
context.SaveChanges();
}
}
public ShopController(PrepContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
}
public UserController(PrepContext db, UserManager <ApplicationUser> userManager)
{
_db = db;
_userManager = userManager;
}
