public List<Category> getAllCatItems()
{
//List<Item> iList = new List<Item>();
List<Category> categories = new List<Category>();
//C/*ategory catItem = null;*/
//DropDownList dropdown = new DropDownList();
SqlConnection conn = DBHelper.loadDB();
String query = "SELECT * FROM CATEGORY";
SqlCommand command = new SqlCommand(query, conn);
//command.Parameters.Add(new SqlParameter("@CATEGORY", category));
try
{
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Category catItem = new Category(reader["CATEGORYID"].ToString(), Convert.ToInt32(reader["AUCTIONID"]), reader["CATEGORYNAME"].ToString(), Convert.ToBoolean(reader["SPONSORED"]), reader["SPONSORNAME"].ToString(), reader["PARENTID"].ToString());
categories.Add(catItem);
}
}
catch (SqlException ex)
{
}
return categories;
}
public Category getByID(string id)
{
SqlConnection conn = DBHelper.loadDB();
String query = "SELECT * FROM CATEGORY WHERE "
+ "CATEGORYID = @ID";
SqlCommand command = new SqlCommand(query, conn);
command.Parameters.Add(new SqlParameter("@ID", id));
Category cat = null;
try
{
SqlDataReader reader = command.ExecuteReader();
reader.Read();
cat = new Category()
{
CategoryID = reader["CATEGORYID"].ToString(),
AuctionID = Convert.ToInt32(reader["AUCTIONID"]),
CategoryName = reader["CATEGORYNAME"].ToString(),
Sponsored = Convert.ToBoolean(reader["SPONSORED"]),
SponsorName = reader["SPONSORNAME"].ToString(),
ParentID = reader["PARENTID"].ToString(),
MinBidRate = Convert.ToDouble(reader["MINBIDRATE"]),
AngelRate = Convert.ToDouble(reader["ANGELPRICERATE"])
};
}
catch(SqlException ex)
{
}
return cat;
}
protected void BtnAddCategory_Click(object sender, EventArgs e)
{
Category newCat = new Category()
{
CategoryID = TxtNewCatId.Text,
AuctionID = Convert.ToInt32(Session["Auction"].ToString()),
CategoryName = TxtNewCatName.Text,
Sponsored = ChkSponsored.Checked,
SponsorName = TxtSponsorName.Text,
ParentID = ParentCatList.SelectedValue,
MinBidRate = Convert.ToDouble(MinBidRate.Text) / 100,
AngelRate = Convert.ToDouble(AngPriceRate.Text) / 100
};
}