Example #1
0
    private void displayItemDetails()
    {
        BidItemDetailTransaction bid = new BidItemDetailTransaction();

        gvBidItemDetails.DataSource = bid.GetBidItemDetails(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
        gvBidItemDetails.DataBind();
    }
Example #2
0
    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);
        }
    }
Example #3
0
    private void FillBidItemDetails()
    {
        BidItemDetailTransaction bid = new BidItemDetailTransaction();

        gvBidItemDetails.DataSource = bid.GetBidItemDetails(connstring, hdnBidRefNo.Value.Trim());
        gvBidItemDetails.DataBind();
    }
Example #4
0
    private void DisplayItemDetails(string bidRefNo)
    {
        BidItemDetailTransaction bid = new BidItemDetailTransaction();

        gvAuctionItemDetails.DataSource = bid.GetBidItemDetails(connstring, bidRefNo);
        gvAuctionItemDetails.DataBind();
    }
Example #5
0
        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();
            }
        }
Example #6
0
    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");
    }