public void SearchByNote() { kItemNote = keywordbox.Text; CsFilteredItemList filist = new CsFilteredItemList(kItemName, kItemNote, itemTable); try { ConnectionClass.SearchItemByNote(filist); itemListBoard.DataSource = filist.fiTable; itemListBoard.DataBind(); //keywordbox.Text = string.Empty; } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Sorry, Connection is not stable. Please try again');</script>"); } finally { } }
public static void SearchItemByNote(CsFilteredItemList flist) { string iQuery = string.Format(@"SELECT itemID AS NO,itemCategory AS CATEGORY,itemName AS NAME, itemPPrice AS PurchasePrice,itemRPrice AS RetailPrice, itemQty AS Quantity, convert(varchar, itemRegisterDate,106) AS 'REGISTER DATE' from tblItem WHERE lOWER(itemNote) LIKE LOWER(N'%{0}%') ORDER BY itemRegisterDate DESC;", flist.keyiNote); cmdString = new SqlCommand(iQuery, cntString); try { cntString.Open(); SqlDataAdapter da = new SqlDataAdapter(cmdString); //DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(ds); //ds.Tables.Add(dt); flist.fiTable = ds.Tables[0]; } catch { } finally { cntString.Close(); } }
void ItemViewByCat(string catName) { PagedDataSource pgd = new PagedDataSource(); if (catName == "All") { try { CsItemlist pos = new CsItemlist(itemTable); ConnectionClass.GetItemAll(pos); pgd.DataSource = pos.itemList.DefaultView; } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Sorry, Error Occured during the process, Please select again, ');</script>"); } } else { try { //PagedDataSource pgd = new PagedDataSource(); CsFilteredItemList flist = new CsFilteredItemList(catName, knote, itemTable); ConnectionClass.GetItemByCat(flist); pgd.DataSource = flist.fiTable.DefaultView; } catch { ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('error');</script>"); } //finally } pgd.CurrentPageIndex = CurrentPageIndex; pgd.AllowPaging = true; pgd.PageSize = 8; itemLists.DataSource = pgd; itemLists.DataBind(); BtnPrevious.Enabled = !(pgd.IsLastPage); BtnNext.Enabled = !(pgd.IsFirstPage); }
//PurchasePrice='$'+CONVERT(VARCHAR, itemPPrice),RetailPrice='$'+CONVERT(VARCHAR, itemRPrice) public static void GetItemByCat(CsFilteredItemList fitem) { string kQuery = string.Format(@"SELECT itemID AS NO,itemCategory AS CATEGORY,itemName AS NAME, PurchasePrice='$'+CONVERT(VARCHAR,itemPPrice),RetailPrice='$'+CONVERT(VARCHAR,itemRPrice), itemQty AS Quantity,itemImage AS URL from tblItem WHERE itemCategory=('{0}') ORDER BY itemRegisterDate DESC;", fitem.keyiName); cmdString = new SqlCommand(kQuery, cntString); try { cntString.Open(); SqlDataAdapter da = new SqlDataAdapter(cmdString); DataSet ds = new DataSet(); da.Fill(ds); fitem.fiTable = ds.Tables[0]; } finally { cntString.Close(); } }