public static int createBid(Bid bid)
{
int bidID = -1;
DataAccessLayer DAL = new DataAccessLayer();
DataTable bidDupPrices = DAL.select(String.Format("BidPrice = '{0}' AND PostID = '{1}'", bid.BidPrice, bid.PostID), "Bids");
if (bidDupPrices.Rows.Count > 0)
{
return bidID;
}
Dictionary<string, string> Bid = new Dictionary<string, string>();
Bid.Add("BidPrice", Convert.ToString(bid.BidPrice));
Bid.Add("PostID", Convert.ToString(bid.PostID));
Bid.Add("BidderID", Convert.ToString(bid.BidderID));
Bid.Add("viaEmail", Convert.ToString(bid.BidviaEmail));
Bid.Add("IsActive", Convert.ToString(true));
Bid.Add("IsDeleted", Convert.ToString(false));
Bid.Add("CreatedDate", Convert.ToString(DateTime.Now));
Bid.Add("ModifiedDate", Convert.ToString(DateTime.Now));
bidID = DAL.insert(Bid, "Bids");
return bidID;
}
public static List<Bid> getBids(int postID)
{
List<Bid> bids = new List<Bid>();
try
{
DataAccessLayer DAL = new DataAccessLayer();
DataTable dt = DAL.select(String.Format("postID = '{0}'", postID), "Bids");
foreach (DataRow row in dt.Rows)
{
int bidderID = Convert.ToInt32(row["BidderID"]);
DataTable buyerDt = DAL.select(String.Format("profileID = '{0}'", bidderID), "UserProfile");
DataRow buyerRow = buyerDt.Rows[0];
int bidID = Convert.ToInt32(row["BidID"]);
string bidder = Convert.ToString(buyerRow["Name"]);
int bidPrice = Convert.ToInt32(row["BidPrice"]);
bool viaEmail = Convert.ToBoolean(row["viaEmail"]);
Bid bid = new Bid(postID, bidderID, bidder, bidPrice, viaEmail, bidID);
bids.Add(bid);
}
}
catch (Exception ex)
{
Console.Write("ERROR: An error occured in retrieving the bids --- " + ex.Message);
}
return bids;
}
public JsonResult CreateBid(int postID, int bid, string email)
{
string AccessToken = Convert.ToString(Session["AccessToken"]);
UserProfile profile = UserProfileUtil.getUserProfile(AccessToken);
Bid newBid = new Bid(postID, profile.ProfileID, profile.Name, bid, email != string.Empty, -1);
int bidID = BidHandler.createBid(newBid);
newBid.BidID = bidID;
return Json(new { profileName = profile.Name, BidID = bidID });
}