public bool questionInSurvey(int id) { using (var context = new SuerveyDbContext()) { return(context.Questions.SingleOrDefault(q => q.Id == id).Surveys.Count > 0); } }
public Survey Get(int id) { using (var context = new SuerveyDbContext()) { return(context.Surveys.SingleOrDefault(s => s.Id == id && s.IsArchived == false)); } }
public bool RemoveOptionToQuestion(int optionid, int questionid) { using (var context = new SuerveyDbContext()) { var currentquestion = context.Questions.SingleOrDefault(x => x.Id == questionid); Option currentoption = null; var findoption = context.Options.SingleOrDefault(x => x.Id == optionid); if (findoption.Questions.Any(x => x.Id == questionid)) { currentoption = findoption; } if (currentoption == null || currentquestion == null) { return(false); } currentoption.Questions.Add(currentquestion); currentquestion.Options.Add(currentoption); context.SaveChanges(); return(true); } }
public ICollection <QuestionType> GetAll() { using (var context = new SuerveyDbContext()) { return(context.QuetionTypes.ToList()); } }
public ICollection <Question> GetQuestionBySurvey(int surveyid) { using (var context = new SuerveyDbContext()) { return(context.Surveys.SingleOrDefault(x => x.Id == surveyid && x.IsArchived == false).Questions.ToList()); } }
public bool RemoveQuestionToSurvey(int surveyid, int questionid) { using (var context = new SuerveyDbContext()) { var currentsurvey = context.Surveys.SingleOrDefault(x => x.Id == surveyid); Question currentquestion = null; var findquestion = context.Questions.SingleOrDefault(x => x.Id == questionid); if (findquestion.Surveys.Any(x => x.Id == surveyid)) { currentquestion = findquestion; } if (currentsurvey == null || currentquestion == null) { return(false); } currentsurvey.Questions.Remove(currentquestion); currentquestion.Surveys.Remove(currentsurvey); context.SaveChanges(); return(true); } }
public bool optionIsAssigned(int id) { using (var context = new SuerveyDbContext()) { return(context.Options.SingleOrDefault(o => o.Id == id).Questions.Count > 0); } }
public bool optionExists(string text) { using (var context = new SuerveyDbContext()) { return(context.Options.Any(o => o.Text.ToLower() == text.ToLower())); } }
public Option Get(int id) { using (var context = new SuerveyDbContext()) { return(context.Options.SingleOrDefault(s => s.Id == id)); } }
public ICollection <Option> GetOptionByQuestion(int questionid) { using (var context = new SuerveyDbContext()) { return(context.Questions.SingleOrDefault(x => x.Id == questionid).Options.ToList()); } }
public QuestionType Get(int id) { using (var context = new SuerveyDbContext()) { var result = context.QuetionTypes.SingleOrDefault(qt => qt.Id == id); return(result); } }
public Question Get(int id) { using (var context = new SuerveyDbContext()) { var question = (context.Questions.SingleOrDefault(s => s.Id == id && s.IsActive == true)); return(question); } }
public int Add(Option option) { using (var context = new SuerveyDbContext()) { option.CreatedDate = DateTime.Now; context.Options.Add(option); context.SaveChanges(); return(option.Id); } }
public int Add(Survey survey) { using (var context = new SuerveyDbContext()) { survey.CreatedDate = DateTime.Now; survey.IsArchived = false; context.Surveys.Add(survey); context.SaveChanges(); return(survey.Id); } }
public bool Delete(Option option) { using (var context = new SuerveyDbContext()) { Option currentoption = context.Options.SingleOrDefault(o => o.Id == option.Id); if (currentoption == null) { return(false); } context.Options.Remove(currentoption); context.SaveChanges(); return(true); } }
public bool Update(Option option) { using (var context = new SuerveyDbContext()) { Option oldoption = context.Options.SingleOrDefault(o => o.Id == option.Id); if (oldoption == null) { return(false); } oldoption.Text = option.Text; oldoption.ModifiedDate = DateTime.Now; context.SaveChanges(); return(true); } }
public bool Delete(Survey survey) { using (var context = new SuerveyDbContext()) { Survey currentsurvey = context.Surveys.SingleOrDefault(q => q.Id == survey.Id); if ((currentsurvey == null) || (currentsurvey.IsArchived = true)) { return(false); } currentsurvey.IsArchived = false; currentsurvey.ModifiedDate = (DateTime.Now); context.SaveChanges(); return(true); } }
public bool Delete(Question question) { using (var context = new SuerveyDbContext()) { Question currentquestion = context.Questions.SingleOrDefault(q => q.Id == question.Id); if ((currentquestion == null) || (currentquestion.IsActive = false)) { return(false); } currentquestion.IsActive = false; currentquestion.ModifiedDate = DateTime.Now; context.SaveChanges(); return(true); } }
public bool AddQuestionToSurvey(int surveyid, int questionid) { using (var context = new SuerveyDbContext()) { var currentsurvey = context.Surveys.SingleOrDefault(x => x.Id == surveyid); var currentquestion = context.Questions.SingleOrDefault(x => x.Id == questionid); if (currentsurvey == null || currentquestion == null) { return(false); } currentsurvey.Questions.Add(currentquestion); currentquestion.Surveys.Add(currentsurvey); context.SaveChanges(); return(true); } }
public bool Update(Survey survey) { using (var context = new SuerveyDbContext()) { Survey oldsurvey = context.Surveys.SingleOrDefault(s => s.Id == survey.Id); if (oldsurvey == null) { return(false); } oldsurvey.Title = survey.Title; oldsurvey.Description = survey.Description; oldsurvey.ModifiedDate = DateTime.Now; context.SaveChanges(); return(true); } }
public bool Update(Question question) { using (var context = new SuerveyDbContext()) { Question oldquestion = context.Questions.SingleOrDefault(q => q.Id == question.Id); if (oldquestion == null) { return(false); } oldquestion.Text = question.Text; oldquestion.QuestionTypeId = question.QuestionTypeId; switch (question.QuestionTypeId) { case 1: oldquestion.IsActive = true; break; case 2: if (oldquestion.Options.Count() == 2) { oldquestion.IsActive = true; } break; case 3: if (oldquestion.Options.Count() == 3) { oldquestion.IsActive = true; } break; default: oldquestion.IsActive = false; break; } oldquestion.ModifiedDate = DateTime.Now; context.SaveChanges(); return(true); } }
public int Add(Question question) { using (var context = new SuerveyDbContext()) { question.CreatedDate = DateTime.Now; if (question.QuestionTypeId == 1) { question.IsActive = true; } else { question.IsActive = false; } context.Questions.Add(question); context.SaveChanges(); return(question.Id); } }
protected override void Seed(SuerveyDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. var optYes = new Option { Id = 1, Text = "Yes", CreatedDate = DateTime.Now, ModifiedDate = null }; var optNo = new Option { Id = 2, Text = "No", CreatedDate = DateTime.Now, ModifiedDate = null }; var opt1 = new Option { Id = 3, Text = "Create, Read, Update, Delete", CreatedDate = DateTime.Now, ModifiedDate = null }; var opt2 = new Option { Id = 4, Text = "POST, Read, GET, Delete", CreatedDate = DateTime.Now, ModifiedDate = null }; var opt3 = new Option { Id = 5, Text = "SOAP, REST, WSDL, JSON", CreatedDate = DateTime.Now, ModifiedDate = null }; var opt4 = new Option { Id = 6, Text = "POST, PUT, GET, UPDATE, DELETE", CreatedDate = DateTime.Now, ModifiedDate = null }; context.Options.AddOrUpdate(optYes, optNo, opt1, opt2, opt3, opt4); context.QuetionTypes.AddOrUpdate( new QuestionType { Id = 1, Description = "Open", CreatedDate = DateTime.Now, ModifiedDate = null }, new QuestionType { Id = 2, Description = "Dichotomous", CreatedDate = DateTime.Now, ModifiedDate = null }, new QuestionType { Id = 3, Description = "Multiple", CreatedDate = DateTime.Now, ModifiedDate = null } ); var question1 = new Question { Id = 1, Text = "What is a Web Service?", QuestionTypeId = 1, IsActive = true, CreatedDate = DateTime.Now, ModifiedDate = null }; var question2 = new Question { Id = 2, Text = "Is SOAP a design patten for Software Development?", QuestionTypeId = 2, IsActive = true, CreatedDate = DateTime.Now, ModifiedDate = null }; question2.Options.Add(optYes); question2.Options.Add(optNo); var question3 = new Question { Id = 3, Text = "What are the main Http Methods used by RESTful APIs?", QuestionTypeId = 3, IsActive = true, CreatedDate = DateTime.Now, ModifiedDate = null }; question3.Options.Add(opt1); question3.Options.Add(opt2); question3.Options.Add(opt3); question3.Options.Add(opt4); context.Questions.AddOrUpdate(question1, question2, question3); Survey survey = new Survey { Id = 1, Title = ".NET Academy 2018 - Web Service Module", Description = "Evaluate the acquired knowledge during the web service module.", IsArchived = false, CreatedDate = DateTime.Now, ModifiedDate = null }; survey.Questions.Add(question1); survey.Questions.Add(question2); survey.Questions.Add(question3); context.Surveys.AddOrUpdate(survey); }