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();
}
}
