public List <AdvertisementLogic> AdvertisementId(int id)
{
AdvertisementDb connection = new AdvertisementDb();
DataTable dataTable = connection.AdvertisementId(id);
List <AdvertisementLogic> list = new List <AdvertisementLogic>();
foreach (DataRow dr in dataTable.Rows)
{
AdvertisementLogic advertisement = new AdvertisementLogic();
advertisement.id = Convert.ToInt32(dr["Id"]);
advertisement.username = dr["Username"].ToString();
advertisement.available = Convert.ToInt32(dr["Available"]);
advertisement.description = dr["Description"].ToString();
advertisement.type = dr["Type"].ToString();
advertisement.amount = Convert.ToInt32(dr["Amount"]);
advertisement.weight = dr["Weight"].ToString();
advertisement.expiration = Convert.ToDateTime(dr["Expiration"]);
advertisement.image = (byte[])(dr["Image"]);
advertisement.name = dr["Name"].ToString();
list.Add(advertisement);
}
return(list);
}
public void AdvertisementAdd(string username, int available, string description)
{
AdvertisementDb connection = new AdvertisementDb();
connection.Add(username, available, description);
}
