public static string GetType(int menuId) { string query = string.Format("select Type from vw_Menu where Id = {0}", menuId); var result = DataAccessHelpers.ExecuteScalar(query); if (result.Code < 0) { LogHelpers.Log.Error(result.ErrorMessage); } return(result.Data == null ? "" : result.Data.ToString()); }
public static ResultBOL <object> GetMenuName(int menuId) { string query = string.Format("select Name_VN from vw_Menu where Id = {0}", menuId); if (Utilities.IsLangueEN()) { query = string.Format("select Name_EN from vw_Menu where Id = {0}", menuId); } var result = DataAccessHelpers.ExecuteScalar(query); return(result); }
public static int GetId(string type) { #if DEBUG _log.Debug("type: {0}", type); #endif string query = string.Format("select Id from Menu where [Type] like '{0}' and (ParentId is null or ParentId < 1)", type); ResultBOL <object> result = DataAccessHelpers.ExecuteScalar(query); if (result.Code < 0) { _log.Error(result.ErrorMessage); } else if (result.Data != null) { return(int.Parse(result.Data.ToString())); } return(int.MinValue); }