public Domain.Menu ToPoco()
{
var menu = new Domain.Menu();
menu.Name = this.Name;
menu.MenuItems = this.MenuItems.Select(i => i.ToPoco()).ToList();
return(menu);
}
public Domain.Menu GetCurrentMenu()
{
Domain.Menu menu = null;
string url = httpContext.Request.Url.AbsolutePath;
using (var work = new Data.UnitOfWork())
{
menu = work.MenuRepository.GetByUrl(url);
}
return(menu);
}
public void Update(Domain.Menu menu)
{
var sql = "UPDATE dbo.T_Menu SET [Name]=@NAME,[Address]=@ADDRESS,[SortLevel]=@SORTLEVEL,[Remark]=@REMARK,[Valid]=@VALID,Display=@Display WHERE [Id]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", menu.Id);
dbOperator.AddParameter("NAME", menu.Name);
dbOperator.AddParameter("ADDRESS", DBNull.Value);
dbOperator.AddParameter("SORTLEVEL", menu.SortLevel);
dbOperator.AddParameter("REMARK", menu.Remark ?? string.Empty);
dbOperator.AddParameter("VALID", menu.Valid);
dbOperator.AddParameter("Display", menu.Display);
dbOperator.ExecuteNonQuery(sql);
}
}
public void MenuFactoryTest_EditMenu_Success()
{
//1. arrange
var menu = new Domain.Menu()
{
Name = "a",
SubMenus = new List <Domain.Menu>()
{
new Domain.Menu()
{
Name = "b",
MenuItems = new List <Domain.MenuItem>()
{
new Domain.MenuItem()
{
Name = "c", Url = "d"
},
}
},
},
MenuItems = new List <Domain.MenuItem>()
{
new Domain.MenuItem()
{
Name = "e", Url = "f"
},
}
};
string menuJson = "{ 'name': 'a', 'SubMenus': ["
+ " { 'name': 'b', 'MenuItems': [ { 'name' : 'c' , 'url': 'd' } ] } "
+ "], 'MenuItems': [ { 'name' : 'e' , 'url': 'f' } ] }";
_fileMock.Setup(f => f.TryEditFile(It.IsAny <string>(), It.IsAny <string>()))
.Returns(true);
//2. act
Domain.Menu result = _menuFactory.EditMenu("3", menu);
//3. assert
_fileMock.Verify(f => f.TryEditFile(
It.Is <string>(s => s == "1\\3\\2"),
It.IsAny <string>()
), Times.Once());
Assert.Equal <Domain.Menu>(menu, result);
}
private IEnumerable <Domain.Menu> constructMenus(DbDataReader reader)
{
var result = new List <Domain.Menu>();
Domain.Menu menu = null;
Domain.SubMenu submenu = null;
while (reader.Read())
{
var currentMenuId = DataHelper.GetGuid(reader["MenuId"]);
if (menu == null || menu.Id != currentMenuId)
{
menu = new Domain.Menu(currentMenuId, DataHelper.GetString(reader["MenuName"]))
{
Remark = DataHelper.GetString(reader["MenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["MenuSortLevel"]),
Valid = DataHelper.GetBoolean(reader["MenuValid"]),
Display = reader["MenuDisplay"] == DBNull.Value || DataHelper.GetBoolean(reader["MenuDisplay"])
};
submenu = null;
result.Add(menu);
}
var currentSubMenuId = DataHelper.GetGuid(reader["SubMenuId"]);
if (submenu == null || submenu.Id != currentSubMenuId)
{
submenu = new Domain.SubMenu(currentSubMenuId, DataHelper.GetString(reader["SubMenuName"]), DataHelper.GetString(reader["SubMenuAddress"]))
{
Remark = DataHelper.GetString(reader["SubMenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["SubMenuSortLevel"]),
Valid = DataHelper.GetBoolean(reader["SubMenuValid"]),
Display = reader["SubMenuDisplay"] == DBNull.Value || DataHelper.GetBoolean(reader["SubMenuDisplay"])
};
menu.AppendChild(submenu);
}
if (reader["ResourceId"] != DBNull.Value)
{
submenu.AppendResource(new Domain.Resource(DataHelper.GetGuid(reader["ResourceId"]))
{
Name = DataHelper.GetString(reader["ResourceName"]),
Address = DataHelper.GetString(reader["ResourceAddress"]),
Remark = DataHelper.GetString(reader["ResourceRemark"]),
Valid = DataHelper.GetBoolean(reader["ResourceValid"])
});
}
}
return(result);
}
public void Register(Website website, Domain.Menu menu)
{
var sql = "INSERT INTO dbo.T_Menu ([Id],[Name],[Address],[SortLevel],[Depth],[Remark],[Valid],Display,[Parent],[Website])" +
" VALUES (@ID,@NAME,@ADDRESS,@SORTLEVEL,@DEPTH,@REMARK,@VALID,@Display,@PARENT,@WEBSITE)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", menu.Id);
dbOperator.AddParameter("NAME", menu.Name);
dbOperator.AddParameter("ADDRESS", DBNull.Value);
dbOperator.AddParameter("SORTLEVEL", menu.SortLevel);
dbOperator.AddParameter("DEPTH", 1);
dbOperator.AddParameter("REMARK", menu.Remark ?? string.Empty);
dbOperator.AddParameter("VALID", menu.Valid);
dbOperator.AddParameter("Display", menu.Display);
dbOperator.AddParameter("PARENT", DBNull.Value);
dbOperator.AddParameter("WEBSITE", (byte)website);
dbOperator.ExecuteNonQuery(sql);
}
}
public void MenuFactoryTest_GetMenu_Success()
{
//1. arrange
string menuJson = "{ 'name': 'a', 'SubMenus': ["
+ " { 'name': 'b', 'MenuItems': [ { 'name' : 'c' , 'url': 'd' } ] } "
+ "], 'MenuItems': [ { 'name' : 'e' , 'url': 'f' } ] }";
_fileMock.Setup(f => f.TryReadFile(It.IsAny <string>()))
.Returns(menuJson);
//2. act
Domain.Menu menu = _menuFactory.GetMenu("");
//3. assert
Assert.Equal("a", menu.Name);
Assert.Equal("b", menu.SubMenus.FirstOrDefault().Name);
Assert.Equal("c", menu.SubMenus.FirstOrDefault().MenuItems.FirstOrDefault().Name);
Assert.Equal("d", menu.SubMenus.FirstOrDefault().MenuItems.FirstOrDefault().Url);
Assert.Equal("e", menu.MenuItems.FirstOrDefault().Name);
Assert.Equal("f", menu.MenuItems.FirstOrDefault().Url);
}
public CreateCategoryFixture(Domain.Menu menu, CreateCategoryRequest newCategory, IOptions <JwtBearerAuthenticationConfiguration> jwtBearerAuthenticationOptions)
: base(jwtBearerAuthenticationOptions)
{
this.existingMenu = menu;
this.newCategory = newCategory;
}
public Menu(Domain.Menu menu)
{
this.Name = menu.Name;
this.SubMenus = menu.SubMenus.Select(sm => new ViewModels.Menu(sm)).ToList();
this.MenuItems = menu.MenuItems.Select(i => new ViewModels.MenuItem(i)).ToList();
}
public IEnumerable <Domain.PermissionRole> QueryPermissionRolesOfUser(Guid user, Website website)
{
var result = new List <Domain.PermissionRole>();
var sql = "dbo.P_QueryPermissionRolesOfUser";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("@iUserId", user);
dbOperator.AddParameter("@iWebSite", (byte)website);
using (var reader = dbOperator.ExecuteReader(sql, System.Data.CommandType.StoredProcedure)) {
Domain.PermissionRole role = null;
Domain.Menu menu = null;
Domain.SubMenu submenu = null;
while (reader.Read())
{
var currentRoleId = DataHelper.GetGuid(reader["RoleId"]);
if (role == null || role.Id != currentRoleId)
{
role = new Domain.PermissionRole(currentRoleId)
{
Name = DataHelper.GetString(reader["RoleName"]),
Remark = DataHelper.GetString(reader["RoleRemark"]),
Valid = true
};
menu = null;
result.Add(role);
}
var currentMenuId = DataHelper.GetGuid(reader["MenuId"]);
if (menu == null || menu.Id != currentMenuId)
{
menu = new Domain.Menu(currentMenuId, DataHelper.GetString(reader["MenuName"]))
{
Remark = DataHelper.GetString(reader["MenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["MenuSortLevel"]),
Valid = true,
Display = DataHelper.GetBoolean(reader["MenuDisplay"])
};
submenu = null;
role.AppendMenu(menu);
}
var currentSubMenuId = DataHelper.GetGuid(reader["SubMenuId"]);
if (submenu == null || submenu.Id != currentSubMenuId)
{
submenu = new Domain.SubMenu(currentSubMenuId, DataHelper.GetString(reader["SubMenuName"]), DataHelper.GetString(reader["SubMenuAddress"]))
{
Remark = DataHelper.GetString(reader["SubMenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["SubMenuSortLevel"]),
Valid = true,
Display = DataHelper.GetBoolean(reader["SubMenuDisplay"])
};
menu.AppendChild(submenu);
}
if (reader["ResourceId"] != DBNull.Value)
{
submenu.AppendResource(new Domain.Resource(DataHelper.GetGuid(reader["ResourceId"]))
{
Name = DataHelper.GetString(reader["ResourceName"]),
Address = DataHelper.GetString(reader["ResourceAddress"]),
Remark = DataHelper.GetString(reader["ResourceRemark"]),
Valid = true
});
}
}
}
}
return(result);
}
public void MenuSaveOrUpdate(Domain.Menu menu)
{
MenuRepository.SaveOrUpdate(menu);
}
public CreateCategoryFixture(Domain.Menu menu, CreateCategoryRequest newCategory)
{
this.existingMenu = menu;
this.newCategory = newCategory;
}
public MenuProduct(Domain.Menu menu, Domain.Product product, decimal price)
{
this.menu = menu;
this.product = product;
this.Price = price;
}
private List <Control> GetControls()
{
Domain.Menu menu = menuService.GetCurrentMenu();
if (menu == null)
{
var lt404 = new LiteralControl()
{
Text = "404 Seite nicht gefunden"
};
return(new List <Control> {
lt404
});
}
int menuId = menu.Id;
List <Domain.Module> modules;
using (var work = new Data.UnitOfWork())
{
modules = work.ModuleRepository.GetAllByMenuId(menuId);
modules = modules.OrderBy((x) =>
{
if (x.Position.HasValue)
{
return(x.Position.Value);
}
else
{
return(Int32.MaxValue);
}
}).ToList();
}
var controls = new List <Control>();
foreach (var module in modules)
{
if (!Code.CmsConfig.CmsModules.ContainsKey(module.ModuleId))
{
controls.Add(new LiteralControl()
{
Text = $"Module with id={module.ModuleId} was not found!"
});
continue;
}
var cmsModule = Code.CmsConfig.CmsModules[module.ModuleId];
var p = HttpContext.Current.Handler as Page;
var cmsControl = p.LoadControl(cmsModule.ControlPath);
var parameter = ParameterBuilder.Deserialize(module.Settings, cmsModule.ParameterType);
((IBaseModule)cmsControl).SetParameter(parameter);
var wrapper = p.LoadControl("~/Modules/BaseModuleWrapper.ascx");
((BaseModuleWrapper)wrapper).CmsModule = cmsModule;
wrapper.FindControl("ph").Controls.Add(cmsControl);
controls.Add(wrapper);
}
return(controls);
}
public MenuProduct(Domain.Menu menu, Domain.Product product, decimal price)
{
this.menu = menu;
this.product = product;
this.Price = price;
}
public virtual void Updatemenu(MenuDto menu)
{
Domain.Menu model = AutoMapper.Mapper.Map <Domain.Menu>(menu);
_MenuRepository.Update(model);
}
public virtual void Addmenu(MenuDto menu)
{
Domain.Menu model = AutoMapper.Mapper.Map <Domain.Menu>(menu);
_MenuRepository.Insert(model);
}
