private void ViewCompany()
{
int group = 2;
CompanyBSO companyBSO = new CompanyBSO();
DataTable table = new DataTable();
if (!Session["Admin_UserName"].Equals("administrator"))
{
string strCate = GetCateParentIDArrayByID(group);
if (strCate != "")
table = companyBSO.GetCompanyByCateHomeList(strCate);
}
else
{
table = companyBSO.GetCompanyAll(Language.language);
}
commonBSO commonBSO = new commonBSO();
commonBSO.FillToGridView(grvCompany, table);
BindCateSearch(group);
}
protected void btn_search_Click(object sender, EventArgs e)
{
if (txtKeyword.Text != "")
{
int cId = Convert.ToInt32(ddlCateNewsSearch.SelectedValue);
CompanyBSO companyBSO = new CompanyBSO();
DataTable table = companyBSO.GetCompanyAll(Language.language, Convert.ToInt32(hddGroup.Value));
DataView dataView = new DataView(table);
string sqlCate = "";
if (cId != 0)
{
sqlCate += " and Categories = " + cId;
}
string keySearch = "Title like '%" + txtKeyword.Text + "%' or Description like '%" + txtKeyword.Text + "%'";
keySearch += sqlCate;
dataView.RowFilter = keySearch;
grvCompany.DataSource = dataView;
grvCompany.DataBind();
BindCateSearch(Convert.ToInt32(hddGroup.Value));
}
}
