public void SaveAlienInvasionUser(AlienInvasionUser user) { if (user.Id > 0) { updateAlienInvasionUser(user); return; } const string commandText = @" insert into alienInvasionUser (name, score, currentCity, failuresOnCurrentCity) values (@name, @score, @currentCity, @failuresOnCurrentCity) " ; executeNonQuery(commandText, new[] { new Parameter { Name = "@name", Value = user.Name }, new Parameter { Name = "@score", Value = user.Score }, new Parameter { Name = "@currentCity", Value = user.CurrentCity }, new Parameter { Name = "@failuresOnCurrentCity", Value = user.FailuresOnCurrentCity }, }); }
private void updateAlienInvasionUser(AlienInvasionUser user) { const string commandText = @" update alienInvasionUser set name = @name, score = @score, currentCity = @currentCity, failuresOnCurrentCity = @failuresOnCurrentCity where id = @id " ; executeNonQuery(commandText, new[] { new Parameter { Name = "@id", Value = user.Id }, new Parameter { Name = "@name", Value = user.Name }, new Parameter { Name = "@score", Value = user.Score }, new Parameter { Name = "@currentCity", Value = user.CurrentCity }, new Parameter { Name = "@failuresOnCurrentCity", Value = user.FailuresOnCurrentCity }, }); }
private void updateAlienInvasionUser(AlienInvasionUser user) { const string commandText = @" update alienInvasionUser set name = @name, score = @score, currentCity = @currentCity, failuresOnCurrentCity = @failuresOnCurrentCity where id = @id "; executeNonQuery(commandText, new[] { new Parameter { Name = "@id", Value = user.Id }, new Parameter { Name = "@name", Value = user.Name }, new Parameter { Name = "@score", Value = user.Score }, new Parameter { Name = "@currentCity", Value = user.CurrentCity }, new Parameter { Name = "@failuresOnCurrentCity", Value = user.FailuresOnCurrentCity }, }); }
private AlienInvasionUser createUser(string userName) { using (var db = new AlienInvasionDatabase()) { var user = new AlienInvasionUser { Name = userName, FailuresOnCurrentCity = 0, CurrentCity = 0, Score = 0 }; db.SaveAlienInvasionUser(user); return(user); } }
private AlienInvasionUser createUser(string userName) { using (var db = new AlienInvasionDatabase()) { var user = new AlienInvasionUser { Name = userName, FailuresOnCurrentCity = 0, CurrentCity = 0, Score = 0 }; db.SaveAlienInvasionUser(user); return user; } }
private AlienInvasionUser getUser(string userName) { IList <AlienInvasionUser> users; using (var db = new AlienInvasionDatabase()) { users = db.GetAlienInvasionUsers(); } AlienInvasionUser user = users.SingleOrDefault(u => string.Compare(u.Name, userName, true) == 0); if (user == null) { user = createUser(userName); } return(user); }
public void SaveAlienInvasionUser(AlienInvasionUser user) { if (user.Id > 0) { updateAlienInvasionUser(user); return; } const string commandText = @" insert into alienInvasionUser (name, score, currentCity, failuresOnCurrentCity) values (@name, @score, @currentCity, @failuresOnCurrentCity) "; executeNonQuery(commandText, new[] { new Parameter { Name = "@name", Value = user.Name }, new Parameter { Name = "@score", Value = user.Score }, new Parameter { Name = "@currentCity", Value = user.CurrentCity }, new Parameter { Name = "@failuresOnCurrentCity", Value = user.FailuresOnCurrentCity }, }); }