private void displaySuppliers() { //BidItemTransaction vnd = new BidItemTransaction(); gvInvitedSuppliers.DataSource = BidItemTransaction.GetSuppliers(connstring, ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); // gvInvitedSuppliers.DataSource = dtVendors; gvInvitedSuppliers.DataBind(); }
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(); } }
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"); } } }