public DataModel.Questions UpdateQuestion(DataModel.Questions obj) { tblQuizQuestion Question = context.tblQuizQuestions.Where(q => q.QuestionId == obj.QuestionId).FirstOrDefault(); if (Question == null) { return(obj); } Question.QuestionId = obj.QuestionId; Question.QuizId = obj.QuizId; Question.QuestionText = obj.QuestionText; Question.IsActive = obj.IsActive; Question.UpdatedAt = DateTime.Now; Question.UpdatedBy = obj.UpdatedBy; context.Entry(Question).State = EntityState.Modified; //context.Entry(question).CurrentValues.SetValues(Question); int saved = context.SaveChanges(); if (saved > 0) { obj.UpdatedAt = Question.UpdatedAt.Value; obj.CreatedAt = Question.CreatedAt.Value; obj.Success = true; obj.ErrorMessage = "Question updated successfully."; } else { obj.UpdatedAt = Question.UpdatedAt.Value; obj.CreatedAt = Question.CreatedAt.Value; obj.Success = false; obj.ErrorMessage = "Error occured while updating question."; } return(obj); }
public DataModel.Questions Add(DataModel.Questions obj) { if (obj.QuestionId != 0) { return(UpdateQuestion(obj)); } var existing = context.tblQuizQuestions.Where(x => x.QuestionText == obj.QuestionText && x.QuizId == obj.QuizId).FirstOrDefault(); tblQuizQuestion Question = new tblQuizQuestion(); Question.QuizId = obj.QuizId; Question.QuestionText = obj.QuestionText; Question.IsActive = obj.IsActive; Question.CreatedAt = DateTime.Now; Question.CreatedBy = obj.CreatedBy; Question.UpdatedAt = DateTime.Now; if (existing != null) { obj.ErrorMessage = "Question with same text already exists"; obj.Success = false; obj.CreatedAt = Question.CreatedAt.Value; obj.UpdatedAt = Question.UpdatedAt.Value; return(obj); } context.tblQuizQuestions.Add(Question); context.SaveChanges(); //Assuming the database is generating your Id's for you obj.QuestionId = Question.QuestionId; obj.CreatedAt = Question.CreatedAt.Value; obj.UpdatedAt = Question.UpdatedAt.Value; obj.Success = true; obj.ErrorMessage = "Question saved successfully."; return(obj); }
public DataModel.Questions Update(DataModel.Questions obj) { return(null); }