public static List <TimedProductLot> FetchAllLots() { string fetchQuery = "select * from [AuctionBidPlatform].[dbo].[View_timed_auction_lots] where IsSold=0"; DataTable dt = RunDatabaseScript(fetchQuery); TimedProductLot TimedProductLot = new TimedProductLot(); List <TimedProductLot> lots = new List <TimedProductLot>(); currentLotNo = Convert.ToString(dt.Rows[0]["LotId"]); for (int i = 0; i < dt.Rows.Count; i++) { var auctionDate = Convert.ToDateTime(dt.Rows[i]["AuctionDate"]).Date.ToString("dd/MM/yyyy"); var auctionTime = Convert.ToDateTime(dt.Rows[i]["AuctionTime"]).TimeOfDay; lots.Add(new TimedProductLot { LotId = Convert.ToInt32(dt.Rows[i]["LotId"]), //LotImageUrl = "http://127.0.0.1:2520/fileupload/upload/" + dt.Rows[i]["ImageName"], LotImageUrl = "http://auctionbidplatform.com/fileupload/upload/" + dt.Rows[i]["ImageName"], LotDesc = Convert.ToString(dt.Rows[i]["LotDesc"]), Title = Convert.ToString(dt.Rows[i]["Title"]), AuctionName = Convert.ToString(dt.Rows[i]["AuctionName"]), AuctionDate = Convert.ToString(auctionDate), AuctionTime = Convert.ToString(auctionTime), LowEstimatePrice = Convert.ToString(dt.Rows[i]["LowEstimatePrice"]), HighEstimatePrice = Convert.ToString(dt.Rows[i]["HighEstimatePrice"]), MaximumReserveValue = Convert.ToString(dt.Rows[i]["MaxReserveValue"]), BuynowPrice = Convert.ToString(dt.Rows[i]["BuynowPrice"]), }); } return(lots); }
public static List <TimedProductLot> SoldItem(string id) { userName = Convert.ToString(HttpContext.Current.Session["UserName"]).Trim(); if (userName != null && userName != "") { //string query = "UPDATE dbo.TimedProductLot set IsSold = 1 WHERE LotId=" + id; //RunDatabaseScript(query); string fetchQuery = "select * from [AuctionBidPlatform].[dbo].[View_list_item] where IsSold=0"; DataTable dt = RunDatabaseScript(fetchQuery); TimedProductLot TimedProductLot = new TimedProductLot(); List <TimedProductLot> lots = new List <TimedProductLot>(); for (int i = 0; i < dt.Rows.Count; i++) { lots.Add(new TimedProductLot { LotId = Convert.ToInt32(dt.Rows[i]["LotId"]), //LotImageUrl = "http://127.0.0.1:2520/fileupload/upload/" + dt.Rows[i]["LotImageName"], LotImageUrl = "http://auctionbidplatform.com/fileupload/upload/" + dt.Rows[i]["LotImageName"], LotDesc = Convert.ToString(dt.Rows[i]["LotDesc"]), Title = Convert.ToString(dt.Rows[i]["Title"]), AuctionName = Convert.ToString(dt.Rows[i]["AuctionName"]), LowEstimatePrice = Convert.ToString(dt.Rows[i]["LowEstimatePrice"]), HighEstimatePrice = Convert.ToString(dt.Rows[i]["HighEstimatePrice"]) }); } return(lots); } List <TimedProductLot> blanklot = new List <TimedProductLot>(); blanklot.Add(new TimedProductLot { Title = "novalue", }); return(blanklot); }