public HttpResponseMessage GetTestQuestions(int userID) { var db = new afterugdevEntities3(); db.Configuration.ProxyCreationEnabled = false; var Chapter1Questions = from Questions in db.QuestionsAfterUG //where (Questions.ChapterID == 1) select new { QuestionID = Questions.QuestionID, ChapterID = Questions.ChapterID }; var NonMatchingChapter1 = (from Questions in Chapter1Questions where !db.TestChild.Any(f => f.QuestionID == Questions.QuestionID && f.UserID == userID) select new { QuestionID = Questions.QuestionID, ChapterID = Questions.ChapterID }); string json = Newtonsoft.Json.JsonConvert.SerializeObject(questionsQuery, Newtonsoft.Json.Formatting.Indented, new Newtonsoft.Json.JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore } ); return(new HttpResponseMessage() { Content = new StringContent(json, Encoding.UTF8, "application/json") }); }
// GET: api/Question public HttpResponseMessage Get() { var db = new afterugdevEntities3(); var query = (from b in db.QuestionsAfterUG select b).ToList(); return(new HttpResponseMessage() { Content = new StringContent(JArray.FromObject(query).ToString(), Encoding.UTF8, "application/json") }); }
public HttpResponseMessage Post([FromBody] List <Attempts> listOfAttempts) { var db = new afterugdevEntities3(); //List<Company> companies = new List<Company>(); //listOfAttempts.ForEach(n => db.Attempts.AddRange(n)); foreach (var attempt in listOfAttempts) { db.Attempts.Add(attempt); } try { // Your code... // Could also be before try if you know the exception occurs in SaveChanges db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { System.Diagnostics.Debug.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(new HttpResponseMessage() { Content = new StringContent("Success", Encoding.UTF8, "application/json") }); }
public HttpResponseMessage GetTestQuestions(int testNo, int userID) { var db = new afterugdevEntities3(); db.Configuration.ProxyCreationEnabled = false; var questionsQuery = (from b in db.QuestionsAfterUG.AsNoTracking() where ((b.QuestionID >= (((testNo - 1) * 5) + 1) && b.QuestionID <= (testNo * 5))) select new { b.QuestionID, b.QuestionType, b.Question, b.IsQuestionReviewed, b.IsQuestionSpinned, b.IsCorrectChoiceVerified, b.CorrectChoiceID, b.Choices, b.ForgetNotes, b.QuestionTags, b.UserAfterUGNotes, b.UserNotes, Attempts = b.Attempts.Where(a => a.UserID == userID) }).ToList(); string json = Newtonsoft.Json.JsonConvert.SerializeObject(questionsQuery, Newtonsoft.Json.Formatting.Indented, new Newtonsoft.Json.JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore } ); return(new HttpResponseMessage() { Content = new StringContent(json, Encoding.UTF8, "application/json") }); }