Exemple #1
0
    private void DisplayDetails()
    {
        AuctionItem auctionItem = AuctionItemTransaction.QueryAuctionItemInfo(ViewState[Constant.SESSION_AUCTIONREFNO].ToString().Trim());

        CategoryTransaction     category = new CategoryTransaction();
        GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
        CompanyTransaction      cmp      = new CompanyTransaction();

        OtherTransaction dte = new OtherTransaction();

        lblCompany.Text = cmp.GetCompanyName(connstring, auctionItem.CompanyId.ToString().Trim());

        lblRequestor.Text = auctionItem.Requestor.ToString().Trim();
        lblPRNumber.Text  = auctionItem.PRRefNo.ToString().Trim();
        lblPRDate.Text    = auctionItem.PRDate.ToString().Trim();
        lblGroup.Text     = grp.GetGroupDeptSecNameById(connstring, auctionItem.GroupDeptSec.ToString().Trim());
        lblAuctionReferenceNumber.Text = auctionItem.AuctionRefNo.ToString().Trim();
        lblSubCategory.Text            = category.GetCategoryNameById(connstring, auctionItem.Category.ToString().Trim());
        // lblDeadline.Text = auctionItem.Deadline.ToString().Trim();
        lblDeliveryDate.Text = auctionItem.DeliveryDate.ToString().Trim();
        lblItemDesc.Text     = auctionItem.ItemDescription.ToString().Trim();

        lblAuctionType.Text      = AuctionItemTransaction.GetAuctionTypeById(auctionItem.AuctionType.ToString().Trim());
        lblAuctionDeadline.Text  = auctionItem.AuctionDeadline.ToString().Trim();
        lblAuctionDate.Text      = auctionItem.AuctionStartDate.ToString().Trim();
        lblAuctionStartTime.Text = auctionItem.AuctionStartTime.ToString().Trim();
        lblAuctionEndTime.Text   = auctionItem.AuctionEndTime.ToString().Trim();
        lblBidCurrency.Text      = AuctionItemTransaction.getBidCurrency(auctionItem.BidCurrency.ToString().Trim());
    }
Exemple #2
0
    private void displayDetails()
    {
        if (ViewState[Constant.SESSION_BIDREFNO] != null)
        {
            BidItem                 biditem  = BidItemTransaction.QueryBidItemInfo(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim());
            CategoryTransaction     category = new CategoryTransaction();
            GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
            CompanyTransaction      cmp      = new CompanyTransaction();
            IncotermTransaction     inc      = new IncotermTransaction();
            OtherTransaction        dte      = new OtherTransaction();

            lblCompany.Text = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim());

            lblRequestor.Text             = biditem.Requestor.ToString().Trim();
            lblPRNumber.Text              = biditem.PRRefNo.ToString().Trim();
            lblPRDate.Text                = biditem.PRDate.ToString().Trim();
            lblGroup.Text                 = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim());
            lblBidReferenceNumber.Text    = biditem.BidRefNo.ToString().Trim();
            lblSubCategory.Text           = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim());
            lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim();
            lblBidItemDescription.Text    = biditem.ItemDescription;
            lblDeliverTo.Text             = biditem.DeliverTo;
            lblIncoterm.Text              = inc.GetIncotermName(connstring, biditem.Incoterm);

            hdBidEventType.Value = biditem.BidStatus.ToString().Trim();

            displayItemDetails();
            displaySuppliers();
        }
    }
