/// <summary>
/// To get Submenu details of selected menu id
/// </summary>
/// <param name="MenuId"></param>
/// <returns></returns>
private DataTable SubMGridDataSource(int MenuId)
{
SubMenuBAL mBAL = new SubMenuBAL();
DataTable dTable = new DataTable();
try
{
dTable = mBAL.SelectMenuID(MenuId, LoginUser, Ret);
}
catch (Exception ee)
{
}
finally
{
mBAL = null;
}
return(dTable);
}
/// <summary>
/// To get Active Status SubMenu details
/// </summary>
/// <param name="IsActive"></param>
/// <returns></returns>
private DataTable GetSubMenuDetails(bool IsActive)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtGetSubMenu = new DataTable();
try
{
DtGetSubMenu = SubMenuBAL.LoadActiveSubMenu(IsActive, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return(DtGetSubMenu);
}
/// <summary>
/// To get SubMenu details from Business logic layer
/// </summary>
/// <returns></returns>
private DataTable LoadSubMenu()
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtLoadSubMenu = new DataTable();
try
{
DtLoadSubMenu = SubMenuBAL.LoadAllSubMenu(LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return(DtLoadSubMenu);
}
/// <summary>
/// To load submenu details from database
/// </summary>
/// <param name="MenuId"></param>
/// <returns></returns>
private DataTable GetSubMenudetails(int MenuId)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtSubMenuDet = new DataTable();
try
{
DtSubMenuDet = SubMenuBAL.SelectMenuID(MenuId, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return(DtSubMenuDet);
}
/// <summary>
/// To get SubMenu Details from database
/// </summary>
/// <returns></returns>
private DataTable GetSubmenuDetails()
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtGetSubMenu = new DataTable();
try
{
DtGetSubMenu = SubMenuBAL.SelectSubMenuID(SubMenuID, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return(DtGetSubMenu);
}
/// <summary>
/// To get Submenu details from SubMenu Business Access Layer
/// </summary>
/// <param name="menuId"></param>
/// <returns></returns>
private DataTable BinSubMenu(int menuId)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtSubMenu = new DataTable();
try
{
DtSubMenu = SubMenuBAL.SelectMenuID(menuId, LoginUser, Ret);
}
catch
{
}
finally
{
SubMenuBAL = null;
}
return(DtSubMenu);
}
private DataTable getSubMenudetails(int menuId)
{
SubMenuBAL s = new SubMenuBAL();
DataTable dTable = new DataTable();
try
{
dTable = s.SelectMenuID(menuId, LoginUser, Ret);
}
catch
{
}
finally
{
s = null;
}
return(dTable);
}
/// <summary>
/// To save and update SubMenu Details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string Status = ddlSubMenuStatus.SelectedItem.Text;
int MenuID = Convert.ToInt16(ddlMenu.SelectedValue);
int SubMenustatus =1;
if (ddlSubMenuStatus.SelectedItem.Text != "Select SubMenu")
{
if (Status == "Active")
{
SubMenustatus = 1;
}
else
{
SubMenustatus = 0;
}
}
if (btnSave.Text == "Save")
{
int IntResult = 0;
SubMenuBAL SubMenuBAL = new SubMenuBAL();
string SubMenuName = txtSubMenuName.Text;
string SubMenuDesc = txtSubMenuDesc.Text;
string SubMenuURL = txtURL.Text;
try
{
if (txtSubMenuName.Text.Trim() != "" && ddlSubMenuStatus.SelectedItem.Value != null)
{
// 'InsertSubMenu' is SubMenu business Access Layer function called
// to Insert SubMenu details
IntResult = SubMenuBAL.InsertSubMenu(MenuID, SubMenuName, SubMenuDesc, SubMenuURL, SubMenustatus, LoginUser, Ret);
ClearSubMenu();
// Response.Redirect("SubMenuList.aspx", false);
msgSubMenu.Msg = "Menu details submited successfully";
msgSubMenu.showmsg();
}
}
catch (Exception ee)
{
// Duplicate Entry is catched when inserting SubMenu
if (ee.Message == "Duplicate Entry")
{
msgSubMenu.Msg = "Menu already exists";
msgSubMenu.showmsg();
}
}
finally
{
SubMenuBAL = null;
}
}
else if (btnSave.Text == "Update")
{
int IntResult = 0;
SubMenuBAL SubMenuBAL = new SubMenuBAL();
string SubMenuName = txtSubMenuName.Text;
string SubMenuDesc = txtSubMenuDesc.Text;
string SubMenuURL = txtURL.Text;
try
{
// 'UpdateSubMenu' is SubMenu business Access Layer function called
// to update SubMenu details
IntResult = SubMenuBAL.UpdateSubMenu(SubMenuID, SubMenuName, SubMenuDesc, SubMenuURL, SubMenustatus, LoginUser, Ret);
ClearSubMenu();
//Response.Redirect("SubMenuList.aspx",false );
Session["SubMenuID"] = null;
btnSave.Text = "Save";
msgSubMenu.Msg = "Menu details updated successfully";
msgSubMenu.showmsg();
}
catch (Exception ee)
{
// Duplicate Entry is catched when updating SubMenu
if (ee.Message == "Duplicate Entry")
{
msgSubMenu.Msg = "Menu already exists";
msgSubMenu.showmsg();
}
}
finally
{
SubMenuBAL = null;
}
}
}
/// <summary>
/// To get SubMenu Details from database
/// </summary>
/// <returns></returns>
private DataTable GetSubmenuDetails()
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtGetSubMenu = new DataTable();
try
{
DtGetSubMenu = SubMenuBAL.SelectSubMenuID(SubMenuID, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return DtGetSubMenu;
}
private DataTable getSubMenudetails(int menuId)
{
SubMenuBAL s = new SubMenuBAL();
DataTable dTable = new DataTable();
try
{
dTable = s.SelectMenuID(menuId, LoginUser, Ret);
}
catch
{
}
finally
{
s = null;
}
return dTable;
}
/// <summary>
/// To get SubMenu details from Business logic layer
/// </summary>
/// <returns></returns>
private DataTable LoadSubMenu()
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtLoadSubMenu = new DataTable();
try
{
DtLoadSubMenu = SubMenuBAL.LoadAllSubMenu(LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return DtLoadSubMenu;
}
/// <summary>
/// To get Active Status SubMenu details
/// </summary>
/// <param name="IsActive"></param>
/// <returns></returns>
private DataTable GetSubMenuDetails(bool IsActive)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtGetSubMenu = new DataTable();
try
{
DtGetSubMenu = SubMenuBAL.LoadActiveSubMenu(IsActive, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return DtGetSubMenu;
}
/// <summary>
/// To load submenu details from database
/// </summary>
/// <param name="MenuId"></param>
/// <returns></returns>
private DataTable GetSubMenudetails(int MenuId)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtSubMenuDet = new DataTable();
try
{
DtSubMenuDet = SubMenuBAL.SelectMenuID(MenuId, LoginUser, Ret);
}
catch
{
throw;
}
finally
{
SubMenuBAL = null;
}
return DtSubMenuDet;
}
/// <summary>
/// To get Submenu details from SubMenu Business Access Layer
/// </summary>
/// <param name="menuId"></param>
/// <returns></returns>
private DataTable BinSubMenu(int menuId)
{
SubMenuBAL SubMenuBAL = new SubMenuBAL();
DataTable DtSubMenu = new DataTable();
try
{
DtSubMenu = SubMenuBAL.SelectMenuID(menuId, LoginUser, Ret);
}
catch
{
}
finally
{
SubMenuBAL = null;
}
return DtSubMenu;
}
/// <summary>
/// To get Submenu details of selected menu id
/// </summary>
/// <param name="MenuId"></param>
/// <returns></returns>
private DataTable SubMGridDataSource(int MenuId)
{
SubMenuBAL mBAL = new SubMenuBAL();
DataTable dTable = new DataTable();
try
{
dTable = mBAL.SelectMenuID(MenuId, LoginUser, Ret);
}
catch (Exception ee)
{
}
finally
{
mBAL = null;
}
return dTable;
}
/// <summary>
/// To save and update SubMenu Details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string Status = ddlSubMenuStatus.SelectedItem.Text;
int MenuID = Convert.ToInt16(ddlMenu.SelectedValue);
int SubMenustatus = 1;
if (ddlSubMenuStatus.SelectedItem.Text != "Select SubMenu")
{
if (Status == "Active")
{
SubMenustatus = 1;
}
else
{
SubMenustatus = 0;
}
}
if (btnSave.Text == "Save")
{
int IntResult = 0;
SubMenuBAL SubMenuBAL = new SubMenuBAL();
string SubMenuName = txtSubMenuName.Text;
string SubMenuDesc = txtSubMenuDesc.Text;
string SubMenuURL = txtURL.Text;
try
{
if (txtSubMenuName.Text.Trim() != "" && ddlSubMenuStatus.SelectedItem.Value != null)
{
// 'InsertSubMenu' is SubMenu business Access Layer function called
// to Insert SubMenu details
IntResult = SubMenuBAL.InsertSubMenu(MenuID, SubMenuName, SubMenuDesc, SubMenuURL, SubMenustatus, LoginUser, Ret);
ClearSubMenu();
// Response.Redirect("SubMenuList.aspx", false);
msgSubMenu.Msg = "Menu details submited successfully";
msgSubMenu.showmsg();
}
}
catch (Exception ee)
{
// Duplicate Entry is catched when inserting SubMenu
if (ee.Message == "Duplicate Entry")
{
msgSubMenu.Msg = "Menu already exists";
msgSubMenu.showmsg();
}
}
finally
{
SubMenuBAL = null;
}
}
else if (btnSave.Text == "Update")
{
int IntResult = 0;
SubMenuBAL SubMenuBAL = new SubMenuBAL();
string SubMenuName = txtSubMenuName.Text;
string SubMenuDesc = txtSubMenuDesc.Text;
string SubMenuURL = txtURL.Text;
try
{
// 'UpdateSubMenu' is SubMenu business Access Layer function called
// to update SubMenu details
IntResult = SubMenuBAL.UpdateSubMenu(SubMenuID, SubMenuName, SubMenuDesc, SubMenuURL, SubMenustatus, LoginUser, Ret);
ClearSubMenu();
//Response.Redirect("SubMenuList.aspx",false );
Session["SubMenuID"] = null;
btnSave.Text = "Save";
msgSubMenu.Msg = "Menu details updated successfully";
msgSubMenu.showmsg();
}
catch (Exception ee)
{
// Duplicate Entry is catched when updating SubMenu
if (ee.Message == "Duplicate Entry")
{
msgSubMenu.Msg = "Menu already exists";
msgSubMenu.showmsg();
}
}
finally
{
SubMenuBAL = null;
}
}
}
