public List <UserGroupModel> GetListOfUserGrp()
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = (from a in context.tblUsers
join b in context.tblUserGroups on a.UserId equals b.UserId
join c in context.tblRoles on b.RoleId equals c.RoleId
join d in context.tblQuizs on a.UserId equals d.CreatedBy
select new UserGroupModel
{
UserGrpId = b.UserGrpId,
User = a.FirstName + " " + a.LastName,
Quiz = d.Title,
Role = c.RoleName,
CreatedON = b.CreatedON,
UpdatedON = b.UpdatedON
}).ToList();
//var data = context.tblUserGroups.Select(x => new UserGroupModel
//{
// UserGrpId = x.UserGrpId,
// UserId = x.UserId,
// QuizId = x.QuizId,
// RoleId = (int)x.RoleId,
// CreatedON = x.CreatedON,
// UpdatedON = x.UpdatedON
//}).ToList();
return(data);
}
}
public int CreateUserGroup(UserGroupModel UGM)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
tblUserGroup TUG = new tblUserGroup();
TUG.UserId = UGM.UserId;
TUG.QuizId = UGM.QuizId;
TUG.RoleId = UGM.RoleId;
TUG.CreatedON = UGM.CreatedON;
TUG.UpdatedON = UGM.UpdatedON;
context.tblUserGroups.Add(TUG);
context.SaveChanges();
return(TUG.UserGrpId);
}
}
catch (Exception)
{
return(0);
}
}
public List <QuizQuestionWithChoiceModel> GetQuestions(int id)
{
using (var context = new MCQ_Quiz_DBEntities())
{
var QuestionList = context.tblQuizQuestions.Where(x => x.QuizId_fk == id).ToList();
var ChoiceList = new List <DatabaseLayer.tblQuizChoice>();
foreach (var question in QuestionList)
{
ChoiceList = context.tblQuizChoices.Where(x => x.QuestionId == question.QuizQuestionId).ToList();
}
var db1 = (from a in context.tblQuizChoices
join b in context.tblQuizQuestions on a.QuestionId equals b.QuizQuestionId
join c in context.tblQuizs on b.QuizId_fk equals c.QuizId
where c.QuizId == id
select new QuizQuestionWithChoiceModel
{
QuizQuestionId = (int)a.QuestionId,
QuizId_fk = c.QuizId,
Question = b.Question,
Quiz_Choice_Id = a.Quiz_Choice_Id,
OptionTitle = a.OptionTitle
}).ToList();
return(db1);
}
}
public int Register(UserModel user)
{
using (var context = new MCQ_Quiz_DBEntities())
{
var IfEmailAlreadyExists = context.tblUsers.Where(x => x.Email_ID == user.Email_ID).FirstOrDefault();
if (IfEmailAlreadyExists == null)
{
tblUser usertbl = new tblUser
{
FirstName = user.FirstName,
MiIddleName = user.MiIddleName,
LastName = user.LastName,
BirthDate = user.BirthDate,
Email_ID = user.Email_ID,
Type = user.Type,
Password = user.Password,
City = user.City,
State = user.State,
Country = user.Country,
IsActive = user.IsActive
};
context.tblUsers.Add(usertbl);
context.SaveChanges();
return(usertbl.UserId);
}
else
{
return(-1);
}
}
}
public int AddQuiz(QuizModel quizModel)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
tblQuiz _tblQuiz = new tblQuiz();
// _tblQuiz.QuizId = quizModel.QuizId;
_tblQuiz.Title = quizModel.Title;
_tblQuiz.Summary = quizModel.Summary;
_tblQuiz.Type = quizModel.Type;
_tblQuiz.Subject = quizModel.Subject;
_tblQuiz.CreatedON = quizModel.CreatedON;
_tblQuiz.CreatedBy = quizModel.CreatedBy;
_tblQuiz.IsActive = quizModel.IsActive;
context.tblQuizs.Add(_tblQuiz);
context.SaveChanges();
return(_tblQuiz.QuizId);
}
}
catch (Exception ex)
{
return(-1);
}
}
public List <tblRole> GetAllRoles()
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = context.tblRoles.ToList();
return(data);
}
}
catch (Exception ex)
{
return(null);
}
}
public bool EditUserGroup(UserGroupModel UGM)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
var RecordToEdit = context.tblUserGroups.Where(x => x.UserGrpId == UGM.UserGrpId).FirstOrDefault();
RecordToEdit.RoleId = UGM.RoleId;
RecordToEdit.UpdatedON = UGM.UpdatedON;
context.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public List <QuizModel> QuizList()
{
using (var context = new MCQ_Quiz_DBEntities())
{
return(context.tblQuizs.Select(x => new QuizModel
{
QuizId = x.QuizId,
Title = x.Title,
Summary = x.Summary,
Type = x.Type,
Subject = x.Subject,
CreatedON = x.CreatedON,
CreatedBy = x.CreatedBy,
UpdatedON = x.UpdatedON,
UpdatedBy = x.UpdatedBy,
IsActive = x.IsActive
}).ToList());
}
}
// [CustomValidation]
public UserModel login(UserModel user)
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = context.tblUsers.Where(x => x.Email_ID == user.Email_ID && x.Password == user.Password).Select(x => new UserModel
{
UserId = x.UserId,
FirstName = x.FirstName,
LastName = x.LastName,
Email_ID = x.Email_ID
}).FirstOrDefault();
if (data != null)
{
return(data);
}
return(data);
}
}
public List <QuizModel> QuizListOfOneUser(int id)
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = (from a in context.tblQuizs
join b in context.tblQuizQuestions on
a.QuizId equals b.QuizId_fk into result
where a.CreatedBy == id select new QuizModel
{
QuizId = a.QuizId,
Title = a.Title,
Summary = a.Summary,
Type = a.Type,
Subject = a.Subject,
CreatedON = a.CreatedON,
CreatedBy = a.CreatedBy,
UpdatedON = a.UpdatedON,
UpdatedBy = a.UpdatedBy,
IsActive = a.IsActive,
TotalQuestions = result.Count() //.Question
}).ToList();
//var dd = context.tblQuizs.Where(x => x.CreatedBy == id).Select(x => new QuizModel
//{
// QuizId = x.QuizId,
// Title = x.Title,
// Summary = x.Summary,
// Type = x.Type,
// Subject = x.Subject,
// CreatedON = x.CreatedON,
// CreatedBy = x.CreatedBy,
// UpdatedON = x.UpdatedON,
// UpdatedBy = x.UpdatedBy,
// IsActive = x.IsActive
//}).ToList();
return(data);
}
}
public UserModel GetOneUser(int id)
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = context.tblUsers.Where(x => x.UserId == id).Select(x => new UserModel
{
FirstName = x.FirstName,
MiIddleName = x.MiIddleName,
LastName = x.LastName,
BirthDate = x.BirthDate,
Email_ID = x.Email_ID,
Type = x.Type,
Password = x.Password,
City = x.City,
State = x.State,
Country = x.Country,
IsActive = x.IsActive
}).FirstOrDefault();
return(data);
}
}
public List <UserModel> GetAllUser()
{
using (var context = new MCQ_Quiz_DBEntities())
{
var data = context.tblUsers.Select(x => new UserModel
{
UserId = x.UserId,
FirstName = x.FirstName,
MiIddleName = x.MiIddleName,
LastName = x.LastName,
BirthDate = x.BirthDate,
Email_ID = x.Email_ID,
Type = x.Type,
Password = x.Password,
City = x.City,
State = x.State,
Country = x.Country,
IsActive = x.IsActive
}).ToList();
return(data);
}
}
public int AddQuestion(QuizQuestionModel _quizQueModel)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
/// first add question
tblQuizQuestion question = new tblQuizQuestion();
question.QuizId_fk = _quizQueModel.QuizId_fk;
question.Question = _quizQueModel.Question;
question.Type = _quizQueModel.Type;
question.CreatedOn = _quizQueModel.CreatedOn;
question.IsActive = _quizQueModel.IsActive;
question.CreatedBy = _quizQueModel.CreatedBy;
context.tblQuizQuestions.Add(question);
context.SaveChanges();
/// second add options
//1
tblQuizChoice choice1 = new tblQuizChoice();
choice1.QuestionId = question.QuizQuestionId;
choice1.OptionTitle = _quizQueModel.option1;
choice1.CreatedON = _quizQueModel.CreatedOn;
choice1.CreatedBy = _quizQueModel.CreatedBy;
choice1.IsAnswer = false;
if (_quizQueModel.option1 == _quizQueModel.Answer)
{
choice1.IsAnswer = true;
}
context.tblQuizChoices.Add(choice1);
context.SaveChanges();
//2
tblQuizChoice choice2 = new tblQuizChoice();
choice2.QuestionId = question.QuizQuestionId;
choice2.OptionTitle = _quizQueModel.option2;
choice2.CreatedON = _quizQueModel.CreatedOn;
choice2.CreatedBy = _quizQueModel.CreatedBy;
choice2.IsAnswer = false;
if (_quizQueModel.option2 == _quizQueModel.Answer)
{
choice2.IsAnswer = true;
}
context.tblQuizChoices.Add(choice2);
context.SaveChanges();
//3
tblQuizChoice choice3 = new tblQuizChoice();
choice3.QuestionId = question.QuizQuestionId;
choice3.OptionTitle = _quizQueModel.option3;
choice3.CreatedON = _quizQueModel.CreatedOn;
choice3.CreatedBy = _quizQueModel.CreatedBy;
choice3.IsAnswer = false;
if (_quizQueModel.option3 == _quizQueModel.Answer)
{
choice3.IsAnswer = true;
}
context.tblQuizChoices.Add(choice3);
context.SaveChanges();
//4
tblQuizChoice choice4 = new tblQuizChoice();
choice4.QuestionId = question.QuizQuestionId;
choice4.OptionTitle = _quizQueModel.option4;
choice4.CreatedON = _quizQueModel.CreatedOn;
choice4.CreatedBy = _quizQueModel.CreatedBy;
choice4.IsAnswer = false;
if (_quizQueModel.option4 == _quizQueModel.Answer)
{
choice4.IsAnswer = true;
}
context.tblQuizChoices.Add(choice4);
context.SaveChanges();
return(choice4.Quiz_Choice_Id);
}
}
catch (Exception)
{
return(-1);
}
}
