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()); }