public List<StatModel> GetTestStats(Guid id)
{
using (var DB = new MainContext())
{
return DB.Stats.Where(x => x.TestModel.Id == id).ToList();
}
}
public ProfessorModel GetProfessorById(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Professors.Where(x => x.Id == guid).FirstOrDefault();
}
}
public SpaceModel GetSpaceById(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Spaces.Where(x => x.Id == guid).FirstOrDefault();
}
}
public List<QuestionModel> GetTestQuestions(Guid testGuid)
{
using (var DB = new MainContext())
{
return DB.Tests.Where(x => x.Id == testGuid).FirstOrDefault().Questions.ToList();
}
}
public InfoModel GetInfoCreatedForTest(Guid testId)
{
using (var DB = new MainContext())
{
return DB.Infos.Where(x => x.Tests.FirstOrDefault().Id == testId).FirstOrDefault();
}
}
public InfoModel GetInfoById(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Infos.Where(x => x.Id == guid).FirstOrDefault();
}
}
public AnswerModel GetAnswer(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Answers.Where(x => x.Id == guid).FirstOrDefault();
}
}
public List<InfoModel> GetInfos()
{
using (var DB = new MainContext())
{
return DB.Infos.ToList();
}
}
public List<SubjectModel> GetSubjects()
{
using (var DB = new MainContext())
{
return DB.Subjects.ToList();
}
}
public SubjectModel GetSubjectById(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Subjects.Where(x => x.Id == guid).FirstOrDefault();
}
}
public List<ProfessorModel> GetProfessors()
{
using (var DB = new MainContext())
{
return DB.Professors.ToList();
}
}
public List<SpaceModel> GetSpaces()
{
using (var DB = new MainContext())
{
return DB.Spaces.ToList();
}
}
public void Delete(Guid id)
{
using (var DB = new MainContext())
{
DB.Entry(GetProfessorById(id)).State = System.Data.Entity.EntityState.Deleted;
DB.SaveChanges();
}
}
public bool Add(SpaceModel data)
{
using (var DB = new MainContext())
{
DB.Spaces.Add(data);
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(ProfessorModel data)
{
using (var DB = new MainContext())
{
DB.Professors.Add(data);
DB.SaveChanges();
return true;
}
return false;
}
public bool Add(SubjectModel model)
{
using (var DB = new MainContext())
{
DB.Subjects.Add(model);
DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged;
DB.SaveChanges();
return true;
}
return false;
}
public bool Edit(ProfessorModel data)
{
using (var DB = new MainContext())
{
DB.Professors.Attach(data);
DB.Entry(data).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return true;
}
return false;
}
private static bool CheckQuestion(QuestionModel question)
{
using (var DB = new MainContext())
{
foreach(var ans in question.Answers)
{
if (DB.Answers.Where(x => x.Id == ans.Id).FirstOrDefault().isRight != ans.isRight)
return false;
}
}
return true;
}
public bool ChangeRating(Guid TestId, int Rating)
{
using (var DB = new MainContext())
{
var test = DB.Tests.Where(x => x.Id == TestId).FirstOrDefault();
test.Rating += Rating;
DB.Entry(test).State = System.Data.Entity.EntityState.Modified;
DB.SaveChanges();
return true;
}
return false;
}
public List<SubjectModel> GetSpaceSubjects(Guid id)
{
using (var DB = new MainContext())
{
return DB.Spaces.Where(x => x.Id == id).FirstOrDefault().Subjects.Select(x => new SubjectModel()
{
Id = x.Id,
Name = x.Name,
Shortcut = x.Shortcut
}).ToList();
}
}
public bool Add(StatModel model)
{
using (var DB = new MainContext())
{
model.TestModel.Questions = null;
DB.Stats.Add(model);
DB.Entry(model.TestModel).State = System.Data.Entity.EntityState.Unchanged;
DB.SaveChanges();
return true;
}
return false;
}
/// <summary>
/// todo: implement algorythm
/// </summary>
/// <returns></returns>
public List<TestInfoModel> GetRecommendedTests()
{
using (var DB = new MainContext())
{
return DB.Tests.OrderBy(r => Guid.NewGuid()).Take(3)
.Select(t => new TestInfoModel()
{
Shortcut = t.Shortcut,
Space = t.Space.Name,
Description = t.Description,
Rating = t.Rating,
Creator = t.Creator.UserName
}).ToList();
}
}
public List<SpaceInfoModel> GetSpacesForAutocomplete(string space, string test)
{
using (var DB = new MainContext())
{
var list = DB.Spaces.AsEnumerable().Select(x => new SpaceInfoModel()
{
Id = x.Id,
Name = x.Name,
Space = x.Shortcut,
Shortcut = x.Shortcut,
}).ToList();
var spaces = list.Where(x => AutocompleteAlgorithms.Matches(x, space, test)).ToList();
return spaces;
}
}
public bool Add(TestModel model)
{
model.Creator = new UserProfile()
{
UserId = WebMatrix.WebData.WebSecurity.CurrentUserId,
UserName = WebMatrix.WebData.WebSecurity.CurrentUserName
};
using (var DB = new MainContext())
{
var context = new ValidationContext(model.Infos.First(), serviceProvider: null, items: null);
var validationResults = new List<ValidationResult>();
bool isValid = Validator.TryValidateObject(model.Infos.First(), context, validationResults, true);
if (isValid)
{
DB.Infos.Add(model.Infos.First());
DB.SaveChanges();
}
else
model.Infos.Remove(model.Infos.First());
DB.Tests.Add(model);
DB.Entry(model.Space).State = System.Data.Entity.EntityState.Unchanged;
DB.Entry(model.Subject).State = System.Data.Entity.EntityState.Unchanged;
DB.Entry(model.Creator).State = System.Data.Entity.EntityState.Unchanged;
if (model.Infos != null)
{
foreach (var infoModel in model.Infos)
{
DB.Entry(infoModel).State = System.Data.Entity.EntityState.Unchanged;
}
}
DB.SaveChanges();
return true;
}
return false;
}
public TestModel GetTestByShortcut(string @short)
{
using (var DB = new MainContext())
{
return DB.Tests.Where(x => string.Compare(x.Shortcut, @short, true) == 0).FirstOrDefault();
}
}
public List<TestInfoModel> GetTestsForAutocomplete(string space, string test)
{
using (var DB = new MainContext())
{
var list = DB.Tests.AsEnumerable().Select(x => new TestInfoModel()
{
Id = x.Id,
Name = x.Name,
Space = (x.Space != null) ? (x.Space.Shortcut) : (""),
Rating = x.Rating,
Shortcut = x.Shortcut,
Creator = x.Creator.UserName
}).ToList();
var tests = list.Where(x => AutocompleteAlgorithms.Matches(x, space, test)).ToList();
return tests;
}
}
public TestModel GetTest(Guid guid)
{
using (var DB = new MainContext())
{
return DB.Tests.Where(x => x.Id == guid).FirstOrDefault();
}
}
public ViewResult Pass(Guid Id)
{
var DB = new MainContext();
return View(DB.Tests.Where(x => x.Id == Id).FirstOrDefault());
}
//
// GET: /Space/
public ViewResult Index(Guid Id)
{
var DB = new MainContext();
return View(DB.Spaces.Where(x => x.Id == Id).FirstOrDefault());
}
