private void btnCateSearch_Click(object sender, EventArgs e)
{
try
{
_botcat.Event = "GETALL";
List <BOTopCategory> predict = _batcat.SelectTopCategoryList(_botcat);
if (!string.IsNullOrEmpty(txtCateSearch.Text))
{
predict = predict.Where(topcate => topcate.TopCategoryName.ToUpper().Contains(txtCateSearch.Text.ToUpper())).ToList();
}
int Snu = 0;
DataTable _table = new DataTable();
_table = Common.LINQToDataTable(predict);
dgvTopCategory.Rows.Clear();
foreach (DataRow row in _table.Rows)
{
dgvTopCategory.Rows.Add();
dgvTopCategory.Rows[Snu].Cells[0].Value = Convert.ToString(row["TopCategoryId"]);
dgvTopCategory.Rows[Snu].Cells[1].Value = Convert.ToString(row["TopCategoryName"]);
++Snu;
}
dgvTopCategory.ReadOnly = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void FillTopCategory()
{
BOTopCategory _botopcat = new BOTopCategory();
_botopcat.Event = "GETALL";
List <BOTopCategory> TCateList = btcat.SelectTopCategoryList(_botopcat);
cmbTopCategory.DataSource = TCateList;
cmbTopCategory.DisplayMember = "TopCategoryName";
cmbTopCategory.ValueMember = "TopCategoryID";
}
private void FillTopddlCategory()
{
BATopCategory batcat = new BATopCategory();
DataTable _datatable3 = new DataTable();
_datatable3 = batcat.SelectTopCategoryList("GETALL");
ddlTopCategory.DataTextField = "TopCategoryName";
ddlTopCategory.DataValueField = "TopCategoryID";
ddlTopCategory.DataSource = _datatable3;
ddlTopCategory.DataBind();
FillSecondddlCategory(ddlTopCategory.SelectedItem.Value);
}
private void FilldropDowntopCategory()
{
BATopCategory _batopcat = new BATopCategory();
DataTable _table = new DataTable();
_table = _batopcat.SelectTopCategoryList("GETALL");
drpTopCategory.DataTextField = "TopCategoryName";
drpTopCategory.DataValueField = "TopCategoryID";
drpTopCategory.DataSource = _table;
drpTopCategory.DataBind();
FilldropDownSecondCategory(drpTopCategory.SelectedItem.Value);
}
private void Bind_TopCategoryCombo()
{
BOTopCategory _botopcat = new BOTopCategory();
BATopCategory _batopcat = new BATopCategory();
_botopcat.Event = "GETALL";
List<BOTopCategory> TCateList = _batopcat.SelectTopCategoryList(_botopcat);
if (TCateList.Count > 0)
{
cmbTopcat.DataSource = TCateList;
cmbTopcat.DisplayMember = "TopCategoryName";
cmbTopcat.ValueMember = "TopCategoryID";
}
}
private void FilldropDowntopCategory()
{
BATopCategory _batopcat = new BATopCategory();
_datatable = new DataTable();
_datatable = _batopcat.SelectTopCategoryList("GETALL");
if (_datatable.Rows.Count > 0)
{
drpTopcategory.DataTextField = "TopCategoryName";
drpTopcategory.DataValueField = "TopCategoryID";
drpTopcategory.DataSource = _datatable;
drpTopcategory.DataBind();
}
}
private DataTable FillddlTopCategory()
{
BATopCategory batcat = new BATopCategory();
DataTable _datatable3 = new DataTable();
if (ViewState["dtTopCat"] != null && !ViewState["dtTopCat"].Equals(""))
{
_datatable3 = (DataTable)ViewState["dtTopCat"];
}
else
{
_datatable3 = batcat.SelectTopCategoryList("GETALL");
ViewState["dtTopCat"] = _datatable3;
}
return(_datatable3);
}
private void FillTopCategoryCombo()
{
BOTopCategory _botopcat = new BOTopCategory();
BATopCategory _batopcat = new BATopCategory();
_botopcat.Event = "GETALL";
List <BOTopCategory> TCateList = _batopcat.SelectTopCategoryList(_botopcat);
if (TCateList.Count > 0)
{
cmbTopcate.DataSource = TCateList;
cmbTopcate.DisplayMember = "TopCategoryName";
cmbTopcate.ValueMember = "TopCategoryID";
FillSecondCategoryCombo("GetWithTopCatId", Convert.ToInt32(cmbTopcate.SelectedValue));
}
}