Exemple #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
        connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
        if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
        {
            Response.Redirect("../unauthorizedaccess.aspx");
        }

        if (!(IsPostBack))
        {
            Session[Constant.SESSION_COMMENT_TYPE] = "1";
            if (Request.QueryString["AuctionRefNo"] != null)
            {
                Session["AuctionRefNo"] = Request.QueryString["AuctionRefNo"].ToString().Trim();
            }

            if (Session["AuctionRefNo"] != null)
            {
                hdnAuctionRefNo.Value = Session["AuctionRefNo"].ToString().Trim();
            }

            if (hdnAuctionRefNo.Value.Trim() != "")
            {
                AuctionTransaction      au  = new AuctionTransaction();
                AuctionItem             ai  = au.GetAuctionByAuctionRefNo(connstring, hdnAuctionRefNo.Value.Trim());
                CompanyTransaction      cmp = new CompanyTransaction();
                GroupDeptSecTransaction grp = new GroupDeptSecTransaction();
                CategoryTransaction     cat = new CategoryTransaction();
                OtherTransaction        oth = new OtherTransaction();
                lblCompany.Text         = cmp.GetCompanyName(connstring, ai.CompanyId.ToString().Trim());
                lblRequestor.Text       = ai.Requestor.ToString().Trim();
                lblPRNumber.Text        = ai.PRRefNo.ToString().Trim();
                lblPRDate.Text          = ai.PRDate.ToString().Trim();
                lblGroup.Text           = grp.GetGroupDeptSecNameById(connstring, ai.GroupDeptSec.ToString().Trim());
                lblSubCategory.Text     = cat.GetCategoryNameById(connstring, ai.Category.ToString().Trim());
                lblDeadline.Text        = ai.AuctionDeadline.ToString().Trim();
                lblDeliveryDate.Text    = ai.DeliveryDate.ToString().Trim();
                lblItemDescription.Text = ai.ItemDescription.ToString().Trim();
                lblReferenceNumber.Text = hdnAuctionRefNo.Value.Trim();

                lblAuctionType.Text = au.GetAuctionTypeNameById(connstring, ai.AuctionType.ToString().Trim());
                lblAuctionConfirmationDeadline.Text = ai.AuctionDeadline.ToString().Trim();
                lblAuctionEventDate.Text            = ai.AuctionStartDate.ToString().Trim();
                lblAuctionStartTime.Text            = ai.AuctionStartTimeHour.ToString().Trim() + ":" +
                                                      ai.AuctionStartTimeMin.ToString().Trim() + ":" +
                                                      ai.AuctionStartTimeSec.ToString().Trim() + " " +
                                                      ai.AuctionStartTimeAMPM.ToString().Trim();
                lblAuctionEndTime.Text = ai.AuctionEndTimeHour.ToString().Trim() + ":" +
                                         ai.AuctionEndTimeMin.ToString().Trim() + ":" +
                                         ai.AuctionEndTimeSec.ToString().Trim() + " " +
                                         ai.AuctionEndTimeAMPM.ToString().Trim();
                lblBidCurrency.Text = oth.GetBidCurrency(ai.BidCurrency.ToString().Trim());

                ShowSuppliers();
                ShowFiles(ai.FileAttachments.ToString().Trim());
                ShowAuctionItems();
            }
        }
    }
Exemple #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
        connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
        if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
        {
            Response.Redirect("../unauthorizedaccess.aspx");
        }

        if (Request.QueryString["brn"] != null)
        {
            Session[Constant.SESSION_BIDREFNO] = Request.QueryString["brn"].ToString();
        }

        if (!(Page.IsPostBack))
        {
            if (Request.QueryString[Constant.SESSION_BIDREFNO] != null)
            {
                Session[Constant.SESSION_BIDREFNO] = Request.QueryString[Constant.SESSION_BIDREFNO].ToString().Trim();
            }

            if (Session["ORDERBY"] == null)
            {
                Session["ORDERBY"] = "DESC";
            }

            BidItem                 bid      = BidItemTransaction.QueryBidItemInfo(connstring, Session[Constant.SESSION_BIDREFNO].ToString());
            BuyerTransaction        buyer    = new BuyerTransaction();
            CategoryTransaction     category = new CategoryTransaction();
            GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
            CompanyTransaction      cmp      = new CompanyTransaction();
            VendorTransaction       vnd      = new VendorTransaction();
            IncotermTransaction     inc      = new IncotermTransaction();
            OtherTransaction        obj      = new OtherTransaction();

            lblBidReferenceNumber.Text = bid.BidRefNo.ToString().Trim();

            lblCompany.Text               = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
            lblRequestor.Text             = bid.Requestor.ToString().Trim();
            lblPRNumber.Text              = bid.PRRefNo.ToString().Trim();
            lblPRDate.Text                = bid.PRDate.ToString().Trim();
            lblGroup.Text                 = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
            lblBidRefNo.Text              = bid.BidRefNo.ToString().Trim();
            lblSubCategory.Text           = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
            lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
            lblBidItemDesc.Text           = bid.ItemDescription.ToString().Trim();
            lblDeliverTo.Text             = bid.DeliverTo.ToString().Trim();
            lblIncoterm.Text              = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());

            DisplayDetails();
            Bind();
        }
    }
