public List <Bids> ChanceToWin() { string sql = @"SELECT * FROM LISTINGS WHERE LastDate >= '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; DataTable ListingTable = Db.getAll(sql); List <Bids> chanceToWin = new List <Bids>(); foreach (DataRow row in ListingTable.Rows) { var listingId = row["id"].ToString(); sql = "SELECT MIN(Price) as min FROM BIDS WHERE listingid = " + listingId; DataRow MinimumPrice = Db.getOne(sql); var _minimumPrice = MinimumPrice["min"].ToString(); if (_minimumPrice == "") { _minimumPrice = "0"; } sql = "SELECT * FROM Bids WHERE listingid = " + listingId + " and UserId = " + Id + " and Price = " + _minimumPrice; DataRow chanceToWinRow = Db.getOne(sql); if (chanceToWinRow.ItemArray.Count() > 0) { sql = "SELECT * FROM Bids Where listingId = " + listingId + " and UserId = " + Id; DataRow bidrow = Db.getOne(sql); var _bidId = bidrow["id"].ToString(); int bidId = Convert.ToInt32(_bidId); Bids bid = new Bids(); bid.Id = bidId; bid.Get(); chanceToWin.Add(bid); } } return(chanceToWin); }
public static Bids GetWinner(string ProductId) { string sql = "SELECT * FROM Contract WHERE productId = " + ProductId; DataRow row = Db.getOne(sql); if (row == null) { return(null); } Bids bid = new Bids(); var _id = row["bidid"].ToString(); bid.Id = int.Parse(_id); bid.Get(); return(bid); }
public static Bids isAlreadyBid(string buyerid, string productid) { Bids bid = new Bids(); string sql = "SELECT * FROM Bids WHERE buyerid = " + buyerid + " and productid = " + productid; DataRow row = Db.getOne(sql); if (row.Table.Rows.Count > 0) { var _id = row["id"].ToString(); bid.Id = int.Parse(_id); bid.Get(); return(bid); } bid = null; return(bid); }
public List <Bids> AppliedFor() { List <Bids> Bids = new List <Bids>(); string sql = "SELECT * FROM Bids WHERE UserId = " + Id; DataTable BidsTable = Db.getAll(sql); foreach (DataRow row in BidsTable.Rows) { Bids Bid = new Bids(); var _id = row["id"].ToString(); int id; int.TryParse(_id, out id); Bid.Id = id; Bid.Get(); Bids.Add(Bid); } return(Bids); }
public List <Bids> AlreadyWin() { string sql = "SELECT Bids.*, MIN(Price) FROM Bids WHERE UserId = " + Id + " and DateTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; DataTable BidsTable = Db.getAll(sql); List <Bids> Bids = new List <Bids>(); foreach (DataRow row in BidsTable.Rows) { Bids Bid = new Bids(); var _id = row["id"].ToString(); int id; int.TryParse(_id, out id); Bid.Id = id; Bid.Get(); Bids.Add(Bid); } return(Bids); }