/// <summary>
/// To search SubMenu details by different conditions
/// </summary>
/// <param name="DvSubMenu"></param>
/// <param name="Column"></param>
/// <param name="Operator"></param>
/// <param name="Value"></param>
public void FilterDataView(DataView DvSubMenu, string Column, string Operator, string Value)
{
DvSubMenu.RowFilter = Column + " " + Operator + "'" + Value + "'";
if (DvSubMenu.ToTable().Rows.Count == 0)
{
MsgSubMenu.Msg = "No Records Found";
MsgSubMenu.showmsg();
ViewState["DtSubMenu"] = DvSubMenu.ToTable();
BindGrid(DvSubMenu.ToTable());
ddlCol.SelectedIndex = 0;
ddlOpeStatus.SelectedIndex = 0;
ddlVal.SelectedIndex = 0;
ddlOpeName.SelectedIndex = 0;
txtValMenuN.Text = null;
}
else
{
BindGrid(DvSubMenu.ToTable());
ViewState["DtSubMenu"] = DvSubMenu.ToTable();
}
}
/// <summary>
/// To Edit SubMenu details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void imbEdit_Click(object sender, ImageClickEventArgs e)
{
ImageButton imbSubMenu = sender as ImageButton;
GridViewRow row = (GridViewRow)imbSubMenu.Parent.Parent;
int Idx = row.RowIndex;
int SubMenuId = Convert.ToInt32(imbSubMenu.CommandArgument.ToString());
lblSelectID.Text = SubMenuId.ToString();
Label lblMeID = (grdSubMenuDetails.Rows[Idx].FindControl("lblMeNa") as Label);
int NewMenuID = Convert.ToInt32(lblMeID.CssClass.ToString());
DataTable dtMenu = GetMenuDetails(NewMenuID);
string MStatus = dtMenu.Rows[0][3].ToString();
if (MStatus == "False")
{
MsgSubMenu.Msg = "Menu is not in Active status, Please activate Menu";
MsgSubMenu.showmsg();
}
else if (MStatus == "True")
{
Session["SubMenuId"] = lblSelectID.Text;
Response.Redirect("SubMenuDetails.aspx", false);
}
}
/// <summary>
/// To Search SubMenu details by specific column
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void imbSearch_Click(object sender, ImageClickEventArgs e)
{
string OpeSubMName = "";
ColSMName = ddlCol.Text;
string Val = ddlVal.Text;
DataTable DtFilter = new DataTable();
DvSubMenu = DtFilter.DefaultView;
if (ColSMName != "Select Column")
{
if (ColSMName == "SubMenuName")
{
OpeSubMName = ddlOpeName.Text;
DtFilter = LoadSubMenu();
DvSubMenu = DtFilter.DefaultView;
Val = txtValMenuN.Text;
}
else if (ColSMName == "IsActive")
{
OpeSubMName = ddlOpeStatus.Text;
}
else if (ColSMName == "MenuID")
{
Val = txtValMenuN.Text;
int ValMID = GetMenuID(Val);
OpeSubMName = ddlOpeStatus.Text;
DtFilter = LoadSubMenu();
DvSubMenu = DtFilter.DefaultView;
if (OpeSubMName == "=")
{
DvSubMenu.RowFilter = ColSMName + " " + OpeSubMName + ValMID;
if (DvSubMenu.ToTable().Rows.Count == 0)
{
MsgSubMenu.Msg = "No Records Found";
MsgSubMenu.showmsg();
}
else
{
ViewState["DtSubMenu"] = DvSubMenu.ToTable();
BindGrid(DvSubMenu.ToTable());
}
}
else if (OpeSubMName == "<>")
{
DtFilter = LoadSubMenu();
DvSubMenu = DtFilter.DefaultView;
DvSubMenu.RowFilter = ColSMName + " " + OpeSubMName + ValMID;
if (DvSubMenu.ToTable().Rows.Count == 0)
{
MsgSubMenu.Msg = "No Records Found";
MsgSubMenu.showmsg();
}
else
{
ViewState["DtSubMenu"] = DvSubMenu.ToTable();
BindGrid(DvSubMenu.ToTable());
}
}
}
if (Val == "Active")
{
Val = "true";
if (OpeSubMName == "=")
{
DtFilter = GetSubMenuDetails(true);
DvSubMenu = DtFilter.DefaultView;
}
else if (OpeSubMName == "<>")
{
DtFilter = GetSubMenuDetails(false);
DvSubMenu = DtFilter.DefaultView;
}
}
else if (Val == "InActive")
{
Val = "false";
if (OpeSubMName == "=")
{
DtFilter = GetSubMenuDetails(false);
DvSubMenu = DtFilter.DefaultView;
}
else if (OpeSubMName == "<>")
{
DtFilter = GetSubMenuDetails(true);
DvSubMenu = DtFilter.DefaultView;
}
}
if (ColSMName == "SubMenuName" || ColSMName == "IsActive")
{
if (OpeSubMName == "Like")
{
Val = "%" + Val + "%";
FilterDataView(DvSubMenu, ColSMName, OpeSubMName, Val);
}
else if (OpeSubMName == "Not Like")
{
FilterDataView(DvSubMenu, ColSMName, OpeSubMName, Val);
}
else if (OpeSubMName == "=")
{
FilterDataView(DvSubMenu, ColSMName, OpeSubMName, Val);
}
else if (OpeSubMName == "<>")
{
FilterDataView(DvSubMenu, ColSMName, OpeSubMName, Val);
}
}
}
}
