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 },
});
}
