public ActionResult AddMenuItem(MenuItem m_MenuItem)
{
if (ModelState.IsValid)
{
MenuItemRepository.Create(m_MenuItem);
return RedirectToAction("MenuItems", "Menu", new { id = m_MenuItem.ParentId });
}
else
{
ViewBag.ParentId = m_MenuItem.ParentId;
return View("AddMenuItem", m_MenuItem);
}
}
public static void Create(MenuItem m_MenuItem)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
int sortOrder = getSortOrder(m_MenuItem.ParentId);
string queryString = "INSERT INTO CMS_MenuItems(parentId, menuItemName, linkUrl, pageWorkFlowState, sortOrder) VALUES(@parentId, @menuItemName, @linkUrl, 0, @sortOrder)";
SqlCommand insertMenuItem = new SqlCommand(queryString, conn);
insertMenuItem.Parameters.AddWithValue("parentId", m_MenuItem.ParentId);
insertMenuItem.Parameters.AddWithValue("menuItemName", m_MenuItem.MenuItemName);
insertMenuItem.Parameters.AddWithValue("linkUrl", m_MenuItem.LinkUrl);
insertMenuItem.Parameters.AddWithValue("sortOrder", sortOrder);
insertMenuItem.ExecuteNonQuery();
conn.Close();
}
public ActionResult AddMenuItem(int id)
{
ViewBag.ParentId = id;
MenuItem m_MenuItem = new MenuItem();
return View("AddMenuItem", m_MenuItem);
}
public ActionResult EditMenuItem(MenuItem m_MenuItem)
{
if (ModelState.IsValid)
{
MenuItemRepository.Update(m_MenuItem);
return RedirectToAction("MenuItems", "Menu", new { id = m_MenuItem.ParentId });
}
else
{
return View("EditMenuItem", m_MenuItem);
}
}
public static List<MenuItem> RetrieveAll(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_MenuItems WHERE parentId = @parentId AND pageWorkFlowState != 4 ORDER BY sortOrder";
SqlCommand getMenuItems = new SqlCommand(queryString, conn);
getMenuItems.Parameters.AddWithValue("parentId", id);
SqlDataReader menuDataReader = getMenuItems.ExecuteReader();
List<MenuItem> m_MenuItems = new List<MenuItem>();
while (menuDataReader.Read())
{
MenuItem tempMenuItem = new MenuItem();
tempMenuItem.Id = menuDataReader.GetInt32(0);
tempMenuItem.ParentId = menuDataReader.GetInt32(1);
tempMenuItem.MenuItemName = menuDataReader.GetString(2);
tempMenuItem.LinkUrl = menuDataReader.GetString(3);
tempMenuItem.PageWorkFlowState = menuDataReader.GetInt32(4);
m_MenuItems.Add(tempMenuItem);
}
conn.Close();
return m_MenuItems;
}
public static void Update(MenuItem m_MenuItem)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "UPDATE CMS_MenuItems SET menuItemName = @menuItemName, linkUrl = @linkUrl WHERE id = @id";
SqlCommand updateMenuItem = new SqlCommand(queryString, conn);
updateMenuItem.Parameters.AddWithValue("menuItemName", m_MenuItem.MenuItemName);
updateMenuItem.Parameters.AddWithValue("linkUrl", m_MenuItem.LinkUrl);
updateMenuItem.Parameters.AddWithValue("id", m_MenuItem.Id);
updateMenuItem.ExecuteNonQuery();
conn.Close();
}
public static MenuItem RetrieveOne(int id)
{
SqlConnection conn = DB.DbConnect();
conn.Open();
string queryString = "SELECT * FROM CMS_MenuItems WHERE id = @id AND pageWorkFlowState != 4";
SqlCommand getMenuItem = new SqlCommand(queryString, conn);
getMenuItem.Parameters.AddWithValue("id", id);
SqlDataReader menuDateReader = getMenuItem.ExecuteReader();
MenuItem m_MenuItem = new MenuItem();
if (menuDateReader.Read())
{
m_MenuItem.Id = menuDateReader.GetInt32(0);
m_MenuItem.ParentId = menuDateReader.GetInt32(1);
m_MenuItem.MenuItemName = menuDateReader.GetString(2);
m_MenuItem.LinkUrl = menuDateReader.GetString(3);
m_MenuItem.PageWorkFlowState = menuDateReader.GetInt32(4);
m_MenuItem.SortOrder = menuDateReader.GetInt32(5);
}
conn.Close();
return m_MenuItem;
}
public void Update(MenuItem m_MenuItem)
{
DBMenuItem.Update(m_MenuItem);
}
public void Create(MenuItem m_MenuItem)
{
DBMenuItem.Create(m_MenuItem);
}