public static void Create(MenuDataModel menu)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_CreateMenu", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramID = new MySqlParameter("pID", menu.ID);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
MySqlParameter paramName = new MySqlParameter("pName", menu.Name);
paramName.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramName);
MySqlParameter paramURL = new MySqlParameter("pURL", menu.URL);
paramURL.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramURL);
MySqlParameter paramMenuOrder = new MySqlParameter("pMenuOrder", menu.MenuOrder);
paramMenuOrder.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramMenuOrder);
MySqlParameter paramMenuID = new MySqlParameter("pMenuID", menu.MenuID);
paramMenuID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramMenuID);
DataTable results = new DataTable();
adapter.Fill(results);
}
public override void Create(MenuDataModel menu)
{
if (HttpContext.Current.Session["menuParentID"] != null)
{
menu.MenuID = Convert.ToInt32(HttpContext.Current.Session["menuParentID"]);
}
base.Create(menu);
}
public virtual void Update(MenuDataModel menu)
{
if (menu.ID > 0)
{
MenuDAL.Update(menu);
}
else
{
throw new Exception("Page not found");
}
}
public ActionResult Edit(MenuDataModel menu)
{
MenuBO.GetInstance().Update(menu);
if (Session["menuParentID"] != null)
{
return RedirectToAction("Index", new { id = Convert.ToInt32(Session["menuParentID"]) });
}
else
{
return RedirectToAction("Index");
}
}
public static List<MenuDataModel> GetMenuItems(string menuName)
{
List<MenuDataModel> menus = new List<MenuDataModel>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetMenuItems", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
MySqlParameter paramID = new MySqlParameter("pMenuName", menuName);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.Parameters.Add(paramID);
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow item in results.Rows)
{
MenuDataModel menu = new MenuDataModel();
if (item["ID"].GetType() != typeof(DBNull))
{
menu.ID = Convert.ToInt32(item["ID"]);
}
if (item["Name"].GetType() != typeof(DBNull))
{
menu.Name = Convert.ToString(item["Name"]);
}
if (item["URL"].GetType() != typeof(DBNull))
{
menu.URL = Convert.ToString(item["URL"]);
}
if (item["MenuOrder"].GetType() != typeof(DBNull))
{
menu.MenuOrder = Convert.ToInt32(item["MenuOrder"]);
}
if (item["MenuID"].GetType() != typeof(DBNull))
{
menu.MenuID = Convert.ToInt32(item["MenuID"]);
}
menus.Add(menu);
}
return menus;
}
public static MenuDataModel Get(int id)
{
MenuDataModel menu = null;
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("Core_GetMenuByID", connection);
MySqlParameter paramID = new MySqlParameter("pId", id);
paramID.Direction = ParameterDirection.Input;
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(paramID);
DataTable results = new DataTable();
adapter.Fill(results);
if (results.Rows.Count > 0)
{
DataRow item = results.Rows[0];
menu = new MenuDataModel();
if (item["ID"].GetType() != typeof(DBNull))
{
menu.ID = Convert.ToInt32(item["ID"]);
}
if (item["Name"].GetType() != typeof(DBNull))
{
menu.Name = Convert.ToString(item["Name"]);
}
if (item["URL"].GetType() != typeof(DBNull))
{
menu.URL = Convert.ToString(item["URL"]);
}
if (item["MenuOrder"].GetType() != typeof(DBNull))
{
menu.MenuOrder = Convert.ToInt32(item["MenuOrder"]);
}
if (item["MenuID"].GetType() != typeof(DBNull))
{
menu.MenuID = Convert.ToInt32(item["MenuID"]);
}
}
return menu;
}
public static List<MenuDataModel> GetParentMenus()
{
List<MenuDataModel> menus = new List<MenuDataModel>();
MySqlConnection connection = new MySqlConnection(ConfigurationManager.AppSettings[BusinessUtilies.Const.Database.AppSetting]);
MySqlDataAdapter adapter = new MySqlDataAdapter("GetParentMenus", connection);
DataTable results = new DataTable();
adapter.Fill(results);
foreach (DataRow item in results.Rows)
{
MenuDataModel menu = new MenuDataModel();
if (item["ID"].GetType() != typeof(DBNull))
{
menu.ID = Convert.ToInt32(item["ID"]);
}
if (item["Name"].GetType() != typeof(DBNull))
{
menu.Name = Convert.ToString(item["Name"]);
}
if (item["URL"].GetType() != typeof(DBNull))
{
menu.URL = Convert.ToString(item["URL"]);
}
if (item["MenuOrder"].GetType() != typeof(DBNull))
{
menu.MenuOrder = Convert.ToInt32(item["MenuOrder"]);
}
if (item["MenuID"].GetType() != typeof(DBNull))
{
menu.MenuID = Convert.ToInt32(item["MenuID"]);
}
menus.Add(menu);
}
return menus;
}
public virtual void Create(MenuDataModel menu)
{
MenuDAL.Create(menu);
}
public override void Update(MenuDataModel menu)
{
CacheManager cache = CacheManager.GetInstance();
cache.UpdateObject<MenuDataModel>(menu);
base.Update(menu);
}