private void displayItemDetails() { BidItemDetailTransaction bid = new BidItemDetailTransaction(); gvBidItemDetails.DataSource = bid.GetBidItemDetails(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); gvBidItemDetails.DataBind(); }
private void DisplayDetails() { BidItemDetailTransaction biddetail = new BidItemDetailTransaction(); ArrayList biddetailarray = biddetail.GetBidDetails(connstring, Session[Constant.SESSION_BIDREFNO].ToString().Trim()); OtherTransaction dte = new OtherTransaction(); foreach (BidItemDetail b in biddetailarray) { HtmlTableRow row = new HtmlTableRow(); HtmlTableCell[] cell = new HtmlTableCell[5]; cell[0] = new HtmlTableCell(); cell[0].Controls.Add(new LiteralControl(b.Item)); row.Cells.Add(cell[0]); cell[1] = new HtmlTableCell(); cell[1].Controls.Add(new LiteralControl(b.DetailDesc)); cell[1].Attributes.Add("class", "value"); row.Cells.Add(cell[1]); cell[2] = new HtmlTableCell(); cell[2].Controls.Add(new LiteralControl(b.Qty.ToString().Trim())); cell[2].Attributes.Add("class", "value"); row.Cells.Add(cell[2]); cell[3] = new HtmlTableCell(); cell[3].Controls.Add(new LiteralControl(b.UnitOfMeasure.ToString().Trim())); cell[3].Attributes.Add("class", "value"); row.Cells.Add(cell[3]); itemDetails1.Rows.Add(row); } }
private void FillBidItemDetails() { BidItemDetailTransaction bid = new BidItemDetailTransaction(); gvBidItemDetails.DataSource = bid.GetBidItemDetails(connstring, hdnBidRefNo.Value.Trim()); gvBidItemDetails.DataBind(); }
private void DisplayItemDetails(string bidRefNo) { BidItemDetailTransaction bid = new BidItemDetailTransaction(); gvAuctionItemDetails.DataSource = bid.GetBidItemDetails(connstring, bidRefNo); gvAuctionItemDetails.DataBind(); }
private void FillBidItemDetails() { BidItemDetailTransaction bid = new BidItemDetailTransaction(); DataView dv = bid.GetBidItemDetails(connstring, ViewState["BidRefNo"].ToString().Trim()); if (dv.Count > 0) { gvBidItemDetails.DataSource = dv; gvBidItemDetails.DataBind(); } else { DataTable dt = new DataTable(); dt = CreateEmptyTable(); gvBidItemDetails.DataSource = dt; gvBidItemDetails.DataBind(); } }
private void UpdateBidForAuctionStatus(int vStatus) { // get bid item BidItem bidItem = BidItemTransaction.QueryBidInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); if (vStatus == Constant.BID_STATUS_APPROVED_FOR_AUCTION) { BidItemTransaction.UpdateBidForAuctionStatus(connstring, bidItem.BidRefNo.ToString(), vStatus); string dummyVar = Constant.BLANK; // save a copy to tblAuctionItem string vAuctionRefNo = ""; AuctionTransaction auctionTransaction = new AuctionTransaction(); auctionTransaction.InsertAuctionItem(connstring, bidItem.PRRefNo.ToString(), bidItem.Requestor, bidItem.ItemDescription, bidItem.BuyerId.ToString(), bidItem.GroupDeptSec.ToString(), bidItem.Category.ToString(), bidItem.SubCategory.ToString(), Constant.AUCTION_STATUS_APPROVED.ToString(), bidItem.DeliveryDate.ToString(), bidItem.CompanyId.ToString(), Constant.AUCTION_TYPE_REVERSE.ToString(), Constant.BLANK, Constant.BLANK, Constant.BLANK, bidItem.BidCurrency.ToString(), bidItem.BidRefNo.ToString(), bidItem.PRDate.ToString().Trim(), //Constant.BLANK, //Constant.BLANK, ref vAuctionRefNo); // copy the bid item details to auction item details BidItemDetailTransaction detailTransaction = new BidItemDetailTransaction(); ArrayList arrBidItemDetails = detailTransaction.GetBidDetails(connstring, Session[Constant.SESSION_BIDREFNO].ToString()); foreach (BidItemDetail bidDetail in arrBidItemDetails) { string vAuctionDetailNo = ""; // insert auction detail to database auctionTransaction.InsertAuctionItemDetails( connstring, bidDetail.Item, bidDetail.DetailDesc, bidDetail.Qty.ToString(), bidDetail.UnitOfMeasure, Constant.AUCTION_STATUS_APPROVED.ToString(), vAuctionRefNo, bidItem.Category.ToString(), bidItem.SubCategory.ToString(), "", "", "0", "0", ref vAuctionDetailNo); } } Response.Redirect("bidsforconversion.aspx"); }