// 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();
}
}
