public int SubmitData(int id, int projectid, int userid, String data, String location, int point) { using (var db = new MyScienceEntities()) { datum submission = datum.Createdatum(id, projectid, userid, data, DateTime.Now, location); db.data.AddObject(submission); user curUser = (from auser in db.users where auser.ID == userid select auser).First(); curUser.score = curUser.score + point; int changes = db.SaveChanges(); return changes; } }
public user RegisterUser(int id, String phoneid, String name) { //check to see if the user is in the database MyScienceEntities db = new MyScienceEntities(); var query = (from userobj in db.users where userobj.name.ToLower() == name.ToLower() && userobj.phoneid == phoneid select new User { ID = userobj.ID, Name = userobj.name, Score = (int)userobj.score }); if(query.Count<User>() != 0) return null; //username already taken int idx = db.users.Count<user>() + 1; user userinfo = user.Createuser(idx, phoneid, name); userinfo.score = 0; db.users.AddObject(userinfo); int changes = db.SaveChanges(); return userinfo; }