public static List <Buy_Offer> GetAll() { List <Buy_Offer> allBuy_Offer = new List <Buy_Offer> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM buy_offer;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int id = rdr.GetInt32(0); int offererId = rdr.GetInt32(1); int wgameId = rdr.GetInt32(2); int transaction_sell_id = rdr.GetInt32(3); DateTime date = rdr.GetDateTime(4); int ogameId = rdr.GetInt32(5); string comment = rdr.GetString(6); Buy_Offer newBuy_Offer = new Buy_Offer(wgameId, date, offererId, ogameId, comment, transaction_sell_id, id); allBuy_Offer.Add(newBuy_Offer); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allBuy_Offer); }
public override bool Equals(System.Object otherBuy_Offer) { if (!(otherBuy_Offer is Buy_Offer)) { return(false); } else { Buy_Offer newBuy_Offer = (Buy_Offer)otherBuy_Offer; return(this.GetId().Equals(newBuy_Offer.GetId())); } }
public static Buy_Offer Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM buy_offer 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 offererId = 0; int wgameId = 0; int transaction_sell_id = 0; DateTime date = new DateTime(2000, 1, 1, 1, 0, 0); int ogameId = 0; string comment = ""; while (rdr.Read()) { foundid = rdr.GetInt32(0); offererId = rdr.GetInt32(1); wgameId = rdr.GetInt32(2); transaction_sell_id = rdr.GetInt32(3); date = rdr.GetDateTime(4); ogameId = rdr.GetInt32(5); comment = rdr.GetString(6); } Buy_Offer foundBuy_Offer = new Buy_Offer(wgameId, date, offererId, ogameId, comment, transaction_sell_id, foundid); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundBuy_Offer); }