Ejemplo n.º 1
0
        public static List <Sell_Transaction> GetAll()
        {
            List <Sell_Transaction> allSell_Transaction = new List <Sell_Transaction> {
            };
            MySqlConnection conn = DB.Connection();

            conn.Open();
            MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"SELECT * FROM sell_transaction;";
            MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;

            while (rdr.Read())
            {
                int      id         = rdr.GetInt32(0);
                int      userseller = rdr.GetInt32(1);
                int      userbuyer  = rdr.GetInt32(2);
                int      gameId     = rdr.GetInt32(3);
                string   status     = rdr.GetString(4);
                string   gamePhoto  = rdr.GetString(5);
                DateTime date       = rdr.GetDateTime(6);

                Sell_Transaction newSell_Transaction = new Sell_Transaction(gameId, userseller, status, date, gamePhoto, userbuyer, id);
                allSell_Transaction.Add(newSell_Transaction);
            }
            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
            return(allSell_Transaction);
        }
Ejemplo n.º 2
0
 public override bool Equals(System.Object otherSell_Transaction)
 {
     if (!(otherSell_Transaction is Sell_Transaction))
     {
         return(false);
     }
     else
     {
         Sell_Transaction newSell_Transaction = (Sell_Transaction)otherSell_Transaction;
         return(this.GetId().Equals(newSell_Transaction.GetId()));
     }
 }
Ejemplo n.º 3
0
        public static Sell_Transaction Find(int id)
        {
            MySqlConnection conn = DB.Connection();

            conn.Open();

            var cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"SELECT * FROM sell_transaction WHERE id = (@searchId);";
            MySqlParameter searchId = new MySqlParameter();

            searchId.ParameterName = "@searchId";
            searchId.Value         = id;
            cmd.Parameters.Add(searchId);
            var rdr = cmd.ExecuteReader() as MySqlDataReader;

            int      foundid    = 0;
            int      userseller = 0;
            int      userbuyer  = 0;
            int      gameId     = 0;
            string   status     = "";
            string   gamePhoto  = "";
            DateTime date       = new DateTime(2000, 1, 1, 1, 0, 0);

            while (rdr.Read())
            {
                foundid    = rdr.GetInt32(0);
                userseller = rdr.GetInt32(1);
                userbuyer  = rdr.GetInt32(2);
                gameId     = rdr.GetInt32(3);
                status     = rdr.GetString(4);
                gamePhoto  = rdr.GetString(5);
                date       = rdr.GetDateTime(6);
            }

            Sell_Transaction foundSell_Transaction = new Sell_Transaction(gameId, userseller, status, date, gamePhoto, userbuyer, foundid);

            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
            return(foundSell_Transaction);
        }