public List <MultiverseId> SelectAll() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from prices"; SqlDataReader sqlDataReader = Db.Select(sqlCommand); List <MultiverseId> multiverseIds = new List <MultiverseId>(); if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { MultiverseId multiverseId = new MultiverseId(); multiverseId.Id = (Int32)sqlDataReader["id"]; multiverseId.Value = (Int32)sqlDataReader["value"]; multiverseId.Card = new CardDAO().SelectById((Int32)sqlDataReader["id_card"]); multiverseIds.Add(multiverseId); } sqlDataReader.Read(); return(multiverseIds); } else { return(null); } }
public MultiverseId SelectById(Int32 id) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "select * from multiverse_ids where id = @id"; sqlCommand.Parameters.AddWithValue("@id", id); SqlDataReader sqlDataReader = Db.Select(sqlCommand); MultiverseId multiverseId = new MultiverseId(); if (sqlDataReader.HasRows) { sqlDataReader.Read(); multiverseId.Id = (Int32)sqlDataReader["id"]; multiverseId.Value = (Int32)sqlDataReader["value"]; multiverseId.Card = new CardDAO().SelectById((Int32)sqlDataReader["id_card"]); return(multiverseId); } else { return(null); } }
public void Delete(MultiverseId multiverseId) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "delete from multiverse_ids where id = @id"; sqlCommand.Parameters.AddWithValue("@id", multiverseId.Id); Db.Execute(sqlCommand); }
public void Insert(MultiverseId multiverseIds) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "insert into multiverse_ids (value, id_card) values (@id_card, @id_card)"; sqlCommand.Parameters.AddWithValue("@value", multiverseIds.Value); sqlCommand.Parameters.AddWithValue("@id_card", multiverseIds.Card.Id); Db.Execute(sqlCommand); }
public void Update(MultiverseId multiverseId) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "update multiverse_ids set value = @value, id_card = @id_card where id = @id"; sqlCommand.Parameters.AddWithValue("@id", multiverseId.Id); sqlCommand.Parameters.AddWithValue("@value", multiverseId.Value); sqlCommand.Parameters.AddWithValue("@id_card", multiverseId.Card.Id); Db.Execute(sqlCommand); }