/// <summary>
/// Get All Menu List
/// </summary>
/// <returns></returns>
public List <Menu_Resource_Model> GetMenuList(Menu_Resource_Model qModel, out int count)
{
List <Menu_Resource_Model> list = new List <Menu_Resource_Model>();
using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
{
var query = db.Menu_Resource.AsQueryable();
if (!String.IsNullOrEmpty(qModel.name))
{
query = query.Where(s => s.MenuName.Contains(qModel.name));
}
count = query.Count();
query = query.OrderBy(s => s.SortNo).Skip((qModel.page - 1) * qModel.rows).Take(qModel.rows);
foreach (var m in query)
{
list.Add(new Menu_Resource_Model
{
//icon = m.Icon,
MenuID = m.MenuID,
ParentMenuID = m.ParentMenuID,
MenuUrl = m.MenuUrl,
MR_ID = m.MR_ID,
name = m.MenuName,
MenuName = m.MenuName,
SortNo = m.SortNo,
Visible = m.Visible
});
}
return(list);
}
}
/// <summary>
/// Get Menu List from DB
/// </summary>
/// <param name="qModel"></param>
/// <returns></returns>
public ActionResult GetMenuList(Menu_Resource_Model qModel)
{
try {
int count = 0;
MenuServices mSvg = new MenuServices();
List <Menu_Resource_Model> list = mSvg.GetMenuList(qModel, out count);
List <Object> result = new List <object>();
foreach (Menu_Resource_Model m in list)
{
if (m.ParentMenuID == "0")
{
result.Add(new {
//icon = m.icon,
iconSkin = m.iconSkin,
MenuID = m.MenuID,
ParentMenuID = m.ParentMenuID,
MenuUrl = m.MenuUrl,
MR_ID = m.MR_ID,
name = m.MenuName,
SortNo = m.SortNo,
Visible = m.Visible
});
}
else
{
result.Add(new {
//icon = m.icon,
iconSkin = m.iconSkin,
MenuID = m.MenuID,
_parentId = m.ParentMenuID,
ParentMenuID = m.ParentMenuID,
MenuUrl = m.MenuUrl,
MR_ID = m.MR_ID,
name = m.MenuName,
SortNo = m.SortNo,
Visible = m.Visible
});
}
}
return(Json(new NBCMSResultJson {
Status = StatusType.OK,
Data = new {
total = result.Count,
rows = result
}
}));
}
catch (Exception ex) {
NBCMSLoggerManager.Fatal(ex.Message);
NBCMSLoggerManager.Fatal(ex.StackTrace);
NBCMSLoggerManager.Error("");
return(Json(new NBCMSResultJson {
Status = StatusType.Exception,
Data = ex.Message
}));
}
}
public bool DeleteUser(Menu_Resource_Model model)
{
using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
{
var user = new Menu_Resource {
MR_ID = model.MR_ID
};
db.Set <Menu_Resource>().Attach(user);
db.Menu_Resource.Remove(user);
return(db.SaveChanges() > 0);
}
}
public ActionResult UpdateMenu(Menu_Resource_Model model)
{
try {
if (model == null)
{
return(Json(new NBCMSResultJson {
Status = StatusType.Error,
Data = "Request is illegal!"
}));
}
if (model.MR_ID == 0)
{
return(Json(new NBCMSResultJson {
Status = StatusType.Error,
Data = "Request paramter is null!"
}));
}
string cookis = Request[ConfigurationManager.AppSettings["userInfoCookiesKey"]];
var serializer = new JavaScriptSerializer();
string decCookies = CryptTools.Decrypt(cookis);
User_Profile_Model curUserInfo = serializer.Deserialize(decCookies, typeof(User_Profile_Model)) as User_Profile_Model;
MenuServices mns = new MenuServices();
if (mns.EditMenu(model, curUserInfo.User_Account))
{
return(Json(new NBCMSResultJson {
Status = StatusType.OK,
Data = "Successfully edit menu"
}));
}
else
{
return(Json(new NBCMSResultJson {
Status = StatusType.Error,
Data = "faile to edit menu"
}));
}
}
catch (Exception ex) {
NBCMSLoggerManager.Fatal(ex.Message);
NBCMSLoggerManager.Fatal(ex.StackTrace);
NBCMSLoggerManager.Error("");
return(Json(new NBCMSResultJson {
Status = StatusType.Exception,
Data = ex.Message
}));
}
}
public bool EditMenu(Menu_Resource_Model model, String modeifer)
{
using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
{
var entity = db.Menu_Resource.Where(a => a.MR_ID == model.MR_ID).FirstOrDefault();
entity.MenuName = model.MenuName;
entity.ParentMenuID = model.ParentMenuID;
entity.SortNo = model.SortNo;
entity.Icon = model.iconSkin;
entity.Memo = model.Memo;
entity.MenuUrl = model.MenuUrl;
entity.Visible = model.Visible;
entity.Modified_By = modeifer;
entity.Modified_On = System.DateTime.Now;
return(db.SaveChanges() > 0);
}
}
public bool AddRole(Menu_Resource_Model model, String curUserAccount)
{
using (PermaisuriCMSEntities db = new PermaisuriCMSEntities())
{
var newRole = new Menu_Resource
{
// Icon = model.icon,
Memo = model.Memo,
MenuID = model.MenuID,
ParentMenuID = model.ParentMenuID,
MenuUrl = model.MenuUrl,
MenuName = model.MenuName,
SortNo = model.SortNo,
Visible = model.Visible,
Created_By = curUserAccount,
Created_On = DateTime.Now
};
db.Menu_Resource.Add(newRole);
return(db.SaveChanges() > 0);
}
}
