/// <summary>
/// Add Update a Menu into the database.
/// </summary>
/// <param name="entity">object of Menu class to be added/updated.</param>
/// <returns>
/// Returns true if add is successful, else false.
/// </returns>
public bool AddUpdateMenu(MenuNav entity)
{
using (var cn = new SqlConnection(_connectionString))
{
bool isAddUpdated = false;
using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Menu.StoreProcedure.usp_AddUpdateMenu, cn, true))
{
SqlParameter paramId = new SqlParameter(DbConstant.Menu.DbParameter.Id, entity.Id);
cmd.Parameters.Add(paramId);
SqlParameter paramMenu = new SqlParameter(DbConstant.Menu.DbParameter.MenuName, entity.MenuName);
cmd.Parameters.Add(paramMenu);
SqlParameter paramDisplayOrder = new SqlParameter(DbConstant.Menu.DbParameter.DisplayOrder, entity.DisplayOrder);
cmd.Parameters.Add(paramDisplayOrder);
SqlParameter paramIsActive = new SqlParameter(DbConstant.Menu.DbParameter.IsActive, entity.IsActive);
cmd.Parameters.Add(paramIsActive);
cn.Open();
var id = cmd.ExecuteScalar();
entity.Id = TypeConversionUtility.ToInteger(id);
isAddUpdated = entity.Id > 0;
}
return isAddUpdated;
}
}
/// <summary>
/// Get the Menu.
/// </summary>
/// <returns>Collection of Menu.</returns>
public IList<MenuNav> GetMenus()
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Menu.StoreProcedure.usp_SelectMenu, cn, true))
{
IList<MenuNav> listMenuNav = null;
cn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
listMenuNav = new List<MenuNav>();
if (reader.HasRows)
{
while (reader.Read())
{
MenuNav menuNav = new MenuNav();
menuNav.Id = TypeConversionUtility.ToInteger(reader[DbConstant.Menu.DbColumn.Id]);
menuNav.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Menu.DbColumn.MenuName]);
menuNav.DisplayOrder = TypeConversionUtility.ToInteger(reader[DbConstant.Menu.DbColumn.DisplayOrder]);
menuNav.IsActive = TypeConversionUtility.ToBoolean(reader[DbConstant.Menu.DbColumn.IsActive]);
menuNav.CreatedDate = TypeConversionUtility.ToDateTime(reader[DbConstant.Menu.DbColumn.CreatedDate]);
listMenuNav.Add(menuNav);
}
}
cn.Close();
}
return listMenuNav;
}
}
}
/// <summary>
/// Get the Menus By Role.
/// </summary>
/// <param name="id"></param>
/// <returns>Collection of Menus.</returns>
public IList<MenuNav> GetMenusByRole(int? roleId = null)
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = SqlHelper.GetSqlCommand(DbConstant.Menu.StoreProcedure.usp_SelectRoleByMenu, cn, true))
{
SqlParameter paramRoleId = new SqlParameter(DbConstant.Menu.DbParameter.RoleId, roleId);
cmd.Parameters.Add(paramRoleId);
IList<MenuNav> listMenuNav = null;
cn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
listMenuNav = new List<MenuNav>();
if (reader.HasRows)
{
while (reader.Read())
{
MenuNav menuNav = new MenuNav();
menuNav.Id = TypeConversionUtility.ToInteger(reader[DbConstant.Role.DbColumn.Id]);
menuNav.MenuName = TypeConversionUtility.ToStringWithNull(reader[DbConstant.Role.DbColumn.MenuName]);
listMenuNav.Add(menuNav);
}
}
cn.Close();
}
return listMenuNav;
}
}
}
/// <summary>
/// Add/Update MenuNav
/// </summary>
/// <returns></returns>
public static bool AddUpdateMenu(MenuNav entity)
{
var sqlMenuNav = new SqlMenu();
bool isAddUpdated = sqlMenuNav.AddUpdateMenu(entity);
return(isAddUpdated);
}
private void Awake()
{
if (instance == null)
{
instance = this;
}
manunav = this.gameObject.GetComponent <MenuNav>();
}
public MenuButton(Texture2D texture, Vector2 Position, MenuNav loc)
{
m_texture = texture;
m_position = Position;
m_navigation = loc;
m_color = Color.White;
CollisionPoint = new Point(10, 10);
CollisionRect = new Rectangle((int)m_position.X, (int)m_position.Y, m_texture.Width, m_texture.Height);
}
private void OnTriggerStay2D(Collider2D collision)
{
if (Input.GetKeyDown("x"))
{
Destroy(gameObject);
isCollected = true;
MenuNav.addItemToInventory();
}
}
public static void completeQuest(string task)
{
foreach (Quest x in required)
{
if (x.getTask().Equals(task))
{
x.markQuestCompleted();
MenuNav.complete(task);
}
}
}
void Awake()
{
//Singleton
if (menuManager == null)
{
menuManager = this;
}
else
{
Destroy(menuManager.gameObject);
menuManager = this;
}
player = GameObject.FindGameObjectWithTag("Player");
menuNav = GetComponent <MenuNav>();
}
public IViewComponentResult Invoke(OpalUser user = null)
{
if (cache.TryGetValue("menuNav", out MenuNav menuNavCache))
{
return(View("Menu", menuNavCache));
}
else
{
MenuNav menuNav = new MenuNav()
{
Languages = translationService.GetLanguages(),
Companies = menuNavbar.GetCompanies(user.Iduser, user.IdMandant),
MenuParents = menuNavbar.GetMenu(user.Iduser, user.IdMandant)
};
cache.Set("menuNav", menuNav, TimeSpan.FromSeconds(60));
return(View("Menu", menuNav));
}
}
void Update()
{
if (LevelScore >= 10000)
{
MenuNav mn = FindObjectOfType <MenuNav>();
mn.ToNextLevel();
}
if (playerHP <= 0)
{
MenuNav mn = FindObjectOfType <MenuNav>();
mn.ToNextLevel();
}
score.GetComponent <TextMeshProUGUI>().text = "Money: " + Money;
if (lastScore != Score)
{
lastScore = Score;
Debug.Log(this.gameObject.name + ": Score is " + Score + "." + System.Environment.NewLine + "Money is " + Money + ".");
}
hp.GetComponent <TextMeshProUGUI>().text = "HP: " + playerHP;
}
public void OnTriggerStay2D(Collider2D other)
{
if (Input.GetKeyDown("x"))
{
if (gameObject.tag.Equals("questr") && needsItem)
{
if (ItemCollect.getCollected())
{
QuestList.completeQuest(quest_tag);
MenuNav.removeItemFromInventory();
}
else
{
PlayLog();
}
}
else
{
PlayLog();
}
}
}
public static void completeQuest(Quest x)
{
x.markQuestCompleted();
MenuNav.complete(x.getTask());
}
public static void addRequiredQuest(string task)
{
required.Add(new Quest(task));
MenuNav.addRequiredQuest(task);
}
public void setMultiPlayer()
{
MenuNav.multiplayer();
}
public void setSinglePlayer()
{
MenuNav.singleplayer();
}
