public HttpResponseMessage GetAnswers(int[] qIDs) { using (Techbuzz_testEntities db = new Techbuzz_testEntities()) { var result = db.Questions .AsEnumerable() .Where(y => qIDs.Contains(y.QnID)) //.OrderBy(x => { return Array.IndexOf(qIDs, x.QnID); }) .Select(z => z.Answer) .ToArray(); return(this.Request.CreateResponse(HttpStatusCode.OK, result)); } }
public HttpResponseMessage PostQuery(USER_QUERY uq) { using (Techbuzz_testEntities db = new Techbuzz_testEntities()) { db.USER_QUERY.Add(new USER_QUERY() { FULL_NAME = uq.FULL_NAME, EMAIL_ADDRESS = uq.EMAIL_ADDRESS, USER_DESC = uq.USER_DESC }); db.SaveChanges(); } return(this.Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage GetQuestions() { using (Techbuzz_testEntities db = new Techbuzz_testEntities()) { var Qns = db.Questions .Select(x => new { QnID = x.QnID, Qn = x.Qn, ImageName = x.ImageName, x.Option1, x.Option2, x.Option3, x.Option4, QuesType = x.Ques_type, Answer = x.Answer }) //.OrderBy(y => Guid.NewGuid()) .Take(10) .ToArray(); var updated = Qns.AsEnumerable() .Select(x => new { QnID = x.QnID, Qn = x.Qn, ImageName = x.ImageName, Options = new string[] { x.Option1, x.Option2, x.Option3, x.Option4 }, QuesType = x.QuesType, Answer = x.Answer }).ToList(); return(this.Request.CreateResponse(HttpStatusCode.OK, updated)); } }
public HttpResponseMessage GetJobs() { using (Techbuzz_testEntities db = new Techbuzz_testEntities()) { var Jobs = db.JOB_POSTINGS .Select(x => new { JobId = x.JOB_ID, JobTitle = x.JOB_TITLE, JobDesc = x.JOB_DESCRIPTION, Company = x.COMPANY, Experience = x.experience, PostedBy = x.posted_by, Category = x.category, Location = x.Location }) .OrderBy(y => Guid.NewGuid()) .Take(10) .ToArray(); var updated = Jobs.AsEnumerable() .Select(x => new { JobId = x.JobId, JobTitle = x.JobTitle, JobDesc = x.JobDesc, Company = x.Company, Experience = x.Experience, PostedBy = x.PostedBy, Category = x.Category, Location = x.Location }).ToList(); return(this.Request.CreateResponse(HttpStatusCode.OK, updated)); } }