public override DataTable FindByColumn(object obj)
{
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["Name"] = "";
return(dao.FindByColumn(dt));
}
public DataTable FindByColumn( )
{
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["Name"] = "";
return(dao.FindByColumn(dt));
}
public DataTable FindMenuPermissionByUserGroup(string userGroupOID)
{
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["USERGROUP_OID"] = userGroupOID;
dt.Rows.Add(dr);
return(dao.FindMenuPermissionByUserGroup(dt));
}
/// <summary>
/// active =1 /0 if active is empty then show all
/// </summary>
/// <param name="name"></param>
/// <param name="active"></param>
/// <returns></returns>
public DataTable FindByColumn(string name, string active)
{
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["Name"] = name;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindByColumn(dt));
}
public DataTable FindMenu(string name, string mainMenu, string active)
{
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["Name"] = name;
dr["MENUGROUP_OID"] = mainMenu;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindMenu(dt));
}
public bool AddNew(MenuGroupDto pMenuGroup)
{
if (pMenuGroup.items != null && pMenuGroup.items.Any())
{
foreach (MenuItemDto item in pMenuGroup.items)
{
_srvMenuItem.AddNew(item);
}
}
pMenuGroup.id = this.GetNextId();
Save(pMenuGroup);
return(true);
}
private void ModificarMenuGroupEnMenuColumn(MenuGroupDto pMenuGroup)
{
ServiceMenuColumn _srvMenuColumn = new ServiceMenuColumn();
foreach (MenuColumnDto iMenuColumn in _srvMenuColumn.GetAll())
{
if (iMenuColumn.groups != null && iMenuColumn.groups.FirstOrDefault(x => x.id == pMenuGroup.id) != null)
{
iMenuColumn.groups.FirstOrDefault(x => x.id == pMenuGroup.id).title = pMenuGroup.title;
iMenuColumn.groups.FirstOrDefault(x => x.id == pMenuGroup.id).items = pMenuGroup.items;
_srvMenuColumn.Modify(iMenuColumn);
}
}
}
public bool Modify(MenuGroupDto pMenuGroup)
{
List <MenuGroupDto> listaMenuGroup = this.GetAll();
if (pMenuGroup != null && listaMenuGroup.FirstOrDefault(x => x.id == pMenuGroup.id) != null)
{
listaMenuGroup.FirstOrDefault(x => x.id == pMenuGroup.id).title = pMenuGroup.title;
listaMenuGroup.FirstOrDefault(x => x.id == pMenuGroup.id).items = pMenuGroup.items;
File.Delete(_path);
this.Save(listaMenuGroup);
return(true);
}
return(false);
}
public bool Action(string MENU_OID, string MENUGROUP_OID, string Name, string DESC
, string SCREEN, string LINK, string IconName, string UserLogin, bool rowState, PAction action)
{
/*
* [MENU_OID]
* ,[OrderNo]
* ,[MENUGROUP_OID]
* ,[Name]
* ,[DESC]
* ,[SCREEN]
* ,[LINK]
* ,[PMENU_OID]
* ,[CREATE_BY]
* ,[CREATE_DATE]
* ,[UPDATE_BY]
* ,[UPDATE_DATE]
* ,[ROW_STATE]*/
dt = MenuGroupDto.Data();
dr = dt.NewRow();
dr["MENU_OID"] = MENU_OID;
dr["OrderNo"] = 0;
dr["MENUGROUP_OID"] = MENUGROUP_OID;
dr["Name"] = Name;
dr["Desc"] = DESC;
dr["SCREEN"] = SCREEN;
dr["LINK"] = LINK;
dr["Icon"] = IconName;
dr["PMENU_OID"] = MENUGROUP_OID;
dr["CREATE_BY"] = UserLogin;
dr["CREATE_DATE"] = "";
dr["UPDATE_BY"] = UserLogin;
dr["UPDATE_DATE"] = "";
dr["ROW_STATE"] = rowState?"1":"0";
dt.Rows.Add(dr);
switch (action)
{
case PAction.Add: isCan = Add(); break;
case PAction.Update: isCan = Update(); break;
case PAction.Delete: isCan = Delete(); break;
}
return(isCan);
}
public void Save(MenuGroupDto pMenuGroup)
{
string json = JsonConvert.SerializeObject(pMenuGroup);
if (File.Exists(_path))
{
using (var writer = new StreamWriter(_path, true))
{
writer.WriteLine(json);
writer.Close();
}
}
else
{
File.WriteAllText(_path, json);
using (var writer = new StreamWriter(_path, true))
{
writer.WriteLine(string.Empty);
writer.Close();
}
}
}
public void ModifyMenuGroup(MenuGroupDto menuGroup)
{
_srvMenuGroup = new ServiceMenuGroup();
_srvMenuGroup.Modify(menuGroup);
}
public int SaveMenuGroup(MenuGroupDto menuGroup)
{
_srvMenuGroup = new ServiceMenuGroup();
_srvMenuGroup.AddNew(menuGroup);
return(menuGroup.id);
}
