public kbdataContext GetCurrentDataContext()
{
var options = new DbContextOptionsBuilder <kbdataContext>()
.UseSqlite(DBConnection, action =>
{
action.UseRelationalNulls();
})
.UseQueryTrackingBehavior(QueryTrackingBehavior.TrackAll)
.EnableSensitiveDataLogging()
.Options;
var context = new kbdataContext(options, true);
return(context);
}
public AwardRulesController(kbdataContext context)
{
_context = context;
}
public UserHabitPointReportsController(kbdataContext context)
{
_context = context;
}
public ExerciseItemAnswersController(kbdataContext context)
{
_context = context;
}
internal static void DeleteKnowledgeItem(kbdataContext context, int kid)
{
context.Database.ExecuteSqlRaw("DELETE FROM KnowledgeItem WHERE ID = " + kid.ToString());
}
public UserHabitPointsByUserDatesController(kbdataContext context)
{
_context = context;
}
public KnowledgeItemsController(kbdataContext context)
{
_context = context;
}
public InvitedUsersController(kbdataContext context)
{
_context = context;
}
public AwardPointReportsController(kbdataContext context)
{
_context = context;
}
//public static void CreateInviteUser(kbdataContext context, String supervisor, String testUser)
//{
// // Add Invited User
// //
// InvitedUser usr = new InvitedUser();
// usr.DisplayAs = supervisor;
// usr.InvitationCode = supervisor;
// usr.UserID = supervisor;
// usr.UserName = supervisor;
// context.InvitedUsers.Add(usr);
// usr = new InvitedUser();
// usr.DisplayAs = testUser;
// usr.InvitationCode = testUser;
// usr.UserID = testUser;
// usr.UserName = testUser;
// context.InvitedUsers.Add(usr);
// AwardUser aus = new AwardUser();
// aus.Supervisor = supervisor;
// aus.TargetUser = testUser;
// context.AwardUsers.Add(aus);
//}
//public static void DeleteInviteUser(kbdataContext context, String supervisor, String testUser)
//{
// context.Database.ExecuteSqlRaw("DELETE FROM InvitedUser WHERE UserID = '" + supervisor + "'");
// context.Database.ExecuteSqlRaw("DELETE FROM InvitedUser WHERE UserID = '" + testUser + "'");
// context.Database.ExecuteSqlRaw("DELETE FROM AwardUser WHERE Supervisor = '" + supervisor + "' AND TargetUser = '******'");
//}
public static void DeleteUserHabit(kbdataContext context, int habitid)
{
context.Database.ExecuteSqlRaw("DELETE FROM UserHabit WHERE ID = " + habitid.ToString());
}
public static void ClearUserHabitData(kbdataContext context, Int32 habitID)
{
context.Database.ExecuteSqlRaw("DELETE FROM UserHabit WHERE ID = " + habitID);
}
public static void DeleteUserCollection(kbdataContext context, int cid)
{
context.Database.ExecuteSqlRaw("DELETE FROM UserCollection WHERE ID = " + cid.ToString());
}
public static void DeleteExerciseItem(kbdataContext context, int eid)
{
context.Database.ExecuteSqlRaw("DELETE FROM ExerciseItem WHERE ID = " + eid.ToString());
}
public static void InitalizeTestData(kbdataContext context)
{
#region Invite users
context.InvitedUsers.Add(new InvitedUser
{
DisplayAs = "User A",
InvitationCode = "User A Invit",
UserID = UserA,
UserName = "******",
});
context.InvitedUsers.Add(new InvitedUser
{
DisplayAs = "User B",
InvitationCode = "User B Invit",
UserID = UserB,
UserName = "******",
});
#endregion
#region Award users
context.AwardUsers.Add(new AwardUser
{
Supervisor = UserA,
TargetUser = UserB,
});
#endregion
#region Knowledge items
context.KnowledgeItems.Add(new KnowledgeItem
{
ID = Knowledge1ID,
Category = KnowledgeItemCategory.Concept,
Title = "Knowledge 1",
Content = "Knowledge 1 Content"
});
context.KnowledgeItems.Add(new KnowledgeItem
{
ID = Knowledge2ID,
Category = KnowledgeItemCategory.Concept,
Title = "Knowledge 2",
Content = "Knowledge 2 Content"
});
context.KnowledgeTags.Add(new KnowledgeTag
{
RefID = Knowledge1ID,
TagTerm = Tag1
});
context.KnowledgeTags.Add(new KnowledgeTag
{
RefID = Knowledge2ID,
TagTerm = Tag2
});
#endregion
#region Exercise items
context.ExerciseItems.Add(new ExerciseItem
{
ID = Exercise1ID,
ExerciseType = ExerciseItemType.Question,
Content = "Exercise 1"
});
context.ExerciseItems.Add(new ExerciseItem
{
ID = Exercise2ID,
ExerciseType = ExerciseItemType.Question,
Content = "Exercise 2"
});
context.ExerciseItemAnswers.Add(new ExerciseItemAnswer
{
ID = Exercise1ID,
Content = "Answer for Exercise 1"
});
context.ExerciseItemAnswers.Add(new ExerciseItemAnswer
{
ID = Exercise2ID,
Content = "Answer for Exercise 2"
});
context.ExerciseTags.Add(new ExerciseTag
{
RefID = Exercise1ID,
TagTerm = Tag1
});
context.ExerciseTags.Add(new ExerciseTag
{
RefID = Exercise1ID,
TagTerm = Tag2
});
context.ExerciseTags.Add(new ExerciseTag
{
RefID = Exercise2ID,
TagTerm = Tag1
});
#endregion
context.SaveChanges();
}
public DailyTracesController(kbdataContext context)
{
_context = context;
}
public ExerciseTagsController(kbdataContext context)
{
_context = context;
}
public UserCollectionItemsController(kbdataContext context)
{
_context = context;
}
public KnowledgeItemWithTagViewsController(kbdataContext context)
{
_context = context;
}
public UserHabitRecordsController(kbdataContext context)
{
_context = context;
}
public OverviewInfosController(kbdataContext context)
{
_context = context;
}
public TagsController(kbdataContext context)
{
_context = context;
}
public ExerciseItemWithTagViewsController(kbdataContext context)
{
_context = context;
}
public TagCountByRefTypesController(kbdataContext context)
{
_context = context;
}
public static void ReinitializeDbForTests(kbdataContext db)
{
// db.Messages.RemoveRange(db.Messages);
InitializeDbForTests(db);
}
internal static void DeleteAwardData(kbdataContext context)
{
context.Database.ExecuteSqlRaw("DELETE FROM AwardRule WHERE ID > 0 ");
context.Database.ExecuteSqlRaw("DELETE FROM AwardPoint WHERE ID > 0 ");
context.Database.ExecuteSqlRaw("DELETE FROM DailyTrace WHERE TargetUser IS NOT NULL");
}
public static void InitializeDbForTests(kbdataContext db)
{
// db.Messages.AddRange(GetSeedingMessages());
db.SaveChanges();
}
public AwardUserViewsController(kbdataContext context)
{
_context = context;
}
public ExerciseItemUserScoresController(kbdataContext context)
{
_context = context;
}
