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");
}