Exemple #5
0
    private void FillBidInfo()
    {// Get bid general details
        CategoryTransaction cat = new CategoryTransaction();
        IncotermTransaction inc = new IncotermTransaction();
        CompanyTransaction  cmp = new CompanyTransaction();
        BidItem             bid = BidItemTransaction.GetBidDetailsByRefNo(hdnBidRefNo.Value.Trim());

        lblCompany.Text               = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
        lblCategory.Text              = cat.GetCategoryNameById(bid.Category.ToString().Trim());
        lblBidReferenceNumber.Text    = bid.BidRefNo.ToString();
        lblBidSubmissionDeadline.Text = bid.Deadline;
        lblBidItemDescription.Text    = bid.ItemDescription;
        lblDeliverTo.Text             = bid.DeliverTo;
        lblPreferredIncoterm.Text     = inc.GetIncotermName(connstring, bid.Incoterm);
    }
Exemple #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        //FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
        connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
        //if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
        //    Response.Redirect("../unauthorizedaccess.aspx");

        if (!(IsPostBack))
        {
            if (Request.QueryString[Constant.QS_CATEGORYID] != null)
            {
                hdnCategoryId.Value = Request.QueryString[Constant.QS_CATEGORYID].Trim();
            }
            if (Request.QueryString[Constant.QS_SUBCATEGORYID] != null)
            {
                hdnSubCategoryId.Value = Request.QueryString[Constant.QS_SUBCATEGORYID].Trim();
            }
            if (Request.QueryString[Constant.QS_SEARCHTEXT] != null)
            {
                txtSearch.Text = Request.QueryString[Constant.QS_SEARCHTEXT].Trim();
            }
            if (Request.QueryString[Constant.QS_CONTROLID] != null)
            {
                hdnControlId.Value = Request.QueryString[Constant.QS_CONTROLID].Trim();
            }

            ViewState["SearchString"] = txtSearch.Text.Trim();
            ViewState["Mode"]         = Constant.SHOWSKU.ToString().Trim();

            CategoryTransaction c = new CategoryTransaction();
            lblCategory.Text = c.GetCategoryNameById(connstring, hdnCategoryId.Value.Trim());

            SubCategory s = new SubCategory();
            lblSubCategory.Text = s.GetSubCategoryNameById(connstring, hdnSubCategoryId.Value.Trim());

            btnClose.Attributes.Add("onclick", "Close();");
            btnOK.Attributes.Add("onclick", "SelectProduct('" + hdnControlId.Value + "');");

            ProductsTransaction p = new ProductsTransaction();
            lstProducts.DataSource     = p.QueryProducts(connstring, ViewState["SearchString"].ToString().Trim(), hdnSubCategoryId.Value.Trim(), hdnCategoryId.Value.Trim(), ViewState["Mode"].ToString().Trim());
            lstProducts.DataTextField  = ((ViewState["Mode"].ToString().Trim() == Constant.HIDESKU.ToString().Trim()) ? "ItemName_NoSKU" : "ItemName");
            lstProducts.DataValueField = "VALUE";
            lstProducts.DataBind();
        }
    }
Exemple #7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
        if (!IsPostBack)
        {
            if (!String.IsNullOrEmpty(Request.QueryString[Constant.QS_CATEGORYID]))
            {
                ViewState[Constant.QS_CATEGORYID]    = Request.QueryString[Constant.QS_CATEGORYID];
                ViewState[Constant.QS_SUBCATEGORYID] = Request.QueryString[Constant.QS_SUBCATEGORYID];

                CategoryTransaction ct = new CategoryTransaction();
                lblCategory.Text = ct.GetCategoryNameById(connstring, Request.QueryString[Constant.QS_CATEGORYID]);
                SubCategory st = new SubCategory();
                lblSubCategory.Text = st.GetSubCategoryNameById(connstring, Request.QueryString[Constant.QS_SUBCATEGORYID]).Trim() == "" ? "ALL" : st.GetSubCategoryNameById(Request.QueryString[Constant.QS_SUBCATEGORYID]);
            }
            PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Add One-Time Supplier");
        }
    }
