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