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