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.VENDOR) { Response.Redirect("../unauthorizedaccess.aspx"); } if (!(IsPostBack)) { if (Session[Constant.SESSION_USERID] != null) { ViewState[Constant.SESSION_USERID] = Session[Constant.SESSION_USERID].ToString().Trim(); // Get bid general details if (Session[Constant.SESSION_BIDREFNO] != null) { ViewState[Constant.SESSION_BIDREFNO] = Session[Constant.SESSION_BIDREFNO].ToString().Trim(); } CategoryTransaction catTrans = new CategoryTransaction(); BidItem bidItem = BidItemTransaction.GetBidDetailsByRefNo(ViewState[Constant.SESSION_BIDREFNO].ToString().Trim()); lblPRNumber.Text = bidItem.PRRefNo.ToString(); lblBidReferenceNumber.Text = bidItem.BidRefNo.ToString(); lblCategory.Text = catTrans.GetCategoryByID(bidItem.Category).CategoryName; lblBidSubmissionDeadline.Text = bidItem.Deadline; lblDeliveryDate.Text = bidItem.DeliveryDate; lblBidItemDescription.Text = bidItem.ItemDescription; ShowBidTenders(); } } }
public ArrayList GetSubmittedBidTendersByUserId(string connstring, int VendorId) { ArrayList arrBidItemTenders = new ArrayList(); SqlParameter[] sqlParams = new SqlParameter[2]; sqlParams[0] = new SqlParameter("@VendorId", SqlDbType.Int); sqlParams[0].Value = VendorId; sqlParams[1] = new SqlParameter("@BID_STATUS_SUBMITTED", SqlDbType.Int); sqlParams[1].Value = Constant.BID_TENDER_STATUS_SUBMITTED.ToString().Trim(); DataSet ds = SqlHelper.ExecuteDataset(connstring, CommandType.StoredProcedure, "[s3p_EBid_GetSubmittedBidTendersByUserId]", sqlParams); DataTable dt = new DataTable(); //BidItemTransaction bidItemTransaction = new BidItemTransaction(); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { arrBidItemTenders.Add(BidItemTransaction.GetBidDetailsByRefNo(connstring, row["BidRefNo"].ToString())); } } } return(arrBidItemTenders); }
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); }