public ActionResult SearchUser(int idWorkzone, string nome = "") { ModelState.Clear(); tblWorkzone workzone; workzone = _workzone.GetWorkzoneById(idWorkzone); /* SELECIONA FUNCIONÁRIOS ADICIONADOS NESSA WZ*/ IEnumerable <tblFuncionarios> employeeAdded; employeeAdded = _workzone.setUpEmployees(idWorkzone); IEnumerable <tblFuncionarios> funcFiltrados; funcFiltrados = _employee.GetEmployeeByName(nome, idWorkzone); ViewBag.Name = nome; ViewData["Funcionarios"] = funcFiltrados; ViewData["FuncionariosAdicionados"] = employeeAdded; FuncListModel Func = new FuncListModel(); Func.idWorkzone = idWorkzone; Func.funcionariosAdded = employeeAdded; Func.funcionarios = funcFiltrados; UpdateModel(Func); //return RedirectToAction("Details", new { id = workzone.IdWorkzone, nome = nome }); return(PartialView("_Lista", Func)); }
//GET: workzone/Details/5 //[AccessHelper(Menu = MenuHelper.VisualizacaoCadastro, Screen = ScreensHelper.PostodeTrabalho, Feature = FeaturesHelper.Editar)] public ActionResult Details(int id, string nome = "") { FuncListModel Func = new FuncListModel(); Func.idWorkzone = id; var x = ViewBag.Name; ModelState.Clear(); ViewData.Clear(); UpdateModel(ViewData); /* MONTANDO SELECT LIST BU, CC E LINHA*/ setBUCCLINHA(id); /*FINALIZANDO SELECT LISTA BU, CC E LINHA*/ SetImage(); tblWorkzone workzone; workzone = _workzone.GetWorkzoneById(id); /*SELECIONA FUNCIONÁRIOS EXISTENTES*/ IEnumerable <tblFuncionarios> employee; if (nome.Length > 0) { employee = _employee.GetEmployeeByName(nome, id); } else { employee = _employee.GetEmployees(); } Func.funcionarios = employee; ViewData["Funcionarios"] = employee; /* SELECIONA FUNCIONÁRIOS ADICIONADOS NESSA WZ*/ IEnumerable <tblFuncionarios> employeeAdded; employeeAdded = _workzone.setUpEmployees(id); Func.funcionariosAdded = employeeAdded; ViewData["FuncionariosAdicionados"] = employeeAdded; if (workzone == null) { return(View("Index")); } return(View("Edit", workzone)); }
public FuncListModel GetFuncMenu(string email, string passw) { FuncListModel resp = new FuncListModel(); try { resp.func = new List <FuncModel>(); string query = string.Format( @"select C.seq,D.code, D.name_thai AS func_name, D.route_path, D.icon_name, D.func_type, D.func_ref_sub from [dbo].[SYS_ACCOUNT] A INNER JOIN [dbo].[SYS_PERMISSION_GROUP] B ON A.account_id = B.account_id INNER JOIN [dbo].[SYS_PERMISSION_FUNCTION] C ON B.group_code = C.group_code INNER JOIN [dbo].[SYS_FUNCTION] D ON C.func_code = D.code WHERE A.email='{0}'AND A.password='******' ORDER BY b.group_code,c.seq ASC", email, passw); using (MSSql mssql = new MSSql(DBConnectionType.RBAC, _EnvironmentModel)) { var dt = mssql.GetDataTableFromQueryStr(query); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string func_type = dr["func_type"].ToString(); if (func_type == "Main" || func_type == "MainSub") { FuncModel func_model = new FuncModel() { seq = Convert.ToInt32(dr["seq"]), key = dr["code"].ToString(), icon = dr["icon_name"].ToString(), path = func_type == "MainSub" ? null : dr["route_path"].ToString(), sub_item = new List <SubFuncModel>(), }; resp.func.Add(func_model); } if (func_type == "Divider") { FuncModel func_model = new FuncModel() { seq = Convert.ToInt32(dr["seq"]), divider = true, }; resp.func.Add(func_model); } } foreach (DataRow dr in dt.Rows) { string func_type = dr["func_type"].ToString(); if (func_type == "SubMenu") { SubFuncModel sub_item = new SubFuncModel() { seq = Convert.ToInt32(dr["seq"]), key = dr["code"].ToString(), icon = dr["icon_name"].ToString(), path = dr["route_path"].ToString(), }; int indexFunc = resp.func.FindIndex(e => e.key != null && e.key == dr["func_ref_sub"].ToString()); resp.func[indexFunc].sub_item.Add(sub_item); } } return(resp); } } } catch (Exception ex) { _ILogs.LogError("Function Application: ", ex.Message.ToString(), ex.StackTrace); } return(null); }