Exemple #8
0
    private void displayDetails()
    {
        if (Request.QueryString[Constant.SESSION_AUCTIONREFNO] != null)
        {
            Session[Constant.SESSION_AUCTIONREFNO] = Request.QueryString[Constant.SESSION_AUCTIONREFNO];
        }

        AuctionItem auctionItem = AuctionItemTransaction.QueryAuctionItemInfo(Session[Constant.SESSION_AUCTIONREFNO].ToString().Trim());

        CategoryTransaction category = new CategoryTransaction();

        lblAuctionReferenceNumber.Text = auctionItem.AuctionRefNo.ToString().Trim();
        lblSubCategory.Text            = category.GetCategoryNameById(auctionItem.Category.ToString().Trim());
        lblDeliveryDate.Text           = auctionItem.DeliveryDate.ToString().Trim();
        lblItemDesc.Text         = auctionItem.ItemDescription.ToString().Trim();
        lblAuctionDeadline.Text  = auctionItem.AuctionDeadline.ToString().Trim();
        lblAuctionDate.Text      = auctionItem.AuctionStartDate.ToString().Trim();
        lblAuctionStartTime.Text = auctionItem.AuctionStartTime.ToString().Trim();
        lblAuctionEndTime.Text   = auctionItem.AuctionEndTime.ToString().Trim();

        DisplayItemDetails(auctionItem.BidRefNo.ToString().Trim());
    }
Exemple #9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
        connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
        if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
        {
            Response.Redirect("../unauthorizedaccess.aspx");
        }

        if (!(Page.IsPostBack))
        {
            Session[Constant.SESSION_COMMENT_TYPE] = "0";
            if (Request.QueryString["BidRefNo"] != null)
            {
                Session["BidRefNo"] = Request.QueryString["BidRefNo"].ToString().Trim();
            }

            BidItem                 bid      = BidItemTransaction.QueryBidItemInfo(connstring, Request.QueryString["BidRefNo"].ToString().Trim());
            BuyerTransaction        buyer    = new BuyerTransaction();
            CategoryTransaction     category = new CategoryTransaction();
            GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
            CompanyTransaction      cmp      = new CompanyTransaction();
            VendorTransaction       vnd      = new VendorTransaction();
            IncotermTransaction     inc      = new IncotermTransaction();
            OtherTransaction        obj      = new OtherTransaction();

            lblCompany.Text               = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
            lblRequestor.Text             = bid.Requestor.ToString().Trim();
            lblPRNumber.Text              = bid.PRRefNo.ToString().Trim();
            lblPRDate.Text                = bid.PRDate.ToString().Trim();
            lblGroup.Text                 = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
            lblBidRefNo.Text              = bid.BidRefNo.ToString().Trim();
            lblSubCategory.Text           = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
            lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
            lblBidItemDesc.Text           = bid.ItemDescription.ToString().Trim();
            lblDeliverTo.Text             = bid.DeliverTo.ToString().Trim();
            lblIncoterm.Text              = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());

            DataTable dtSuppliers = BidItemTransaction.GetSuppliers(connstring, Session["BidRefNo"].ToString().Trim());
            gvSuppliers.DataSource = dtSuppliers;
            gvSuppliers.DataBind();

            DataTable  dtFileAttachment = new DataTable();
            DataColumn dcol1            = new DataColumn("FILES", typeof(System.String));
            dtFileAttachment.Columns.Add(dcol1);

            string   Files  = bid.FileAttachments;
            string[] Files1 = Files.Split(Convert.ToChar("|"));

            for (int i = 0; i < Files1.Length; i++)
            {
                //Create a new row
                DataRow drow = dtFileAttachment.NewRow();
                drow["FILES"] = Files1[i];
                dtFileAttachment.Rows.Add(drow);
            }

            gvFileAttachments.DataSource = dtFileAttachment;
            gvFileAttachments.DataBind();
        }
    }
