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);
}
