public DataTable GetTable(int userID) { #if alexj var entity = Storage.Select <Entity>(ID); var query = string.Format("SELECT * FROM Permission.UserPermission({0}, '{1}') WHERE [objID] IS NOT NULL", userID, entity.SystemName); var InstanceNoPermission = Storage.GetDataTable(query).AsEnumerable().Where(x => !Convert.ToBoolean(x["read"])).Select(o => o["objID"].ToString()).ToList <string>(); DataRow[] rows = this.table.AsEnumerable().Where(x => !InstanceNoPermission.Contains(x["objID"].ToString())).ToArray(); #else var userFilter = StorageUserObgects.Select <UserFilter>(userID, ID); var expression = userFilter.GetUserFilterExpression(); DataRow[] rows = this.table.Select(expression); #endif if (rows != null && rows.Count() > 0) { var filteredTable = rows.CopyToDataTable(); return(filteredTable); } else { var emtyTable = new DataTable(); return(emtyTable); } }
public static void LogOutUser() { var Session = System.Web.HttpContext.Current.Session; var SystemUser = Session["SystemUser"]; string query = string.Format("UPDATE [Log].[ServerSession] SET [finish] = GETDATE() WHERE [sessionID] = '{0}' AND [finish] is null ", SystemUser); GetDataTable(query); StorageUserObgects.ClearAllCache(); Session.Abandon(); Session.Clear(); HttpContext.Current.Cache.Remove(Session.SessionID); }
public static void SetFieldsTaboo(int userID, Template template) { if (userID == null) { userID = 0; } var deniedEntity = StorageUserObgects.Select <UserEntityPermission>(userID, userID).getReadDeniedEntities().AsEnumerable().Select(x => x["entity"].ToString()).ToList <string>(); foreach (var field in template.Fields) { var entityName = deniedEntity.FirstOrDefault(e => e == field.NativeEntityName); if (entityName != null) { field.IsForbidden = true; } else { field.IsForbidden = false; } } }
public static List <object> GetPermittedTemplates(string entityID, string userID, string lexem, string typeCode, List <Template> runtimeTeplates = null) { var ReportsTemplateslist = new List <object>(); if (string.IsNullOrEmpty(userID)) { userID = "0"; } var query = string.Format(@"select CONVERT(varchar(200), p.[objID]) as [templateID], p.[name] [templateName], p.[type] [typeName] from [Permission].[IUTemplatePermission]({0}) p, model.BTables t where t.[name] = p.[baseTable] and t.[object_ID] = '{1}' and p.[read] = 1 and p.[typeCode] {2} '{3}' order by p.[name]", userID, entityID, lexem, typeCode); var dt = Storage.GetDataTable(query); #if alexj var deniedEntities = StorageUserObgects.Select <UserEntityPermission>(Convert.ToInt32(userID), Convert.ToInt32(userID)).getReadDeniedEntities().AsEnumerable().Select(x => x["entity"].ToString()).ToList <string>(); for (int i = dt.Rows.Count - 1; i >= 0; i--) { var template = Storage.Select <Template>(dt.Rows[i]["templateID"].ToString()); if (template.TypeCode == Reporting.Template.EnumTypeCode.TableBased) { foreach (var field in template.Fields) { var constraint = GetConstraintByAttributeFpath(field, template.Entity); if (constraint != null && constraint.IsIdentified && field.Attribute.SType != "Table") { var fieldEntity = field.NativeEntityName; if (deniedEntities.Contains(fieldEntity)) { dt.Rows.RemoveAt(i); break; } } } } else { foreach (var field in template.Fields) { var fieldEntity = field.NativeEntityName; if (deniedEntities.Contains(fieldEntity)) { dt.Rows.RemoveAt(i); break; } } } } #endif if (runtimeTeplates != null) { foreach (var template in runtimeTeplates) { var newRow = dt.NewRow(); newRow[0] = template.ID; newRow[1] = template.Name; dt.Rows.Add(newRow); } } if (dt.Rows.Count > 0) { var sortedRows = dt.Select("", "templateID DESC"); dt = sortedRows.CopyToDataTable(); } foreach (DataRow row in dt.Rows) { var templateID = row["templateID"]; var typeName = row["typeName"]; var templateName = row["templateName"]; var entityName = string.Empty; var text = string.Empty; if (runtimeTeplates != null) { text = string.Format("{0}", templateName); } else { text = string.Format("({0}) {1}", typeName, templateName); } ReportsTemplateslist.Add(new { Value = templateID, Text = text }); } return(ReportsTemplateslist); }