Exemple #10
0
        private void Display()
        {
            BidItem biditem = BidItemTransaction.QueryBidItemInfo(connstring, ViewState["BidRefNo"].ToString().Trim());
            //BidItemInfo biditem = obj.Query("91000");
            BuyerTransaction        buyer    = new BuyerTransaction();
            CategoryTransaction     category = new CategoryTransaction();
            GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
            CompanyTransaction      cmp      = new CompanyTransaction();
            IncotermTransaction     inc      = new IncotermTransaction();
            OtherTransaction        dte      = new OtherTransaction();

            lblCompany.Text               = cmp.GetCompanyName(connstring, biditem.CompanyId.ToString().Trim());
            lblRequestorName.Text         = biditem.Requestor.ToString().Trim();
            lblPRNumber.Text              = biditem.PRRefNo.ToString().Trim();
            lblPRDate.Text                = biditem.PRDate.ToString().Trim();
            lblGroupDeptSec.Text          = grp.GetGroupDeptSecNameById(connstring, biditem.GroupDeptSec.ToString().Trim());
            lblBidRefNum.Text             = biditem.BidRefNo.ToString().Trim();
            lblSubCategory.Text           = category.GetCategoryNameById(connstring, biditem.Category.ToString().Trim());
            lblBidSubmissionDeadline.Text = biditem.Deadline.ToString().Trim();
            lblBidItemDescription.Text    = biditem.ItemDescription;
            lblDeliverTo.Text             = biditem.DeliverTo;
            lblIncoterm.Text              = inc.GetIncotermName(connstring, biditem.Incoterm);

            DataTable  dtSuppliers = new DataTable();
            DataColumn dcol        = new DataColumn("SUPPLIER", typeof(System.String));

            dtSuppliers.Columns.Add(dcol);

            string suppliers = biditem.Suppliers;

            /*
             *          if (suppliers != "")
             *      btnSubmit.Enabled = true;
             */
            string[] suppliers1 = suppliers.Split(Convert.ToChar(","));

            for (int i = 0; i < suppliers1.Length; i++)
            {
                //Create a new row
                DataRow drow = dtSuppliers.NewRow();
                drow["SUPPLIER"] = suppliers1[i];
                dtSuppliers.Rows.Add(drow);
            }

            gvSuppliers.DataSource = dtSuppliers;
            gvSuppliers.DataBind();

            DataTable  dtFileAttachment = new DataTable();
            DataColumn dcol1            = new DataColumn("FILES", typeof(System.String));

            dtFileAttachment.Columns.Add(dcol1);

            string Files = biditem.FileAttachments;

            string[] Files1 = Files.Split(Convert.ToChar("|"));

            for (int i = 0; i < Files1.Length; i++)
            {
                //Create a new row
                DataRow drow = dtFileAttachment.NewRow();
                drow["FILES"] = Files1[i];
                dtFileAttachment.Rows.Add(drow);
            }

            gvFileAttachments.DataSource = dtFileAttachment;
            gvFileAttachments.DataBind();
        }
