Ejemplo n.º 1
0
        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;
        }
Ejemplo n.º 2
0
        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;
        }
Ejemplo n.º 3
0
        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 });
        }