// Post Score public void PostNewScore(JToken myJson) { try { MG_User TargetUser = db.MG_Users.Single(x => x.IdFacebook.Equals(myJson["idfacebook"].ToString())); MG_Score newScore = new MG_Score(); newScore.IdUser = TargetUser.IdUser; newScore.Score = Convert.ToInt32(myJson["score"].ToString()); newScore.Time = Convert.ToInt32(myJson["time"].ToString()); db.MG_Scores.InsertOnSubmit(newScore); db.SubmitChanges(); TargetUser = db.MG_Users.Single(x => x.IdFacebook.Equals(myJson["idfacebook"].ToString())); int TotalScore = 0; for (int i = 0; i < TargetUser.MG_Scores.Count; i++) { TotalScore += Convert.ToInt32(TargetUser.MG_Scores[i].Score); } TargetUser.AverageScore = (float)TotalScore / TargetUser.MG_Scores.Count; db.SubmitChanges(); NotificationHelper.CreateNotification("You have new score: " + newScore.Score + "! "); } catch { } }
public void PostWinLose(bool isWin, string idfacebook) { MG_User TargetUser = db.MG_Users.Single(x => x.IdFacebook == idfacebook); if (isWin) { TargetUser.Win++; } else { TargetUser.Lose++; } db.SubmitChanges(); }
private string ParseStringUser(MG_User p) { if (p == null) { return("{}"); } string body = "{\nidUser:"******", \nname:'" + p.Name.Trim() + "', \nlinkfacebook:'" + p.LinkFacebook.ToString() + "', \nidfacebook:'" + p.IdFacebook.ToString() + "', \nuserimage:'" + p.UserImage.ToString() + "', \naveragescore:" + p.AverageScore.ToString() + "\n}"; return(body); }
public void PostNewUser(JToken myJson) { MG_User newUser = new MG_User(); newUser.Name = myJson["name"].ToString(); newUser.IdFacebook = myJson["idfacebook"].ToString(); newUser.AccessToken = myJson["token"].ToString(); bool isHave = false; try { MG_User temp = db.MG_Users.Single(x => x.IdFacebook == newUser.IdFacebook); temp.AccessToken = myJson["token"].ToString(); db.SubmitChanges(); isHave = true; } catch { } string str_message = string.Empty; if (isHave) { NotificationHelper.CreateNotification("Welcome " + newUser.Name + ", come back Music Game! "); } else { NotificationHelper.CreateNotification("Welcome " + newUser.Name + ", come to with Music Game! "); newUser.LinkFacebook = myJson["linkfacebook"].ToString(); newUser.UserImage = ""; newUser.AverageScore = 0.0f; db.MG_Users.InsertOnSubmit(newUser); db.SubmitChanges(); } }