public void testbdd()
{
using (var db = new ScoreKeeperContext())
{
//var score = new score { NAME = "test", POINTS = 2, GAMES = 1, LASTGAME = DateTime.Now };
// db.scores.Add(score);
//db.SaveChanges();
var myParamName = new SqlParameter("@Name", SqlDbType.VarChar, 100);
myParamName.Value = "tes";
var myParamPoints = new SqlParameter("@Points", SqlDbType.Int, 4);
myParamPoints.Value = 1;
var myParamGames = new SqlParameter("@Games", SqlDbType.Int, 4);
myParamGames.Value = 1;
var myParamLastGame = new SqlParameter("@LastGame", SqlDbType.DateTime, 255);
myParamLastGame.Value = DateTime.Now;
var courseList = db.Database.ExecuteSqlCommand("exec InserUser @Name, @Points, @Games, @LastGame", myParamName, myParamPoints, myParamGames, myParamLastGame);
var query = from b in db.scores select b;
Console.WriteLine("All blogs in the database:");
foreach (var item in query)
{
Console.WriteLine(item.NAME);
}
}
}
public void InputScoreSQL()
{
using (var db = new ScoreKeeperContext())
{
var query = from b in db.scores select b;
foreach (var item in query)
{
ListUsers.Add(new User(item.NAME, item.POINTS, item.GAMES, item.LASTGAME));
}
}
}
public void SaveScoreSQL(User user)
{
SqlParameter myParamName, myParamPoints, myParamGames, myParamLastGame;
using (var db = new ScoreKeeperContext())
{
myParamName = new SqlParameter("@Name", SqlDbType.VarChar, 100);
myParamName.Value = user.Name;
myParamPoints = new SqlParameter("@Points", SqlDbType.Int, 4);
myParamPoints.Value = user.Points;
myParamGames = new SqlParameter("@Games", SqlDbType.Int, 4);
myParamGames.Value = user.Games;
myParamLastGame = new SqlParameter("@LastGame", SqlDbType.DateTime, 255);
myParamLastGame.Value = user.LastGame;
db.Database.ExecuteSqlCommand("exec InserUser @Name, @Points, @Games, @LastGame", myParamName, myParamPoints, myParamGames, myParamLastGame);
}
}