public List <Game_Grid_BD> Pesquisar_Game()
{
string sqlA = "Select * FROM TB_GAME";
using (var conn = new SqlConnection(@"data source=.\SQLEXPRESS;initial catalog=BD_GAME;integrated security=True;MultipleActiveResultSets=True"))
{
var cmd = new SqlCommand(sqlA, conn);
List <Game_Grid_BD> dados = new List <Game_Grid_BD>();
Game_Grid_BD p = null;
try
{
conn.Open();
using (var reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
p = new Game_Grid_BD();
p.Codigo = Convert.ToInt16(reader["CD_GAME"]);
p.Nome_Game = reader["NM_GAME"].ToString();
dados.Add(p);
}
}
}
finally
{
conn.Close();
}
return(dados);
}
}
public Game_Grid_BD Pesquisar_pelo_Codigo(int pCodigo)
{
using (var conn = new SqlConnection(@"data source=DESKTOP-OUCTPF0\SQLEXPRESS;initial catalog=BD_GAME;integrated security=True"))
{
string sql = "Select * FROM TB_GAME WHERE CD_GAME=@cod";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@cod", pCodigo);
Game_Grid_BD oGame = null;
try
{
conn.Open();
using (var reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.HasRows)
{
if (reader.Read())
{
oGame = new Game_Grid_BD();
oGame.Codigo = (int)reader["CD_GAME"];
oGame.Nome_Game = reader["NM_GAME"].ToString();
}
}
}
}
finally
{
conn.Close();
}
return(oGame);
}
}
public void Alterar(Game_Grid_BD pGame)
{
using (var conn = new SqlConnection(@"data source=.\SQLEXPRESS;initial catalog=BD_TESTE;integrated security=True;MultipleActiveResultSets=True"))
{
string sql = "UPDATE TB_GAME SET NM_GAME=@nome Where CD_GAME=@cod";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@cod", pGame.Codigo);
cmd.Parameters.AddWithValue("@nome", pGame.Nome_Game);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}
public void Inserir(Game_Grid_BD pGame)
{
using (var conn = new SqlConnection(@"data source=.\SQLEXPRESS;initial catalog=BD_GAME;integrated security=True;MultipleActiveResultSets=True"))
{
string sql = "INSERT INTO TB_GAME (NM_GAME, TOTAL_MORTE) VALUES (@nome, @total)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@nome", pGame.Nome_Game);
cmd.Parameters.AddWithValue("@total", pGame.Total_Morte);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}