private void bindgrvSYS_Boarddetail()
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
DataSet dsSelect = new DataSet();
dsSelect = BAL_SYS_Board.BAL_SYS_Board_Select(SYS_Board, "SelectAll");
if (dsSelect.Tables.Count > 0)
{
string searchCondition = string.Empty;
if (txtBoardSearch.Text != string.Empty)
{
searchCondition = "Board like '%" + txtBoardSearch.Text + "%'";
}
if (txtCodeSearch.Text != string.Empty)
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " Code like '%" + txtCodeSearch.Text + "%'";
}
if (rlstActive.SelectedValue == "0")
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " IsActive = 0";
}
else if (rlstActive.SelectedValue == "1")
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " IsActive = 1";
}
DataView dv = new DataView(dsSelect.Tables[0]);
dv.RowFilter = searchCondition;
DataSet dsSelectSub = new DataSet();
dsSelectSub.Tables.Add(dv.ToTable());
GridViewOperations GrvOperation = new GridViewOperations();
GrvOperation.BindGridWithSorting(grvSYS_Boarddetail, dsSelectSub, this.SortField, this.SortDirection);
}
else
{
grvSYS_Boarddetail.DataSource = null;
grvSYS_Boarddetail.DataBind();
}
}
protected void GetBoards()
{
try
{
DataSet dsBoards = new DataSet();
PBoard.boardid = Convert.ToInt32(EnumFile.AssignValue.Zero);
dsBoards = BLBoard.BAL_SYS_Board_Select(PBoard, "Select");
ddlBoardI.DataSource = dsBoards;
ddlBoardI.DataTextField = dsBoards.Tables[0].Columns["Board"].ToString();
ddlBoardI.DataValueField = dsBoards.Tables[0].Columns["BoardID"].ToString();
ddlBoardI.DataBind();
ddlBoardI.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlBoardI.Items[0].Value = ((int)EnumFile.AssignValue.Zero).ToString();
ddlMedium.Items.Clear();
ddlMedium.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlMedium.Items[0].Value = ((int)EnumFile.AssignValue.Zero).ToString();
ddlMedium.Enabled = false;
ddlStandard.Items.Clear();
ddlStandard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --");
ddlStandard.Items[0].Value = ((int)EnumFile.AssignValue.Zero).ToString();
ddlStandard.Enabled = false;
}
catch (Exception)
{
}
}
protected void GetBoards()
{
try
{
DataSet dsBoards = new DataSet();
PBoard.boardid = ((int)EnumFile.AssignValue.Zero);
dsBoards = BLBoard.BAL_SYS_Board_Select(PBoard, "Select");
ddlBoard.DataSource = dsBoards;
ddlBoard.DataTextField = dsBoards.Tables[0].Columns["Board"].ToString();
ddlBoard.DataValueField = dsBoards.Tables[0].Columns["BoardID"].ToString();
ddlBoard.DataBind();
ddlBoard.Items.Insert(((int)EnumFile.AssignValue.Zero), "-- Select --");
ddlBoard.Items[0].Value = ((int)EnumFile.AssignValue.Zero).ToString();
}
catch (Exception)
{
}
}
