public GameScoreTabel GetGameScore(string _uname)
{
// bool updateResult = false;
GameScoreTabel gsModel = new GameScoreTabel();
UserTabelBaseDAL uDAL = new UserTabelBaseDAL();
UserTabel user = new UserTabel();
user = uDAL.GetOneByWhere(u => u.userName == _uname);
if (user != null)
{
GameScoreTabelBaseDAL gsDAL = new GameScoreTabelBaseDAL();
// GameScoreTabel gsModel = new GameScoreTabel();
gsModel = gsDAL.GetOneByWhere(s => s.userId == user.Id);
return(gsModel);
}
else
{
return(null);
}
}
public bool UpdateGameScore(string _uname, int _score, int _missed)
{
bool updateResult = false;
UserTabelBaseDAL uDAL = new UserTabelBaseDAL();
UserTabel user = new UserTabel();
user = uDAL.GetOneByWhere(u => u.userName == _uname);
if (user != null)
{
GameScoreTabelBaseDAL gsDAL = new GameScoreTabelBaseDAL();
GameScoreTabel gsModel = new GameScoreTabel();
gsModel = gsDAL.GetOneByWhere(s => s.userId == user.Id);
gsModel.score = _score;
gsModel.missenemy = _missed;
updateResult = gsDAL.Update(gsModel);
return(updateResult);
}
else
{
return(updateResult);
}
}
public void AddTestData()
{
string new_userId = Guid.NewGuid().ToString("N");
Model.UserTabel u = new Model.UserTabel()
{
Id = new_userId,
userName = "******",
password = "******",
logintime = DateTime.Now.ToString("yyyyMMddHHmmssfff")
};
Model.GameScoreTabel s = new Model.GameScoreTabel()
{
Id = Guid.NewGuid().ToString("N"),
userId = new_userId,
missenemy = 0,
score = 888
};
UserTabelBaseDAL uDAL = new UserTabelBaseDAL();
bool insertNewUser = uDAL.Insert(u);
GameScoreTabelBaseDAL sDAL = new GameScoreTabelBaseDAL();
bool insertNewScore = sDAL.Insert(s);
string new_userId2 = Guid.NewGuid().ToString("N");
Model.UserTabel u2 = new Model.UserTabel()
{
Id = new_userId2,
userName = "******",
password = "******",
logintime = DateTime.Now.ToString("yyyyMMddHHmmssfff")
};
Model.GameScoreTabel s2 = new Model.GameScoreTabel()
{
Id = Guid.NewGuid().ToString("N"),
userId = new_userId2,
missenemy = 0,
score = 999
};
insertNewUser = uDAL.Insert(u2);
insertNewScore = sDAL.Insert(s2);
string new_userId3 = Guid.NewGuid().ToString("N");
Model.UserTabel u3 = new Model.UserTabel()
{
Id = new_userId3,
userName = "******",
password = "******",
logintime = DateTime.Now.ToString("yyyyMMddHHmmssfff")
};
Model.GameScoreTabel s3 = new Model.GameScoreTabel()
{
Id = Guid.NewGuid().ToString("N"),
userId = new_userId3,
missenemy = 0,
score = 555
};
insertNewUser = uDAL.Insert(u3);
insertNewScore = sDAL.Insert(s3);
}
