public void InsertPiece(EntityPiece piece) { connection.Open(); string sql = "INSERT INTO Piece (PieceID, PosX, PosY, Type, Number, Color) VALUES(@PieceID, @PosX, @PosY, @Type, @Number, @Color)"; SqlCommand command = new SqlCommand(sql, connection); command.Parameters.Add(new SqlParameter("@PosX", piece.PosX)); command.Parameters.Add(new SqlParameter("@PosY", piece.PosY)); command.Parameters.Add(new SqlParameter("@Type", piece.Type)); command.Parameters.Add(new SqlParameter("@Number", piece.Number)); command.Parameters.Add(new SqlParameter("@Color", piece.Color)); command.Parameters.Add(new SqlParameter("@PieceID", piece.PieceID)); try { command.ExecuteNonQuery(); } catch (Exception ex) { } connection.Close(); }
public List <EntityPiece> GetAllPieces() { List <EntityPiece> pieces = new List <EntityPiece>(); SqlDataReader rdr = null; try { connection.Open(); string sql = "SELECT * FROM Piece"; SqlCommand cmd = new SqlCommand(sql, connection); rdr = cmd.ExecuteReader(); while (rdr.Read()) { EntityPiece piece = new EntityPiece(); piece.PieceID = int.Parse(rdr["PieceID"].ToString()); piece.Number = int.Parse(rdr["Number"].ToString()); piece.Color = int.Parse(rdr["Color"].ToString()); piece.PosX = int.Parse(rdr["PosX"].ToString()); piece.PosY = int.Parse(rdr["PosY"].ToString()); piece.Type = rdr["Type"].ToString(); pieces.Add(piece); } } finally { if (rdr != null) { rdr.Close(); } if (connection != null) { connection.Close(); } } return(pieces); }