private void UpdateBidForAuctionStatus(int vStatus) { // Convert the bid item first before the tenders // 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(), Constant.BLANK, Constant.AUCTION_STATUS_DRAFT.ToString(), bidItem.DeliveryDate.ToString(), bidItem.CompanyId.ToString(), Constant.AUCTION_TYPE_REVERSE.ToString(), Constant.BLANK, Constant.BLANK, Constant.BLANK, Constant.BLANK, bidItem.BidRefNo.ToString(), bidItem.PRDate.ToString().Trim(), //Constant.BLANK, //Constant.BLANK, ref vAuctionRefNo); } // convert and create a copy of the bid tender to auction tenders // start here }
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"); }