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