// GET: BidViewByProductId public ActionResult GetBidById(int id) { BidDetail bid = null; using (var client = new HttpClient()) { client.BaseAddress = new Uri("https://localhost:44320/api/"); string token = DeserializeToken(); client.DefaultRequestHeaders.Clear(); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); var responseTask = client.GetAsync("bid/" + id.ToString()); responseTask.Wait(); var result = responseTask.Result; if (result.IsSuccessStatusCode) { var readTask = result.Content.ReadAsAsync <BidDetail>(); readTask.Wait(); bid = readTask.Result; } else { ModelState.AddModelError(string.Empty, result.Content.ReadAsStringAsync().Result); } } return(View(bid)); }
/// Function Name : Reject Bid Details /// Parameter Details /// 1. BidDetail DTO /// /// Functionality /// This function accept Bid details DTO and mark the bid as rejected based on the Bid ID /// public HttpResponseMessage RejectBid(BidDetail objBidDetail) { #region declaration DataTable dt = new DataTable(); string sQuery = ""; Random r = new Random(); DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2]; int iParamCount = 0; #endregion DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString); objParam[iParamCount].sParamName = "@vQueryType"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = "REJECTBID"; iParamCount++; objParam[iParamCount].sParamName = "@bid"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidID); iParamCount++; sQuery = ProcBidOperation_Bid; sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt); if (sRetVal == "SUCCESS") { return(Request.CreateResponse(HttpStatusCode.OK, "Bid Rejected Successfully")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal)); } }
public bool DeleteBidDetail(BidDetail bidDetail) { if (bidDetail == null) { return(false); } _unitOfWork.BidDetailRepository.Delete(bidDetail); _unitOfWork.Save(); return(true); }
public ActionResult UpdateMaxPrice(Product model) { BidDetail c = new BidDetail(); using (var ctx = new QLBHEntities()) { ctx.Entry(model).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); } return(RedirectToAction("Detail", "Product", new { id = model.ProID })); }
public ActionResult Detail(BidDetail model, int id) { BidDetail bid = new BidDetail(); using (var ctx = new QLBHEntities()) { bid.BidPrice = ctx.BidDetails.Where(p => p.ProID == model.ProID).Max(p => p.BidPrice); } using (var ctx = new QLBHEntities()) { ctx.BidDetails.Add(model); ctx.SaveChanges(); } return(RedirectToAction("EditMaxPrice", "Product", new { proid = model.ProID, bidprice = model.BidPrice, bidpricemaxbefore = bid.BidPrice })); }
protected void btn_insert_Click(object sender, EventArgs e) { DataContext db = new DataContext("Data Source=RICHA1\\SQLEXPRESS;Initial Catalog=rich;uid=sa;pwd=info123!"); Table <BidDetail> table = db.GetTable <BidDetail>(); BidDetail bd = new BidDetail() { BID = Convert.ToInt32(txt_bid.Text), Domain = txt_domain.Text, Name = txt_name.Text, ProjectDuration = Convert.ToInt32(txt_duration.Text), TeamRequired = Convert.ToInt32(txt_team.Text), }; table.InsertOnSubmit(bd); db.SubmitChanges(); }
public bool EditBidDetail(BidDetail bidDetail) { _unitOfWork.BidDetailRepository.Edit(bidDetail); _unitOfWork.Save(); return(true); }
public bool AddBidDetail(BidDetail bidDetail) { _unitOfWork.BidDetailRepository.Add(bidDetail); _unitOfWork.Save(); return(true); }
//***************************************** Place Bid ************************************************** // PlaceBid : Place the bid for a specific consignment * // GetBidDetail : Get the bid detail on the basis of different filter Crieteria * // UpdateBid : Update Bid Details. Only Bid amount can modify * // DeleteBid : Delete bid on the basis of bid ID * // //******************************************************************************************************* /// Function Name : Place Bid /// Parameter Details /// 1. BidDetail DTO /// /// Functionality /// This function accept Bid details DTO and store into DB /// Value of Load ID, User ID, Amount is mandatory public HttpResponseMessage PlaceBid(BidDetail objBidDetail) { #region declaration DataTable dt = new DataTable(); string sQuery = ""; Random r = new Random(); DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[9]; int iParamCount = 0; #endregion DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString); objParam[iParamCount].sParamName = "@vQueryType"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = "PLACEBID"; iParamCount++; objParam[iParamCount].sParamName = "@bid"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = "0"; iParamCount++; objParam[iParamCount].sParamName = "@cid"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CId); iParamCount++; objParam[iParamCount].sParamName = "@bidamount"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidAmount); iParamCount++; objParam[iParamCount].sParamName = "@userid"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.UserID); iParamCount++; objParam[iParamCount].sParamName = "@viewed"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = objBidDetail.Viewed; iParamCount++; objParam[iParamCount].sParamName = "@status"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.Status); iParamCount++; objParam[iParamCount].sParamName = "@creationdatetime"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CreationDateTime.ToString("dd-MM-yyyy")); iParamCount++; objParam[iParamCount].sParamName = "@BidUpdateDateTime"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidUpdateDateTime.ToString("dd-MM-yyyy"));; iParamCount++; sQuery = "ProcBidOperation"; sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt); if (sRetVal == "SUCCESS") { return(Request.CreateResponse(HttpStatusCode.OK, "Bid Placed Successfully")); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal)); } }
public HttpResponseMessage GetBidDetail(BidDetail objBidDetail) { #region declaration DataTable dt = new DataTable(); string sQuery = ""; Random r = new Random(); DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2]; int iParamCount = 0; string sFilter = ""; #endregion DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString); #region Prepare Query Filter if (objBidDetail.BidID > 0) { sFilter += " AND bid_id=" + objBidDetail.BidID; } if (objBidDetail.CId > 0) { sFilter += " AND load_id=" + objBidDetail.CId; } if (objBidDetail.BidAmount > 0) { sFilter += " AND Bid_Amount=" + objBidDetail.BidAmount; } if (objBidDetail.UserID > 0) { sFilter += " AND User_ID=" + objBidDetail.UserID; } if (!string.IsNullOrEmpty(objBidDetail.Viewed)) { sFilter += " AND Viewed=" + objBidDetail.Viewed; } if (sFilter.Length > 4) { sFilter = "Where " + sFilter.Substring(4); } #endregion objParam[iParamCount].sParamName = "@vQueryType"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = "CONSIGNMENTDETAIL"; iParamCount++; objParam[iParamCount].sParamName = "@vFilterClause"; objParam[iParamCount].sParamType = SqlDbType.VarChar; objParam[iParamCount].sParamValue = sFilter; iParamCount++; sQuery = "ProcGetBidDetail"; sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC, objParam, ref dt); if (sRetVal == "SUCCESS") { return(Request.CreateResponse(HttpStatusCode.OK, dt)); } else { return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal)); } }