/**
* Method get all the offer register in the database
* Author: Danny Xie Li
* Description: get all the offer register in the database.
* Created: 22/03/18
* Last modification: 22/03/18
*/
public List <Offer> getOffer()
{
DBConnection conection = new DBConnection();
conection.OpenConnection();
// Change procedure to administrator
MySqlCommand command = new MySqlCommand(Interface.IConstant.PROCEDURE_GET_OFFER, conection.getConnection());
command.CommandType = CommandType.StoredProcedure;
MySqlDataReader reader = command.ExecuteReader();
List <Offer> listOffer = new List <Offer>();
while (reader.Read())
{
Offer tmp = new Offer // Create an instance of the object offer
{
idOffer = reader.GetInt16("IdOffer"),
OriginalPrice = reader.GetInt16("Original"),
OfferPrice = reader.GetInt16("OfferPrice"),
Name = reader.GetString("Name")
};
listOffer.Add(tmp);
}
return(listOffer);
}
/**
* Method get offer by id
* Author: Danny Xie Li
* Description: get offer by id
* Created: 22/03/18
* Last modification: 22/03/18
*/
public Offer getOfferById(int pId)
{
DBConnection conection = new DBConnection();
conection.OpenConnection();
MySqlCommand command = new MySqlCommand(Interface.IConstant.PROCEDURE_GET_OFFER_BY_ID, conection.getConnection());
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@pId", pId);
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Offer tmp = new Offer // Create an instance of the object offer
{
idOffer = reader.GetInt16("IdOffer"),
OriginalPrice = reader.GetInt16("Original"),
OfferPrice = reader.GetInt16("OfferPrice"),
Name = reader.GetString("Name")
};
return(tmp);
}
return(null);
}
