protected void Page_Load(object sender, EventArgs e) { FormsAuthenticationHelper.AuthenticateUserWithReturnUrl(); connstring = Client.ConnectionString(HttpContext.Current.Session["clientid"].ToString()); PageTitle.InnerText = String.Format(Constant.TITLEFORMAT, "Search Result"); if (!(IsPostBack)) { if ((Session[Constant.SESSION_USERID] != null) && (Session[Constant.SESSION_USERTYPE] != null)) { ViewState[Constant.SESSION_USERID] = Int32.Parse(Session[Constant.SESSION_USERID].ToString().Trim()); int userID = Int32.Parse(ViewState[Constant.SESSION_USERID].ToString().Trim()); int usertype = Int32.Parse(Session[Constant.SESSION_USERTYPE].ToString().Trim()); string searchstring = ""; int searchType = 1; if (Request.QueryString["searchstring"] != null) { searchstring = Request.QueryString["searchstring"].ToString().Trim(); } if (Request.QueryString["searchType"] != null) { searchType = Int32.Parse(Request.QueryString["searchType"].ToString().Trim()); } if ((searchType >= 1) && (searchType <= 6)) { if ((searchType >= 1) && (searchType <= 3)) { gvSearchResultForItems.Columns[0].HeaderText = "Bid Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Bid Items"; } else { gvSearchResultForItems.Columns[0].HeaderText = "Auction Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Auction Items"; } gvSearchResultForItems.Visible = true; // BidItemTransaction items = new BidItemTransaction(); DataTable dtItems = BidItemTransaction.QuerySearchedItemByItemDesc(connstring, searchType, searchstring, usertype, userID); if (dtItems.Rows.Count > 0) { DataView dvItems = new DataView(dtItems); gvSearchResultForItems.DataSource = dvItems; gvSearchResultForItems.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } else if (searchType == 7) { ProductsTransaction products = new ProductsTransaction(); DataTable dtProducts = products.QueryProductsViaName(connstring, searchstring); // DataView dvProducts = new DataView(dtProducts); if (dtProducts.Rows.Count > 0) { gvProducts.Visible = true; gvProducts.DataSource = dtProducts; gvProducts.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } else if (searchType == 8) { CompanyTransaction vendor = new CompanyTransaction(); DataTable dtVendor = vendor.QueryVendorSearch(connstring, searchstring); if (dtVendor.Rows.Count > 0) { DataView dvVendor = new DataView(dtVendor); gvSuppliers.Visible = true; gvSuppliers.DataSource = dvVendor; gvSuppliers.DataBind(); } else { lblIsEmpty.Visible = true; lblIsEmpty.Text = "No matches for '" + searchstring + "' found."; } } } } }
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { ViewState[Constant.SESSION_USERID] = Int32.Parse(Session[Constant.SESSION_USERID].ToString().Trim()); int userID = Int32.Parse(ViewState[Constant.SESSION_USERID].ToString().Trim()); string usertype = Session[Constant.SESSION_USERTYPE].ToString().Trim(); if (Request.QueryString["usertype"] != null) { usertype = Request.QueryString["usertype"].ToString().Trim(); } string searchstring = ""; if (Request.QueryString["searchstring"] != null) { searchstring = Request.QueryString["searchstring"].ToString().Trim(); } string searchType = "1"; if (Request.QueryString["searchType"] != null) { searchType = Request.QueryString["searchType"].ToString().Trim(); } if ((Int32.Parse(searchType) >= 1) && (Int32.Parse(searchType) <= 6)) { if ((Int32.Parse(searchType) >= 1) && (Int32.Parse(searchType) <= 3)) { gvSearchResultForItems.Columns[0].HeaderText = "Bid Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Bid Items"; } else { gvSearchResultForItems.Columns[0].HeaderText = "Auction Reference No."; gvSearchResultForItems.Columns[1].HeaderText = "Auction Items"; } gvSearchResultForItems.Visible = true; DataTable dtItems = BidItemTransaction.QuerySearchedItemByItemDesc(connstring, Int32.Parse(searchType), searchstring, Int32.Parse(usertype), userID); DataView dvItems = new DataView(dtItems); gvSearchResultForItems.DataSource = dvItems; gvSearchResultForItems.PageIndex = e.NewPageIndex; gvSearchResultForItems.DataBind(); } else if (Int32.Parse(searchType) == 7) { ProductsTransaction products = new ProductsTransaction(); DataTable dtProducts = products.QueryProductsViaName(connstring, searchstring); gvProducts.Visible = true; gvProducts.DataSource = dtProducts; gvProducts.PageIndex = e.NewPageIndex; gvProducts.DataBind(); } else if (Int32.Parse(searchType) == 8) { CompanyTransaction vendor = new CompanyTransaction(); DataTable dtVendor = vendor.QueryVendorSearch(connstring, searchstring); DataView dvVendor = new DataView(dtVendor); gvSuppliers.Visible = true; gvSuppliers.DataSource = dvVendor; gvSuppliers.PageIndex = e.NewPageIndex; gvSuppliers.DataBind(); } }