Exemple #11
0
        protected void Page_Load(object sender, System.EventArgs e)
        {
            FormsAuthenticationHelper.AuthenticateUserWithReturnUrl();
            connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString());
            if (Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()) != (int)Constant.USERTYPE.BUYER)
            {
                Response.Redirect("../unauthorizedaccess.aspx");
            }


            if (!(Page.IsPostBack))
            {
                if (Session["BidRefNo"] != null)
                {
                    hdnBidRefNo.Value = Session["BidRefNo"].ToString().Trim();
                    BidItem                 bid      = BidItemTransaction.QueryBidItemInfo(connstring, hdnBidRefNo.Value.Trim());
                    BuyerTransaction        buyer    = new BuyerTransaction();
                    CategoryTransaction     category = new CategoryTransaction();
                    GroupDeptSecTransaction grp      = new GroupDeptSecTransaction();
                    CompanyTransaction      cmp      = new CompanyTransaction();
                    SupplierTransaction     vnd      = new SupplierTransaction();
                    IncotermTransaction     inc      = new IncotermTransaction();
                    OtherTransaction        dte      = new OtherTransaction();

                    lblCompany.Text               = cmp.GetCompanyName(connstring, bid.CompanyId.ToString().Trim());
                    lblRequestor.Text             = bid.Requestor.ToString().Trim();
                    lblPRNumber.Text              = bid.PRRefNo.ToString().Trim();
                    lblPRDate.Text                = bid.PRDate.ToString().Trim();
                    lblGroup.Text                 = grp.GetGroupDeptSecNameById(connstring, bid.GroupDeptSec.ToString().Trim());
                    lblBidReferenceNo.Text        = bid.BidRefNo.ToString().Trim();
                    lblSubCategory.Text           = category.GetCategoryNameById(connstring, bid.Category.ToString().Trim());
                    lblBidSubmissionDeadline.Text = bid.Deadline.ToString().Trim();
                    lblBidItemDescription.Text    = bid.ItemDescription.ToString().Trim();
                    lblDeliverTo.Text             = bid.DeliverTo.ToString().Trim();
                    lblIncoterm.Text              = inc.GetIncotermName(connstring, bid.Incoterm.ToString().Trim());
                    lblBidRefNo2.Text             = bid.BidRefNo.ToString().Trim();

                    FillBidItemDetails();
                    //no checking because when bids are submitted they have suppliers
                    gvSuppliers.DataSource = BidItemTransaction.GetSuppliers(connstring, hdnBidRefNo.Value.Trim());
                    gvSuppliers.DataBind();

                    //DataTable dtFileAttachment = new DataTable();
                    //DataColumn dcol1 = new DataColumn("FILES", typeof(System.String));
                    //dtFileAttachment.Columns.Add(dcol1);

                    //string Files = bid.FileAttachments;
                    //string[] Files1 = Files.Split(Convert.ToChar("|"));

                    //for (int i = 0; i < Files1.Length; i++)
                    //{
                    //    //Create a new row
                    //    DataRow drow = dtFileAttachment.NewRow();
                    //    drow["FILES"] = Files1[i];
                    //    dtFileAttachment.Rows.Add(drow);
                    //}

                    //gvFileAttachments.DataSource = dtFileAttachment;
                    //gvFileAttachments.DataBind();
                }
                else
                {
                    Response.Redirect("index.aspx");
                }
            }
        }
Exemple #12
0
        private void DisplayAvailableAndSelectedSuppliers()
        {
            if (hdnCategoryId.Value.Trim() != "")
            {
                CategoryTransaction cat = new CategoryTransaction();
                lblSupplierCategory.Text = cat.GetCategoryNameById(connstring, hdnCategoryId.Value.Trim());

                string allSelectedVendors = "";
                if (hdnSuppliers.Value.Trim() == "")
                {
                    if (hdnOTS.Value.Trim() == "")
                    {
                        allSelectedVendors = "";
                    }
                    else
                    {
                        allSelectedVendors = hdnOTS.Value.Trim();
                    }
                }
                else
                if (hdnOTS.Value.Trim() == "")
                {
                    allSelectedVendors = hdnSuppliers.Value.Trim();
                }
                else
                {
                    allSelectedVendors = hdnSuppliers.Value.Trim() + "," + hdnOTS.Value.Trim();
                }

                SupplierTransaction sup         = new SupplierTransaction();
                DataSet             ds          = sup.GetSuppliersByCategoryId_FilteredList(connstring, hdnCategoryId.Value.Trim(), "", allSelectedVendors);
                DataTable           dtAvailable = new DataTable();
                DataTable           dtSelected  = new DataTable();
                if (ds.Tables.Count > 0)
                {
                    try
                    {
                        if (ds.Tables[0] != null)
                        {
                            dtAvailable = ds.Tables[0];
                        }
                        if (ds.Tables.Count > 1)
                        {
                            if (ds.Tables[1] != null)
                            {
                                dtSelected = ds.Tables[1];
                            }
                        }
                    }
                    catch
                    {
                    }
                }
                lstSupplierA.DataSource     = dtAvailable;
                lstSupplierA.DataTextField  = "VendorName";
                lstSupplierA.DataValueField = "VendorId";
                lstSupplierA.DataBind();

                lstSupplierB.DataSource     = dtSelected;
                lstSupplierB.DataTextField  = "VendorName";
                lstSupplierB.DataValueField = "VendorId";
                lstSupplierB.DataBind();
            }
        }