public Question AddQuestion(string Q) { DevCampDBDataContext db = new DevCampDBDataContext(); Question q = new Question(); try { q.Name = Q; db.Questions.InsertOnSubmit(q); db.SubmitChanges(); } catch { } return q; }
public Person AddUser(string U) { DevCampDBDataContext db = new DevCampDBDataContext(); User u = new User(); Person p = new Person(); try { u.Name = U; u.UserID = Guid.NewGuid(); db.Users.InsertOnSubmit(u); db.SubmitChanges(); p.Name = u.Name; p.UserID = u.UserID; } catch { } return p; }
public List<QuestionResult> GetQuestionResults() { DevCampDBDataContext db = new DevCampDBDataContext(); List<QuestionResult> questions = new List<QuestionResult>(); try { questions = (from q in db.Questions select new QuestionResult { QuestionID = ((Int32)q.QuestionID), Name = q.Name, Sum = (q.Votes.Sum(x => x.Vote1) == null) ? 0 : (int)q.Votes.Sum(x => x.Vote1), Count = q.Votes.Count() //Average = (q.Votes.Sum(x => x.Vote1)==null)?0:((0.0+(double)q.Votes.Sum(x => x.Vote1))/(0.0+q.Votes.Count)) }).ToList(); } catch { } return questions; }
public bool Vote(Int32 Q,Guid U, Int32 V) { bool result = false; DevCampDBDataContext db = new DevCampDBDataContext(); try { Vote v = new Vote(); v.QuestionID = Q; v.UserID = U; v.Vote1 = V; db.Votes.InsertOnSubmit(v); db.SubmitChanges(); result=true; } catch { } return result; }