public void updateQuestion(Question q)
{
using (var db = new MedTrainDBContext())
{
db.Entry(q).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void updateGroupMember(GroupMember gm)
{
using (var db = new MedTrainDBContext())
{
db.Entry(gm).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void updateUserLevel(UserLevel ul)
{
using (var db = new MedTrainDBContext())
{
db.Entry(ul).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void removeGroup(Group g)
{
using (var db = new MedTrainDBContext())
{
Group group = db.Groups.Find(g.AdminId, g.name);
db.Groups.Remove(group);
db.SaveChanges();
}
}
public void addImage(QuestionImage i)
{
using (var db = new MedTrainDBContext())
{
if (db.Questions.Find(i.QuestionId) == null || db.Images.Find(i.ImageId, i.QuestionId) != null)
{
return;
}
db.Images.Add(i);
db.SaveChanges();
}
}
public void addQuestion(Question q)
{
using (var db = new MedTrainDBContext())
{
if (db.Questions.Find(q.QuestionId) != null)
{
return;
}
db.Questions.Add(q);
db.SaveChanges();
}
}
public void addTopic(Topic t)
{
using (var db = new MedTrainDBContext())
{
if (db.Subjects.Find(t.SubjectId) == null || db.Topics.Find(t.TopicId, t.SubjectId) != null)
{
return;
}
db.Topics.Add(t);
db.SaveChanges();
}
}
public void addUser(User u)
{
using (var db = new MedTrainDBContext())
{
if (db.Users.Find(u.UserId) != null)
{
return;
}
db.Users.Add(u);
db.SaveChanges();
}
}
public void addGroup(Group g)
{
using (var db = new MedTrainDBContext())
{
if (db.Admins.Find(g.AdminId) == null || db.Groups.Find(g.AdminId, g.name) != null)
{
return;
}
db.Groups.Add(g);
db.SaveChanges();
}
}
public void addTest(Test t)
{
using (var db = new MedTrainDBContext())
{
if (db.Admins.Find(t.AdminId) == null || db.Subjects.Find(t.subject) == null || db.Tests.Find(t.TestId) != null)
{
return;
}
db.Tests.Add(t);
db.SaveChanges();
}
}
public void addGroupMember(GroupMember gm)
{
using (var db = new MedTrainDBContext())
{
if (db.Groups.Find(gm.AdminId, gm.GroupName) == null || db.GroupsMembers.Find(gm.GroupName, gm.AdminId, gm.UserId) != null)
{
return;
}
db.GroupsMembers.Add(gm);
db.SaveChanges();
}
}
public void addUserLevel(UserLevel ul)
{
using (var db = new MedTrainDBContext())
{
if (db.UsersLevels.Find(ul.UserId, ul.TopicId, ul.SubjectId) != null)
{
return;
}
db.UsersLevels.Add(ul);
db.SaveChanges();
}
}
public void addTestQuestion(TestQuestion tq)
{
using (var db = new MedTrainDBContext())
{
if (db.Tests.Find(tq.TestId) == null || db.Questions.Find(tq.QuestionId) == null ||
db.Questions.Find(tq.QuestionId).isDeleted || db.TestsQuestions.Find(tq.TestId, tq.QuestionId) != null)
{
return;
}
db.TestsQuestions.Add(tq);
db.SaveChanges();
}
}
public void addGroupTest(GroupTest gt)
{
using (var db = new MedTrainDBContext())
{
if (db.Admins.Find(gt.AdminId) == null || db.Groups.Find(gt.AdminId, gt.GroupName) == null ||
db.Tests.Find(gt.TestId) == null || db.GroupsTests.Find(gt.AdminId, gt.GroupName, gt.TestId) != null)
{
return;
}
db.GroupsTests.Add(gt);
db.SaveChanges();
}
}
public void addDiagnosis(Diagnosis d)
{
using (var db = new MedTrainDBContext())
{
if (db.Subjects.Find(d.SubjectId) == null || db.Topics.Find(d.TopicId, d.SubjectId) == null ||
db.Questions.Find(d.QuestionId) == null || db.Diagnoses.Find(d.TopicId, d.SubjectId, d.QuestionId) != null)
{
return;
}
db.Diagnoses.Add(d);
db.SaveChanges();
}
}
public void addAdmin(Admin a)
{
using (var db = new MedTrainDBContext())
{
if (db.Users.Find(a.AdminId) == null || db.Admins.Find(a.AdminId) != null)
{
return;
}
db.Admins.Add(new Admin {
AdminId = a.AdminId
});
db.SaveChanges();
}
}
public void removeGroupTestAnswers(string groupName, string adminId)
{
using (var db = new MedTrainDBContext())
{
var query = from gta in db.GroupsTestsAnswers
where gta.GroupName.Equals(groupName) && gta.AdminId.Equals(adminId)
select gta;
foreach (GroupTestAnswer gta in query)
{
db.GroupsTestsAnswers.Remove(gta);
}
db.SaveChanges();
}
}
public void addSubject(Subject s)
{
using (var db = new MedTrainDBContext())
{
if (db.Subjects.Find(s.SubjectId) != null)
{
return;
}
db.Subjects.Add(new Subject {
SubjectId = s.SubjectId, timeAdded = DateTime.Now
});
db.SaveChanges();
}
}
public void addUserLevelAnwer(UserLevelAnswer ula)
{
using (var db = new MedTrainDBContext())
{
if (db.Answers.Find(ula.AnswerId) == null || db.Subjects.Find(ula.SubjectId) == null ||
db.Topics.Find(ula.TopicId, ula.SubjectId) == null ||
db.UsersLevelsWhenAnswring.Find(ula.AnswerId, ula.TopicId, ula.SubjectId) != null)
{
return;
}
db.UsersLevelsWhenAnswring.Add(ula);
db.SaveChanges();
}
}
public void addDiagnosisCertainty(DiagnosisCertainty dc)
{
using (var db = new MedTrainDBContext())
{
if (db.Answers.Find(dc.AnswerId) == null || db.Subjects.Find(dc.SubjectId) == null ||
db.Topics.Find(dc.TopicId, dc.SubjectId) == null ||
db.DiagnosesCertainties.Find(dc.AnswerId, dc.TopicId, dc.SubjectId) != null)
{
return;
}
db.DiagnosesCertainties.Add(dc);
db.SaveChanges();
}
}
public void addGroupTestAnswer(GroupTestAnswer gta)
{
using (var db = new MedTrainDBContext())
{
if (db.Users.Find(gta.UserId) == null || db.Admins.Find(gta.AdminId) == null ||
db.Groups.Find(gta.AdminId, gta.GroupName) == null || db.Tests.Find(gta.TestId) == null ||
db.Answers.Find(gta.AnswerId) == null ||
db.GroupsTestsAnswers.Find(gta.GroupName, gta.AdminId, gta.TestId, gta.AnswerId) != null)
{
return;
}
db.GroupsTestsAnswers.Add(gta);
db.SaveChanges();
}
}
public void addAnswer(Answer a)
{
using (var db = new MedTrainDBContext())
{
if (db.Questions.Find(a.QuestionId) == null || db.Users.Find(a.UserId) == null ||
db.Answers.Find(a.AnswerId) != null)
{
return;
}
var query = from ans in db.Answers
where ans.QuestionId == a.QuestionId && ans.UserId.Equals(a.UserId) &&
ans.timeAdded.Equals(a.timeAdded)
select ans;
if (query.ToList().Count != 0)
{
return;
}
db.Answers.Add(a);
db.SaveChanges();
}
}
