/// <summary>
/// Checks if query exists.
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static bool queryExist(string userName)
{
RayONSEntities db = new RayONSEntities();
Guid userId = UsersDAL.getUserId(userName);
if (db.TrainerQueries.Where(s => s.UserId == userId).Count() > 0) return true;
else return false;
}
/// <summary>
/// Checks if lesson exists.
/// </summary>
/// <param name="LessonName"></param>
/// <returns></returns>
public static bool existLesson(string LessonName)
{
RayONSEntities db = new RayONSEntities();
var count = db.Lessons.Where(s => s.LessonName == LessonName).Count();
if (count > 0) return true;
else return false;
}
public ActionResult Result(int[] questions, int[] questionsIds, int QuestionsCount, int TestId)
{
if (QuestionsCount != (int)TempData["QuestionsCount"])
{
ModelState.AddModelError(String.Empty, "Грешно ID");
}
if (TestId != (int)TempData["TestId"])
{
ModelState.AddModelError(String.Empty, "Грешно ID");
}
if (ModelState.IsValid)
{
int br = 0;
int i = 0;
for (i = 0; i < QuestionsCount; i++)
{
if (questions[i] == TestsDAL.getTrueAnswer(questionsIds[i])) br += 1;
}
ViewBag.CorrectAnswers = br;
ViewBag.QuestionsCount = QuestionsCount;
RayONSEntities db = new RayONSEntities();
TestsResult testsResult = new TestsResult();
testsResult.QuestionsCount = QuestionsCount;
testsResult.Result = br;
testsResult.TestId = TestId;
testsResult.UserId = UsersDAL.getUserId(User.Identity.Name);
db.TestsResults.Add(testsResult);
db.SaveChanges();
return View();
}
else
{
return View();
}
}
/// <summary>
/// Checks if subcategory exists.
/// </summary>
/// <param name="subcategoryName"></param>
/// <returns></returns>
public static bool existSubcategory(string subcategoryName)
{
RayONSEntities db = new RayONSEntities();
int count = db.Subcategories.Where(c => c.SubcategoryName == subcategoryName).Count();
if (count == 0) return false;
else return true;
}
/// <summary>
/// Gets all queries for trainer.
/// </summary>
/// <returns></returns>
public static string[] getAllQueries()
{
RayONSEntities db = new RayONSEntities();
Guid[] ids = db.TrainerQueries.Select(s => s.UserId).ToArray();
string[] whys=db.TrainerQueries.Select(s=>s.Why).ToArray();
string[] userNames = new string[2];
foreach (var item in ids)
{
userNames[0]=UsersDAL.getUserName(item);
}
foreach (var item in whys) {
userNames[1] = item;
}
return userNames;
}
/// <summary>
/// Gets all lessons for a given subcategory.
/// </summary>
/// <param name="subcategoryId"></param>
/// <returns></returns>
public static List<Lesson> getAllLessonsForSubcategory(int subcategoryId)
{
RayONSEntities db = new RayONSEntities();
return db.Lessons.Where(l => l.SubcategoryId == subcategoryId).ToList();
}
/// <summary>
/// Gets all categories from database.
/// </summary>
/// <returns>List<Category></returns>
public static List<Category> GetAllCategories()
{
RayONSEntities db = new RayONSEntities();
return db.Categories.ToList();
}
/// <summary>
/// Gets the name of a user.
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static string getUserName(Guid userId)
{
RayONSEntities db = new RayONSEntities();
return db.Users.Where(u => u.UserId == userId).Select(u => u.UserName).First();
}
/// <summary>
/// Gets all subcategories for a given category.
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public static List<Subcategory> getAllSubcategoriesForCategory(int categoryId)
{
RayONSEntities db = new RayONSEntities();
return db.Subcategories.Where(s => s.CategoryId == categoryId).ToList();
}
/// <summary>
/// Gets the author of a lesson.
/// </summary>
/// <param name="LessonCode"></param>
/// <returns></returns>
public static string getLessonOwner(string LessonCode)
{
RayONSEntities db = new RayONSEntities();
return UsersDAL.getUserName((Guid)db.Lessons.Where(s => s.Code == LessonCode).Select(s => s.UserId).First());
}
/// <summary>
/// Gets all test results for a given user.
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public static List<TestsResult> getResultsForUser(Guid UserId)
{
RayONSEntities db = new RayONSEntities();
return db.TestsResults.Include("Test").Where(t => t.UserId == UserId).ToList();
}
/// <summary>
/// Gets all tests for a given subcategory.
/// </summary>
/// <param name="subcategoryId"></param>
/// <returns></returns>
public static List<Test> getAllTestsForSubcategory(int subcategoryId)
{
RayONSEntities db = new RayONSEntities();
return db.Tests.Where(l => l.SubcategoryId == subcategoryId).ToList();
}
/// <summary>
/// Gets all test results.
/// </summary>
/// <returns></returns>
public static List<TestsResult> getAllResults()
{
RayONSEntities db = new RayONSEntities();
return db.TestsResults.Include("Test").Include("User").ToList();
}
/// <summary>
/// Gets all questions for a given test.
/// </summary>
/// <param name="TestId"></param>
/// <returns></returns>
public static List<Question> getAllQuestionsForTest(int TestId)
{
RayONSEntities db = new RayONSEntities();
return db.Questions.Where(q => q.TestId == TestId).ToList();
}
/// <summary>
/// Checks if test exists.
/// </summary>
/// <param name="testName"></param>
/// <returns></returns>
public static bool existTest(string testName)
{
RayONSEntities db = new RayONSEntities();
if (db.Tests.Where(t => t.TestName == testName).Count() > 0) return true;
else return false;
}
/// <summary>
/// Gets the name of a lesson by id of a lesson.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string getLessonName(int id)
{
RayONSEntities db = new RayONSEntities();
return db.Lessons.Where(s => s.LessonId == id).Select(s => s.LessonName).First();
}
/// <summary>
/// Gets the name of a lesson by a code of lesson.
/// </summary>
/// <param name="LessonCode"></param>
/// <returns></returns>
public static string getLessonName(string LessonCode)
{
RayONSEntities db = new RayONSEntities();
return db.Lessons.Where(s => s.Code == LessonCode).Select(s => s.LessonName).First();
}
/// <summary>
/// Gets the name of a test.
/// </summary>
/// <param name="TestId"></param>
/// <returns></returns>
public static string getTestName(int TestId)
{
RayONSEntities db = new RayONSEntities();
return db.Tests.Where(t => t.TestId == TestId).Select(t => t.TestName).First(); ;
}
/// <summary>
/// Gets the true answer for a give question.
/// </summary>
/// <param name="QuestionId"></param>
/// <returns></returns>
public static byte getTrueAnswer(int QuestionId)
{
RayONSEntities db = new RayONSEntities();
return db.Questions.Where(q => q.QuestionId == QuestionId).Select(q => q.TrueAnswer).First();
}
public static int getFailedAttempts(Guid UserId)
{
RayONSEntities db = new RayONSEntities();
return db.Memberships.Where(m => m.UserId == UserId).Select(m => m.FailedPasswordAttemptCount).First();
}
/// <summary>
/// Gets the name of a subcategory.
/// </summary>
/// <param name="subcategoryId"></param>
/// <returns></returns>
public static string getSubcategoryName(int subcategoryId)
{
RayONSEntities db = new RayONSEntities();
return db.Subcategories.Where(s => s.SubcategoryId == subcategoryId).Select(s => s.SubcategoryName).First();
}
/// <summary>
/// Gets the user's id.
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static Guid getUserId(string username)
{
RayONSEntities db = new RayONSEntities();
return (Guid)db.Users.Where(u => u.UserName == username).Select(u => u.UserId).First();
}
