public static List <Listings> GetAll(string terms = "")
{
List <Listings> Listings = new List <Listings>();
string sql;
int listingCode;
int.TryParse(terms, out listingCode);
if (terms == "")
{
sql = "SELECT * FROM Listings";
}
else
{
sql = "SELECT * FROM Listings WHERE title like '%" + terms + "%' OR ListingCode = " + listingCode;
}
DataTable _categories = Db.getAll(sql);
foreach (DataRow row in _categories.Rows)
{
Listings listing = new Listings();
var _id = row["id"].ToString();
int id;
int.TryParse(_id, out id);
listing.Id = id;
listing.Get();
Listings.Add(listing);
}
return(Listings);
}
public void Get()
{
string sql = "SELECT * FROM Bids WHERE id = " + Id;
DataRow row = Db.getOne(sql);
if (!row.IsNull(0))
{
var _listingId = row["listingid"].ToString();
int listingId;
int.TryParse(_listingId, out listingId);
Listing = new Listings();
Listing.Id = listingId;
Listing.Get();
var _userId = row["userid"].ToString();
int userId;
int.TryParse(_userId, out userId);
User = new Users();
User.Id = userId;
var _price = row["price"].ToString();
int price;
int.TryParse(_price, out price);
Price = price;
var dateTime = row["datetime"].ToString();
DateTime = Convert.ToDateTime(dateTime);
}
}
private void GetListing()
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("Default.aspx");
return;
}
var _id = Request.QueryString["id"].ToString();
int id;
int.TryParse(_id, out id);
item = new Listings();
item.Id = id;
item.Get();
}
public List <Listings> GetAllListing()
{
List <Listings> Listings = new List <Listings>();
string sql = "SELECT * FROM Listings WHERE SellerId = " + Id;
DataTable _categories = Db.getAll(sql);
foreach (DataRow row in _categories.Rows)
{
Listings listing = new Listings();
var _id = row["id"].ToString();
int id;
int.TryParse(_id, out id);
listing.Id = id;
listing.Get();
Listings.Add(listing);
}
return(Listings);
}
