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); }