public void SetMenuItem(MenuItemModel menuItem)
{
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{/*
* command.CommandText =
* @"UPDATE S_MENUS
* SET MENU_NAME = " + ParameterString(menuItem.Name) + @"
* , MENU_TEXT = " + ParameterString(menuItem.Text) + @"
* , CSS_CLASS = " + ParameterString(menuItem.ClassCSS) + @"
* WHERE ID = " + ParameterInt(menuItem.ID);
* command.ExecuteNonQuery();*/
}
}
public MenuItemModel GetMenuItem(int itemID)
{
MenuItemModel menuItem = null;
using (SQLiteCommand command = new SQLiteCommand(base.SQLConnection))
{
command.CommandText =
@"SELECT mmi.ID
, mmi.ITEM_TEXT
, mmi.MENU_ID
, mmi.PARENT_ID
, mmi.MENU_ITEM_TYPE_ID
, mmi.ORDER_NO
, mmi.ITEM_VALUE
, mmi.LINK_AREA
, mmi.LINK_CONTROLLER
, mmi.LINK_ACTION
FROM S_MENU_ITEMS mmi
WHERE mmi.ID = " + ParameterInt(itemID);
using (SQLiteDataReader dReader = command.ExecuteReader())
{
if (dReader.HasRows && dReader.Read())
{
menuItem = new MenuItemModel
{
ID = ParseInt(dReader["ID"].ToString()),
Text = dReader["ITEM_TEXT"].ToString(),
MenuID = ParseInt(dReader["MENU_ID"].ToString()),
ParentID = ParseInt(dReader["PARENT_ID"].ToString()),
TypeID = ParseInt(dReader["MENU_ITEM_TYPE_ID"].ToString()),
OrderNo = ParseInt(dReader["ORDER_NO"].ToString()),
LinkValue = dReader["ITEM_VALUE"].ToString(),
LinkArea = dReader["LINK_AREA"].ToString(),
LinkController = dReader["LINK_CONTROLLER"].ToString(),
LinkAction = dReader["LINK_ACTION"].ToString()
};
}
}
menuItem.TypeList = GetMenuItemTypes(menuItem.TypeID);
}
return(menuItem);
}