/// <summary>
/// Handles the OnClick event of the btnAddMenuTab control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
protected void btnAddMenuTab_OnClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdnMenuID.Value))
{
var menuUpdate = dataManager.Menu.SelectByID(Guid.Parse(hdnMenuID.Value));
menuUpdate.Title = txtMenuTabTitle.Text;
menuUpdate.TabName = txtMenuName.Text;
dataManager.Menu.Update(menuUpdate);
}
else
{
var order = 0;
var menus = dataManager.Menu.SelectByAccessProfileID(AccessProfileID);
if (menus != null && menus.Count > 0)
{
order = menus.OrderByDescending(a => a.Order).First().Order + 1;
}
var menuId = Guid.NewGuid();
var menuAdd = new tbl_Menu();
menuAdd.ID = menuId;
menuAdd.AccessProfileID = AccessProfileID;
menuAdd.Title = txtMenuTabTitle.Text;
menuAdd.TabName = txtMenuName.Text;
menuAdd.Order = order;
dataManager.Menu.Add(menuAdd);
}
BindTreeMenu();
}
/// <summary>
/// Handles the OnNodeDrop event of the rtvTreeModules control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Telerik.Web.UI.RadTreeNodeDragDropEventArgs"/> instance containing the event data.</param>
protected void rtvTreeModules_OnNodeDrop(object sender, RadTreeNodeDragDropEventArgs e)
{
// Only tabs
if (e.DestDragNode.Level == 1)
{
e.DestDragNode.Nodes.Add(e.DraggedNodes[0]);
e.DraggedNodes[0].Selected = true;
var order = 0;
var menus = dataManager.Menu.SelectByAccessProfileID(AccessProfileID).Where(a => a.ParentID == Guid.Parse(e.DestDragNode.Attributes["NodeID"])).ToList();
if (menus.Count > 0)
{
order = menus.OrderByDescending(a => a.Order).First().Order + 1;
}
var menuId = Guid.NewGuid();
var menuAdd = new tbl_Menu();
menuAdd.ID = menuId;
menuAdd.ParentID = Guid.Parse(e.DestDragNode.Attributes["NodeID"]);
menuAdd.AccessProfileID = AccessProfileID;
menuAdd.ModuleID = Guid.Parse(e.DraggedNodes[0].Value);
menuAdd.Order = order;
dataManager.Menu.Add(menuAdd);
BindTreeModules();
BindTreeMenu();
}
}
/// <summary>
/// Adds the specified menu.
/// </summary>
/// <param name="menu">The menu.</param>
/// <returns></returns>
public tbl_Menu Add(tbl_Menu menu)
{
if (menu.ID == Guid.Empty)
{
menu.ID = Guid.NewGuid();
}
_dataContext.tbl_Menu.AddObject(menu);
_dataContext.SaveChanges();
return(menu);
}
public bool Update(tbl_Menu menu)
{
try
{
var entity = db.tbl_Menu.Find(menu.ID);
entity.Text = menu.Text;
entity.Status = menu.Status;
entity.Text = menu.Text;
entity.tbl_TypeMenu.ID = menu.tbl_TypeMenu.ID;
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public JsonResult AddNewFoodItem(MenuItems menu)
{
int currentUserTypeLoggedin = Convert.ToInt32(Request.Cookies["UserType"].Value);
tbl_Menu item = new tbl_Menu();
item.Food_Item_Name = menu.Food_Item_Name;
item.Details = menu.Details;
item.Price = menu.Price;
item.FoodType = menu.FoodType;
item.AddedBy = Request.Cookies["AddedBy"].Value;
item.InventoryID = menu.InventoryID;
if (currentUserTypeLoggedin == 2)
{
item.NewItemApprvFrmSuperAdm = false;
}
else
{
item.NewItemApprvFrmSuperAdm = true;
}
item.DelItemApprvFromSuperAdm = false;
context.tbl_Menu.Add(item);
context.SaveChanges();
return(Json(currentUserTypeLoggedin));
}
public static void Seed(this ModelBuilder modelBuilder)
{
//if (!System.Diagnostics.Debugger.IsAttached)
// System.Diagnostics.Debugger.Launch();
//context.Privilliges.RemoveRange(context.Privilliges.ToList());
//context.Menus.RemoveRange(context.Menus.ToList());
//context.SaveChanges();
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] ON");
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] ON");
//context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Privillige]");
//context.Database.ExecuteSqlCommand("TRUNCATE TABLE [tbl_Menu]");
//DBCC CHECKIDENT('tbl_Privillige',RESEED, 0)
#region Seed
#region UserTypes
tbl_UserType ut1 = new tbl_UserType()
{
NameAr = "مريض",
NameEn = "Patient"
};
tbl_UserType ut2 = new tbl_UserType()
{
NameAr = "طبيب",
NameEn = "Doctor"
};
tbl_UserType ut3 = new tbl_UserType()
{
NameAr = "ادارة النظام",
NameEn = "Administrator"
};
fillbase(ut1);
fillbase(ut2);
fillbase(ut3);
modelBuilder.Entity <tbl_UserType>().HasData(ut1, ut2, ut3);
#endregion
#region Privilliges
tbl_Privillige Page_administration = new tbl_Privillige()
{
Key = common.Enums.Enum_Privilliges.Page_administration.ToString(),
NameAr = common.Enums.Enum_Privilliges.Page_administration.ToString(),
NameEn = common.Enums.Enum_Privilliges.Page_administration.ToString()
};
tbl_Privillige Page_Groups = new tbl_Privillige()
{
Key = common.Enums.Enum_Privilliges.Page_Groups.ToString(),
NameAr = common.Enums.Enum_Privilliges.Page_Groups.ToString(),
NameEn = common.Enums.Enum_Privilliges.Page_Groups.ToString()
};
tbl_Privillige Page_Groups_Add = new tbl_Privillige()
{
Key = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(),
NameAr = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString(),
NameEn = common.Enums.Enum_Privilliges.Page_Groups_Add.ToString()
};
tbl_Privillige Page_Users = new tbl_Privillige()
{
Key = common.Enums.Enum_Privilliges.Page_Users.ToString(),
NameAr = common.Enums.Enum_Privilliges.Page_Users.ToString(),
NameEn = common.Enums.Enum_Privilliges.Page_Users.ToString()
};
tbl_Privillige Page_Users_Add = new tbl_Privillige()
{
Key = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(),
NameAr = common.Enums.Enum_Privilliges.Page_Users_Add.ToString(),
NameEn = common.Enums.Enum_Privilliges.Page_Users_Add.ToString()
};
fillbase(Page_Groups);
fillbase(Page_Groups_Add);
fillbase(Page_Users);
fillbase(Page_Users_Add);
fillbase(Page_administration);
modelBuilder.Entity <tbl_Privillige>().HasData(Page_Groups, Page_Groups_Add, Page_Users, Page_Users_Add, Page_administration);
#endregion
#region Privilliges_Groups
tbl_Group AdminGroup = new tbl_Group()
{
NameAr = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString(),
NameEn = common.Enums.Enum_PrivilligesGroup.AdminGroup.ToString()
};
tbl_Group DoctorGroup = new tbl_Group()
{
NameAr = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString(),
NameEn = common.Enums.Enum_PrivilligesGroup.DoctorGroup.ToString()
};
tbl_Group PatientGroup = new tbl_Group()
{
NameAr = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString(),
NameEn = common.Enums.Enum_PrivilligesGroup.PatientGroup.ToString()
};
fillbase(AdminGroup);
fillbase(DoctorGroup);
fillbase(PatientGroup);
modelBuilder.Entity <tbl_Group>().HasData(AdminGroup, DoctorGroup, PatientGroup);
#endregion
#region Menu
List <tbl_Menu> Menus = new List <tbl_Menu>();
#region Security
//tbl_Menu Menu_Security_Privilliges = new tbl_Menu()
//{
// NameAr = "Privilliges",
// icon = "ion-card",
// NameEn = "Privilliges",
// link = "/pages/Security/privilliges/Index",
//};
tbl_Menu Menu_Security = new tbl_Menu()
{
ParentID = null,
NameAr = " الادارة",
NameEn = "administration",
icon = "ion-settings",
link = "",
PrivilligeID = Page_administration.ID,
//Children = new List<tbl_Menu>()
//{
// Menu_Security_Users,
// Menu_Security_Groups,
//}
};
fillbase(Menu_Security);
tbl_Menu Menu_Security_Groups = new tbl_Menu()
{
ID = Guid.NewGuid(),
ParentID = Menu_Security.ID,
NameAr = "المجموعات",
icon = "fa fa-object-group",
NameEn = "groups",
link = "/pages/administration/groups",
};
fillbase(Menu_Security_Groups);
tbl_Menu Menu_Security_Users = new tbl_Menu()
{
ID = Guid.NewGuid(),
ParentID = Menu_Security.ID,
NameAr = "المستخدمون",
NameEn = "Users",
icon = "ion-person-stalker",
link = "/pages/administration/users",
};
fillbase(Menu_Security_Users);
Menus.Add(Menu_Security);
Menus.Add(Menu_Security_Groups);
Menus.Add(Menu_Security_Users);
foreach (var m in Menus)
{
fillbase(m);
foreach (var m_child in m.Children)
{
fillbase(m_child);
}
}
modelBuilder.Entity <tbl_Menu>().HasData(Menu_Security, Menu_Security_Users, Menu_Security_Groups);
#endregion
#endregion
#region Settings
tbl_Setting sett1 = new tbl_Setting()
{
Conf_Key = "Active_Directory_Domain",
Conf_Value = "GETGROUP.com"
};
fillbase(sett1);
modelBuilder.Entity <tbl_Setting>().HasData(sett1);
#endregion
#region Users
tbl_User ahmedadmin = new tbl_User()
{
Email = "*****@*****.**",
NameAr = "احمد حسن",
NameEn = "ahmed hassan",
Password = "******",
isActivated = true,
Mobile = "01111376958",
Name = "*****@*****.**",
ActivationStartDate = DateTime.Now.AddDays(-1),
ActivationEndDate = null,
UserTypeID = ut3.ID
};
tbl_User user1 = new tbl_User()
{
Email = "*****@*****.**",
NameAr = "admin1",
NameEn = "admin1",
Password = "******",
isActivated = true,
ActivationStartDate = DateTime.Now.AddDays(-1),
ActivationEndDate = DateTime.MaxValue
};
tbl_User user2 = new tbl_User()
{
Email = "*****@*****.**",
NameAr = "admin2",
NameEn = "admin2",
Password = "******",
isActivated = true,
ActivationStartDate = DateTime.Now.AddDays(-1),
ActivationEndDate = DateTime.MaxValue,
};
fillbase(ahmedadmin);
fillbase(user1);
fillbase(user2);
modelBuilder.Entity <tbl_User>().HasData(ahmedadmin);
List <tbl_Privilligetbl_User> usersInPriv = new List <tbl_Privilligetbl_User>()
{
new tbl_Privilligetbl_User()
{
//User = ahmedadmin,
tbl_User_ID = ahmedadmin.ID,
tbl_Privillige_ID = Page_Groups.ID,
//Privillige = Page_Groups
},
new tbl_Privilligetbl_User()
{
//User = ahmedadmin,
tbl_User_ID = ahmedadmin.ID,
tbl_Privillige_ID = Page_Groups_Add.ID,
//Privillige = Page_Groups_Add
},
new tbl_Privilligetbl_User()
{
//User = ahmedadmin,
tbl_User_ID = ahmedadmin.ID,
tbl_Privillige_ID = Page_Users.ID,
//Privillige = Page_Users
},
new tbl_Privilligetbl_User()
{
//User = ahmedadmin,
tbl_User_ID = ahmedadmin.ID,
tbl_Privillige_ID = Page_Users_Add.ID,
//Privillige = Page_Users_Add
},
new tbl_Privilligetbl_User()
{
//User = ahmedadmin,
tbl_User_ID = ahmedadmin.ID,
tbl_Privillige_ID = Page_administration.ID,
//Privillige = Page_Users_Add
}
};
//var ahmedadminPriv0 = new tbl_Privilligetbl_User()
//{
// User = ahmedadmin,
// Privillige = Page_administration
//};
//var ahmedadminPriv1 = new tbl_Privilligetbl_User()
//{
// User = ahmedadmin,
// Privillige = Page_Groups
//};
//var ahmedadminPriv2 = new tbl_Privilligetbl_User()
//{
// User = ahmedadmin,
// Privillige = Page_Users
//};
//var ahmedadminPriv3 = new tbl_Privilligetbl_User()
//{
// User = ahmedadmin,
// Privillige = Page_Groups_Add
//};
//var ahmedadminPriv4 = new tbl_Privilligetbl_User()
//{
// User = ahmedadmin,
// Privillige = Page_Users_Add
//};
modelBuilder.Entity <tbl_Privilligetbl_User>().HasData(usersInPriv[0], usersInPriv[1], usersInPriv[2], usersInPriv[3], usersInPriv[4]);
#endregion
#endregion
// context.Database.ExecuteSqlCommand(@"CREATE SEQUENCE [dbo].[ReferenceNmberSequence]
// AS[bigint]
// START WITH 40425942
// INCREMENT BY 1
// MINVALUE - 9223372036854775808
// MAXVALUE 99999999
// CACHE
//GO");
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Privillige] OFF");
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [tbl_Menu] OFF");
}
/// <summary>
/// Updates the specified menu.
/// </summary>
/// <param name="menu">The menu.</param>
public void Update(tbl_Menu menu)
{
_dataContext.SaveChanges();
}
/// <summary>
/// Menus the actions.
/// </summary>
/// <param name="selectedNode">The selected node.</param>
/// <param name="commandName">Name of the command.</param>
/// <param name="commandArgument">The command argument.</param>
protected void MenuActions(RadTreeNode selectedNode, string commandName, string commandArgument)
{
switch (commandName)
{
case "AddTab":
hdnMenuID.Value = "";
txtMenuTabTitle.Text = "";
txtMenuName.Text = "";
rttAddTab.Show();
break;
case "Rename":
if (rtvTreeMenu.SelectedNode.Level == 1)
{
var menu = dataManager.Menu.SelectByID(Guid.Parse(rtvTreeMenu.SelectedNode.Attributes["NodeID"]));
if (menu != null)
{
hdnMenuID.Value = menu.ID.ToString();
txtMenuTabTitle.Text = menu.Title;
txtMenuName.Text = menu.TabName;
rttAddTab.Show();
}
}
if (IsSiteProfiles && rtvTreeMenu.SelectedNode.Level == 2)
{
var menu = dataManager.Menu.SelectByID(Guid.Parse(rtvTreeMenu.SelectedNode.Attributes["NodeID"]));
if (menu != null)
{
txtMenuItemTitle.Text = string.IsNullOrEmpty(menu.Title) ? menu.tbl_Module.Title : menu.Title;
var accessProfileModule = menu.tbl_AccessProfile.tbl_AccessProfileModule.SingleOrDefault(o => o.ModuleID == menu.ModuleID);
ddlModuleEditionAction.Items.Clear();
if (accessProfileModule != null && accessProfileModule.ModuleEditionID.HasValue)
{
var moduleEditionActions = dataManager.ModuleEditionAction.SelectByModuleEditionId(accessProfileModule.ModuleEditionID.Value);
ddlModuleEditionAction.DataSource = moduleEditionActions;
ddlModuleEditionAction.DataTextField = "Title";
ddlModuleEditionAction.DataValueField = "ID";
ddlModuleEditionAction.DataBind();
ddlModuleEditionAction.Items.Insert(0, new ListItem("Выберите значение", ""));
}
if (menu.ModuleEditionActionID.HasValue)
{
ddlModuleEditionAction.SelectedIndex = ddlModuleEditionAction.FindItemIndexByValue(menu.ModuleEditionActionID.Value.ToString());
}
lbtnEditMenu.CommandArgument = menu.ID.ToString();
rttEditMenu.Show();
}
}
break;
case "Delete":
if (selectedNode.Level == 1 || selectedNode.Level == 2)
{
dataManager.Menu.DeleteByMenuID(Guid.Parse(selectedNode.Attributes["NodeID"]));
}
BindTreeMenu();
break;
case "ResetMenu":
dataManager.Menu.DeleteAllByAccessProfileID(AccessProfileID);
BindTreeMenu();
break;
case "CopyMenu":
using (var scope = new TransactionScope())
{
dataManager.Menu.DeleteAllByAccessProfileID(AccessProfileID);
var copyMenu = dataManager.Menu.SelectByAccessProfileID(Guid.Parse(commandArgument));
var copyMenuTabs = copyMenu.Where(a => a.ModuleID.Equals(null));
if (copyMenu != null)
{
foreach (var copyMenuTab in copyMenuTabs)
{
var menuTab = new tbl_Menu
{
AccessProfileID = AccessProfileID,
Title = copyMenuTab.Title,
TabName = copyMenuTab.TabName,
Order = copyMenuTab.Order
};
menuTab = dataManager.Menu.Add(menuTab);
var copyMenuModules = copyMenu.Where(a => a.ParentID == copyMenuTab.ID);
foreach (var copyMenuModule in copyMenuModules)
{
var menuModule = new tbl_Menu
{
ParentID = menuTab.ID,
AccessProfileID = AccessProfileID,
ModuleID = copyMenuModule.ModuleID,
ModuleEditionActionID = copyMenuModule.ModuleEditionActionID,
Title = copyMenuModule.Title,
Order = copyMenuModule.Order
};
dataManager.Menu.Add(menuModule);
}
}
}
scope.Complete();
}
BindTreeMenu();
break;
}
}
public long Insert(tbl_Menu menu)
{
db.tbl_Menu.Add(menu);
db.SaveChanges();
return(menu.ID);
}
public ActionResult Manage(MenuInfo info)
{
var service = Container.GetService <IMenuService>();
var result = new Manage.Common.AjaxResult()
{
};
try
{
if (info.Key == 0)
{
if (!(info.Name.Length > 0))
{
result.State = false;
result.Message = "菜单名不能为空";
}
else
{
if (!CanCreated)
{
ViewBag.Message = CannotAddText;
return(View("Error"));
}
var menu = new tbl_Menu();
menu.C_Name = info.Name;
menu.C_Description = info.Description;
menu.C_ParentMenu = info.ParentKey;
menu.C_Controller = info.Controller;
menu.C_Action = info.Action;
menu.C_CreatedDate = DateTime.Now;
result.State = service.Add(menu);
if (result.State)
{
result.Message = "添加成功";
}
else
{
result.Message = "添加失败";
}
}
}
else
{
if (!CanUpdated)
{
ViewBag.Message = CannotUpateText;
return(View("Error"));
}
var menu = service.GetModels(m => m.keyid == info.Key).FirstOrDefault();
menu.C_Name = info.Name;
menu.C_Description = info.Description;
menu.C_ParentMenu = info.ParentKey;
menu.C_Controller = info.Controller;
menu.C_Action = info.Action;
menu.C_UpdatedDate = DateTime.Now;
if (menu != null)
{
result.State = service.Update(menu);
if (result.State)
{
result.Message = "修改成功";
}
else
{
result.Message = "修改失败";
}
}
else
{
result.Message = "错误，不存在此菜单，修改失败";
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(Json(result));
}
