public IEnumerable <SYS_FunctionPermissionsDto> GetFunctionPermissionsByGroupCode(string groupCode) { List <SYS_FunctionPermissionsDto> listOfFunctionPermissions = new List <SYS_FunctionPermissionsDto>(); List <sy_operas> listOfRight = this.GetListOfRights(); //1. Get all functions for group using (BaseDao context = new BaseDao()) { IQueryable <sy_functions> functions = context.sy_functions.AsQueryable(); foreach (sy_functions item in functions) { SYS_FunctionPermissionsDto newFunction = new SYS_FunctionPermissionsDto() { FunctionPermissionID = Guid.NewGuid(), GroupCode = groupCode, FunctionID = item.ID, FunctionCode = item.FunctionID, FunctionNameVN = item.Name1, FunctionNameEL = item.Name2, FunctionNameJP = item.Name3, }; listOfFunctionPermissions.Add(newFunction); } } //-------------------------------------------------------------------------------- //2. Assign Function's permission IQueryable <ms_permissionsassign> listofFunctionAssign = this.GetExsitingFunctionPermission(groupCode); foreach (ms_permissionsassign ms_permissionsassign in listofFunctionAssign) { sy_functionmapping sy_functionmapping = this.GetFunctionMapping(ms_permissionsassign.MappingID); if (sy_functionmapping != null) { SYS_FunctionPermissionsDto sys_FunctionPermission = listOfFunctionPermissions.Where(c => c.FunctionCode == sy_functionmapping.FunctionID).FirstOrDefault(); if (sys_FunctionPermission != null) { sys_FunctionPermission.MappingID = ms_permissionsassign.MappingID; sy_operas operate = listOfRight.Where(c => c.OperID == sy_functionmapping.OperID).FirstOrDefault(); if (operate != null) { sys_FunctionPermission.Add = (operate.Name2 == "Add"); sys_FunctionPermission.All = (operate.Name2 == "All"); sys_FunctionPermission.Close = (operate.Name2 == "Close"); sys_FunctionPermission.Delete = (operate.Name2 == "Delete"); sys_FunctionPermission.Edit = (operate.Name2 == "Edit"); sys_FunctionPermission.Export = (operate.Name2 == "Export"); sys_FunctionPermission.Import = (operate.Name2 == "Import"); sys_FunctionPermission.Lock = (operate.Name2 == "Lock"); sys_FunctionPermission.Open = (operate.Name2 == "Open"); sys_FunctionPermission.Print = (operate.Name2 == "Print"); sys_FunctionPermission.View = (operate.Name2 == "View"); } } } } return(listOfFunctionPermissions); }
private int GetFunctionMappingID(string functionCode, string operasID) { BaseDao context = new BaseDao(); sy_functionmapping functionMapping = context.sy_functionmapping.Where(c => c.OperID == operasID && c.FunctionID == functionCode).FirstOrDefault(); if (functionMapping != null) { return(functionMapping.ID); } return(0); }
private int DeleteSys_functionMapping(sy_functionmapping deleteSyS_functionmapping) { int mappID = 0; using (BaseDao context = new BaseDao()) { sy_functionmapping deletesy_functionmapping = context.sy_functionmapping.FirstOrDefault(c => c.OperID == deleteSyS_functionmapping.OperID && c.FunctionID == deleteSyS_functionmapping.FunctionID); mappID = deleteSyS_functionmapping.ID; if (deletesy_functionmapping != null) { context.sy_functionmapping.DeleteObject(deletesy_functionmapping); mappID = context.Saves(); } } return(mappID); }
private int InsertSys_functionMapping(sy_functionmapping insertDto) { int mappID = 0; using (BaseDao context = new BaseDao()) { sy_functionmapping newFunctionMapping = new sy_functionmapping() { OperID = insertDto.OperID, FunctionID = insertDto.FunctionID }; context.sy_functionmapping.AddObject(newFunctionMapping); mappID = context.Saves(); } return(mappID); }