public int Delete(int id) { var group = context.Groups.Find(id); context.Groups.Remove(group); return(context.SaveChanges()); }
public int DeleteUserGroup(int iduser, int idgroup) { var del = (from a in context.UserGroups where a.UserId == iduser && a.GroupId == idgroup select a).FirstOrDefault(); context.UserGroups.Remove(del); return(context.SaveChanges()); }
public int Insert(Role t) { context.Roles.Add(new Role() { RoleName = t.RoleName, Description = t.Description }); return(context.SaveChanges()); }
public int DeleteActionRole(int idAction, int idRole) { var del = (from a in context.RoleActions where a.ActionId == idAction && a.RoleId == idRole select a).FirstOrDefault(); context.RoleActions.Remove(del); return(context.SaveChanges()); }
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 Delete(int id) { var item = context.Tags.Where(s => s.Id == id).SingleOrDefault(); if (item != null) { context.Tags.Remove(item); return(context.SaveChanges()); } return(0); }
public int Delete(int id) { var item = context.Users.Where(s => s.UserId == id).SingleOrDefault(); if (item.Status == false) { context.Users.Remove(item); return(context.SaveChanges()); } return(0); }
//----------------------------------------------Delete---------------------------------------------------------- public int DeleteCandidates(int userId, int semesterId) { if (userId != null) { var del = (from a in context.SemesterExamUsers where a.User.UserId == userId && a.SemesterExam.ID == semesterId select a).SingleOrDefault(); context.SemesterExamUsers.Remove(del); return(context.SaveChanges()); } return(0); }
public int Delete(ExamQuestion model) { var examQuestion = context.ExamQuestions.Where(eq => eq.ExamId == model.ExamId && eq.QuestionId == model.QuestionId).SingleOrDefault(); if (examQuestion != null) { context.ExamQuestions.Remove(examQuestion); return(context.SaveChanges()); } return(0); }
public int Delete(int id) { var item = context.Exams.Where(s => s.Id == id).SingleOrDefault(); if (item != null) { if (item.Status != true) { context.Exams.Remove(item); return(context.SaveChanges()); } else { } } return(0); }
public int Delete(int id) { var item = context.Categorys.Where(s => s.Id == id).SingleOrDefault(); try { if (item.Status == 0) { context.Categorys.Remove(item); return(context.SaveChanges()); } } catch { return(0); } return(0); }
public int Delete(int id) { try { var item = context.Questions.Where(s => s.Id == id).SingleOrDefault(); if (item != null) { //item.Answers = null; //context.SaveChanges(); //context.Questions.Remove(item); item.Status = -1; return(context.SaveChanges()); } return(0); } catch (Exception e) { throw e; } }
public int Insert(Role t) { context.Roles.Add(new Role()); return(context.SaveChanges()); }
public int Insert(ViewTest test) { //context.Tests.Add(test); 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()); }