public static List <MenuCategoryXMenuDataModel> GetEntityDetails(MenuCategoryXMenuDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.MenuCategoryXMenuSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationMode = requestProfile.ApplicationModeId , ApplicationId = requestProfile.ApplicationId , MenuId = dataQuery.MenuId , MenuCategoryId = dataQuery.MenuCategoryId , MenuCategoryXMenuId = dataQuery.MenuCategoryXMenuId , MenuCategory = dataQuery.MenuCategory }; List <MenuCategoryXMenuDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <MenuCategoryXMenuDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public List <MenuDataModel> GetUserPreferedMenu() { var listResult = new List <MenuDataModel>(); var data = new MenuCategoryXMenuDataModel(); try { data.MenuCategoryId = Convert.ToInt32(SessionVariables.UserMenuCategory); } catch { data.MenuCategoryId = 0; } var listMenuCategoryXMenu = Framework.Components.Core.MenuCategoryXMenuDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); var listSiteMenu = SessionVariables.SiteMenuData; // filter site menu for current application module listResult = listSiteMenu .Where(x => x.ApplicationModule == SessionVariables.CurrentApplicationModuleCode) .ToList(); var applicationMenuIds = listMenuCategoryXMenu.Select(x => x.MenuId).ToList(); try { // appply filter to retreived records from db listResult = listResult .Where(x => applicationMenuIds.Contains(x.MenuId.Value)).ToList(); } catch { listResult.Clear(); } //var filterCondition = MenuDataModel.DataColumns.PrimaryDeveloper + " = '" + SessionVariables.UserMenuCategory + "'"; //filterCondition += "and " + MenuDataModel.DataColumns.ApplicationModule + " = '" + SessionVariables.CurrentApplicationModuleCode + "'"; var searchResult = listSiteMenu.Where(x => x.PrimaryDeveloper == SessionVariables.UserMenuCategory).ToList(); if (searchResult.Count > 0) { foreach (var objMenuDataModel in searchResult) { if (!listResult.Contains(objMenuDataModel)) { listResult.Add(objMenuDataModel); } } } listResult = MenuHelper.SetUserPreferenceMenu(listResult); return(listResult); }
public static string ToSQLParameter(MenuCategoryXMenuDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case MenuCategoryXMenuDataModel.DataColumns.MenuCategoryXMenuId: if (data.MenuCategoryXMenuId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryXMenuId, data.MenuCategoryXMenuId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryXMenuId); } break; case MenuCategoryXMenuDataModel.DataColumns.MenuId: if (data.MenuId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MenuCategoryXMenuDataModel.DataColumns.MenuId, data.MenuId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MenuCategoryXMenuDataModel.DataColumns.MenuId); } break; case MenuCategoryXMenuDataModel.DataColumns.MenuCategoryId: if (data.MenuCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryId, data.MenuCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryId); } break; case MenuCategoryXMenuDataModel.DataColumns.MenuCategory: if (!string.IsNullOrEmpty(data.MenuCategory)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, MenuCategoryXMenuDataModel.DataColumns.MenuCategory, data.MenuCategory); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, MenuCategoryXMenuDataModel.DataColumns.MenuCategory); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static void Create(MenuCategoryXMenuDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.MenuCategoryXMenuInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.ApplicationId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryId); DBDML.RunSQL("MenuCategoryXMenu_Insert", sql, DataStoreKey); }
public static DataTable Search(MenuCategoryXMenuDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.MenuCategoryXMenuSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationMode, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryId) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuCategory) + ", " + ToSQLParameter(data, MenuCategoryXMenuDataModel.DataColumns.MenuCategoryXMenuId); var oDT = new DBDataTable("Menu.Search", sql, DataStoreKey); return(oDT.DBTable); }