// // GET: /Actions/ public ActionResult Index() { /* * var gen_controller_action = db.GEN_CONTROLLER_ACTION; * return View(gen_controller_action.ToList()); */ ControllerList list = new ControllerList(); //ViewBag.ControllerList = list.GetControllerActions(); //List<ClsController> clslist = list.GetControllerActions(); List <GEN_CONTROLLER_ACTION> db_action_list = db.GEN_CONTROLLER_ACTION.OrderBy(a => a.ACTION_NAME).OrderBy(a => a.CONTROLLER_NAME).ToList(); List <ControllerActionViewModel> action_list = list.GetControllerActions().OrderBy(a => a.actionName).OrderBy(a => a.controllerName).ToList(); foreach (var code_item in action_list) { foreach (var db_item in db_action_list) { if ((code_item.controllerName.Trim() == db_item.CONTROLLER_NAME.Trim()) && (code_item.actionName.Trim() == db_item.ACTION_NAME.Trim())) { code_item.IsActive = db_item.IS_ACTIVE.Value == 1 ? true : false; code_item.IsAutoInclude = db_item.IS_AUTO_INCLUDE.Value == 1 ? true : false; if (db_item.IS_PUBLIC.HasValue) { code_item.IsPublic = db_item.IS_PUBLIC.Value == 1 ? true : false; } else { code_item.IsPublic = false; } if (db_item.IS_MENU.HasValue) { code_item.IsMenu = db_item.IS_MENU.Value == 1 ? true : false; } else { code_item.IsMenu = false; } code_item.menuName = db_item.MENU_NAME; } } } return(View(action_list)); }
public ActionResult Index(ControllerActionViewModel[] controllers) { foreach (var cont in controllers) { GEN_CONTROLLER_ACTION record = db.GEN_CONTROLLER_ACTION. Where(a => a.ACTION_NAME == cont.actionName && a.CONTROLLER_NAME == cont.controllerName). FirstOrDefault(); if (record == null) { GEN_CONTROLLER_ACTION conac = new GEN_CONTROLLER_ACTION(); conac.ACTION_NAME = cont.actionName; conac.CONTROLLER_NAME = cont.controllerName; conac.IS_AUTO_INCLUDE = cont.IsAutoInclude == true ? 1 : 0; conac.IS_ACTIVE = cont.IsActive == true ? 1 : 0; conac.IS_PUBLIC = cont.IsPublic == true ? 1 : 0; conac.IS_MENU = cont.IsMenu == true ? 1 : 0; conac.MENU_NAME = cont.menuName; db.GEN_CONTROLLER_ACTION_INSERT(conac.CONTROLLER_NAME, conac.ACTION_NAME, conac.IS_ACTIVE, conac.IS_PUBLIC, conac.IS_AUTO_INCLUDE, conac.PARENT_ACTION_NO, conac.IS_MENU, conac.MENU_NAME, conac.PARENT_MENU_NO, conac.IS_SUB_MENU, conac.DETAILS, conac.SL_NUM); } else { record.IS_AUTO_INCLUDE = cont.IsAutoInclude == true ? 1 : 0; record.IS_ACTIVE = cont.IsActive == true ? 1 : 0; record.IS_PUBLIC = cont.IsPublic == true ? 1 : 0; record.IS_MENU = cont.IsMenu == true ? 1 : 0; record.MENU_NAME = cont.menuName; db.GEN_CONTROLLER_ACTION_UPDATE(record.ACTION_NO, record.CONTROLLER_NAME, record.ACTION_NAME, record.IS_ACTIVE, record.IS_PUBLIC, record.IS_AUTO_INCLUDE, record.PARENT_ACTION_NO, record.IS_MENU, record.MENU_NAME, record.PARENT_MENU_NO, record.IS_SUB_MENU, record.DETAILS, record.SL_NUM); } } //db.SaveChanges(); ControllerList list = new ControllerList(); List <ControllerActionViewModel> clist = list.GetControllerActions().OrderBy(a => a.actionName).OrderBy(a => a.controllerName).ToList(); return(View(clist)); }