public int Delete(int id)
{
SemesterExam item = context.SemesterExams.Where(s => s.ID == id).SingleOrDefault();
SemesterExam olditem = item;
item.status = 0;
context.Entry(item).CurrentValues.SetValues(olditem);
return(context.SaveChanges());
}
public int Update(Question t)
{
var trans = context.Database.BeginTransaction();
try
{
var currenQuestion = context.Questions.Where(s => s.Id == t.Id).SingleOrDefault();
var anserList = t.Answers.ToList();
t.Category = context.Categorys.Where(s => s.Id == t.Category.Id).SingleOrDefault();
currenQuestion.Answers = null;
currenQuestion.Category = t.Category;
currenQuestion.Content = t.Content;
currenQuestion.ExamQuestions = t.ExamQuestions;
currenQuestion.Level = t.Level;
currenQuestion.Media = t.Media;
currenQuestion.Tags = t.Tags;
currenQuestion.Type = t.Type;
currenQuestion.Suggestion = t.Suggestion;
currenQuestion.UpdatedBy = "anonymous user";
currenQuestion.UpdatedDate = DateTime.Now;
context.Entry(currenQuestion).State = EntityState.Modified;
context.Answers.RemoveRange(context.Answers.Where(s => s.Question.Id == t.Id));
var result = context.SaveChanges();
currenQuestion.Answers = t.Answers;
context.SaveChanges();
trans.Commit();
return(result);
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
}
public int Update(Exam exam)
{
var currentExam = context.Exams.Find(exam.Id);
//var currentExam = context.Exams.Find(1000);
if (currentExam.Status != true)
{
currentExam.CreateAt = DateTime.Now;
currentExam.Category = context.Categorys.SingleOrDefault(s => s.Id == exam.Category.Id);
//exam.Category = context.Categorys.Where(s => s.Id == currentExam.Category.Id).SingleOrDefault();
currentExam.NameExam = exam.NameExam;
currentExam.CreateBy = exam.CreateBy;
currentExam.QuestionNumber = exam.QuestionNumber;
currentExam.Status = exam.Status;
currentExam.SpaceQuestionNumber = exam.SpaceQuestionNumber;
//currentExam.Category.Id = exam.Category.Id;
currentExam.Note = exam.Note;
context.Entry(currentExam).State = EntityState.Modified;
return(context.SaveChanges());
}
return(0);
}
public int Update(int id, string groupname)
{
var group = context.Groups.Where(s => s.GroupId == id).SingleOrDefault();
group.EditedDate = DateTime.Now;
group.GroupName = groupname;
context.Entry(group).State = EntityState.Modified;
return(context.SaveChanges());
}
public int Update(Exam exam)
{
//exam.CreateAt=DateTime.Now;
context.Entry(exam).State = EntityState.Modified;
return context.SaveChanges();
}
public int Update(User user)
{
var currentUser = context.Users.Find(user.UserId);
currentUser.EditedDate = DateTime.Now;
currentUser.Email = user.Email;
currentUser.Role = context.Roles.Find(user.RoleId);
currentUser.RoleId = user.RoleId;
currentUser.FullName = user.FullName;
currentUser.Phone = user.Phone;
currentUser.Address = user.Address;
currentUser.Department = user.Department;
currentUser.Position = user.Position;
currentUser.Avatar = user.Avatar;
currentUser.Status = user.Status;
currentUser.Note = user.Note;
context.Entry(currentUser).State = EntityState.Modified;
return(context.SaveChanges());
}
//public IEnumerable<Test> Search(string searchString)
//{
// if (!string.IsNullOrEmpty(searchString))
// {
// return context.Tests.Where(s => s.TestName.Contains(searchString));
// }
// return context.Tests.ToList();
//}
public int Update(Test test)
{
// var item = context.Tests.Where(s => s.Id == test.Id).SingleOrDefault();
var currentTest = context.Tests.Where(s => s.Id == test.Id).SingleOrDefault();
var semasterList = test.SemesterExam;
test.Exam = context.Exams.Where(s => s.Id == test.ExamId).SingleOrDefault();
currentTest.SemesterExam = null;
currentTest.Exam = test.Exam;
currentTest.SemasterExamId = test.SemasterExamId;
currentTest.ExamId = test.ExamId;
currentTest.Status = test.Status;
currentTest.CreateBy = test.CreateBy;
currentTest.PassScore = test.PassScore;
currentTest.TestName = test.TestName;
currentTest.TotalTest = test.TotalTest;
currentTest.TestTime = test.TestTime;
context.Entry(currentTest).State = EntityState.Modified;
return(context.SaveChanges());
//throw new NotImplementedException();
}
public int Update(Role t)
{
context.Entry(t).State = EntityState.Modified;
return(context.SaveChanges());
}
public int AddMutipleQuestion(List <ExamQuestion> ListModel)
{
var check = ListModel.ElementAt(0);
var exam = context.Exams.Where(ex => ex.Id == check.ExamId).SingleOrDefault();
var countExamQuestion = context.ExamQuestions.Where(ex => ex.ExamId == exam.Id).ToList().Count();
List <ExamQuestion> list = new List <ExamQuestion>();
List <ExamQuestion> listExa = new List <ExamQuestion>();
foreach (var item in ListModel)
{
var Ques = context.Questions.Where(e => e.Category.Id == exam.Category.Id && e.Id == item.QuestionId && exam.Id == item.ExamId).SingleOrDefault();
if (Ques != null)
{
ExamQuestion ExamQues = new ExamQuestion();
ExamQues.QuestionId = Ques.Id;
ExamQues.ExamId = check.ExamId;
list.Add(ExamQues);
}
}
if (list.Count < exam.SpaceQuestionNumber - countExamQuestion)
{
for (int i = 0; i < list.Count; i++)
{
var checkModel = list.ElementAt(i).QuestionId;
var checkQuestion = context.Questions.Where(ex => ex.Id == checkModel && ex.Category.Id == exam.Category.Id)
.SingleOrDefault();
if (checkQuestion != null)
{
ExamQuestion examQuestion = new ExamQuestion();
examQuestion.ExamId = exam.Id;
examQuestion.QuestionId = checkQuestion.Id;
context.ExamQuestions.Add(examQuestion);
var currentQuestion = context.Questions.Find(examQuestion.QuestionId);
currentQuestion.Status = -3;
context.Entry(currentQuestion).State = EntityState.Modified;
//context.SaveChanges();
}
}
}
else
{
for (int i = 0; i < exam.SpaceQuestionNumber - countExamQuestion; i++)
{
var checkModel = list.ElementAt(i).QuestionId;
var checkQuestion = context.Questions.Where(ex => ex.Id == checkModel && ex.Category.Id == exam.Category.Id)
.SingleOrDefault();
if (checkQuestion != null)
{
ExamQuestion examQuestion = new ExamQuestion();
examQuestion.ExamId = exam.Id;
examQuestion.QuestionId = checkQuestion.Id;
context.ExamQuestions.Add(examQuestion);
var currentQuestion = context.Questions.Find(examQuestion.QuestionId);
currentQuestion.Status = -3;
context.Entry(currentQuestion).State = EntityState.Modified;
}
}
}
return(context.SaveChanges());
}
public int Update(Answer t)
{
context.Entry(t).State = System.Data.Entity.EntityState.Modified;
return(context.SaveChanges());
}
