private List <XFilter> ViewFilters_Get(Guid viewId) { List <XFilter> values = new List <XFilter>(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT VF.[Id], VF.[PropertyId], IsNull(P.[DisplayValue], P.[Name]) AS [Property],"); sql.AppendLine("VF.[OperatorId], O.[Operator], VF.[Value], VF.[Order]"); sql.AppendLine("FROM [ViewFilters] VF WITH (NoLock)"); sql.AppendLine("INNER JOIN [Properties] P WITH (NoLock) ON P.[Id] = VF.[PropertyId]"); sql.AppendLine("INNER JOIN [Operators] O WITH (NoLock) ON O.[Id] = VF.[OperatorId]"); sql.AppendLine("WHERE VF.[ViewId] = @ViewId"); sql.AppendLine("ORDER BY VF.[Order]"); List <SqlParameter> paramList = new List <SqlParameter> { new SqlParameter("@ViewId", viewId) }; using (SqlDataReader rdr = base.OpenDataReaderInLine(sql.ToString(), paramList)) { if ((rdr != null) && (rdr.HasRows)) { while (rdr.Read()) { Guid id = rdr.GetGuid(0); Guid propertyId = rdr.GetGuid(1); string property = rdr.GetString(2); int operatorId = rdr.GetInt32(3); string op = rdr.GetString(4); string value = rdr.GetString(5); int order = rdr.GetInt32(6); XFilter filter = new XFilter(id, propertyId, property, EnumerationOps.EFilterOperatorFromValue(operatorId), op, value, order); values.Add(filter); } } } return(values); }
public List <XObjectRelation> AssetRelationList_GetByFromAssetId(Guid fromassetid) { List <XObjectRelation> list = new List <XObjectRelation>(); List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@Id", fromassetid)); using (SqlDataReader drdSql = base.OpenDataReader(spAssetAssetRelationList_GetByFromAssetId, paramList)) { if ((drdSql != null) && (drdSql.HasRows)) { //get the index of each property we are going to load int Id = drdSql.GetOrdinal("Id"); int FromAssetId = drdSql.GetOrdinal("FromAssetId"); int ToAssetId = drdSql.GetOrdinal("ToAssetId"); int AssetRelationTypeId = drdSql.GetOrdinal("AssetRelationTypeId"); int Created = drdSql.GetOrdinal("Created"); int Approved = drdSql.GetOrdinal("Approved"); int CreatedBy = drdSql.GetOrdinal("CreatedBy"); int ApprovedBy = drdSql.GetOrdinal("ApprovedBy"); int DeletedBy = drdSql.GetOrdinal("DeletedBy"); while (drdSql.Read()) { XObjectRelation relation = new XObjectRelation(); if (!drdSql.IsDBNull(Id)) { relation.Id = drdSql.GetGuid(Id); } if (!drdSql.IsDBNull(FromAssetId)) { relation.FromAssetId = drdSql.GetGuid(FromAssetId); } if (!drdSql.IsDBNull(ToAssetId)) { relation.ToAssetId = drdSql.GetGuid(ToAssetId); } if (!drdSql.IsDBNull(AssetRelationTypeId)) { relation.AssetRelationType = EnumerationOps.EAssetRelationTypeFromValue((Int16)drdSql.GetByte(AssetRelationTypeId)); } if (!drdSql.IsDBNull(Created)) { relation.Created = (DateTime)drdSql.GetValue(Created); } if (!drdSql.IsDBNull(Approved)) { relation.Approved = (DateTime)drdSql.GetValue(Approved); } if (!drdSql.IsDBNull(CreatedBy)) { relation.CreatedBy = drdSql.GetGuid(CreatedBy); } if (!drdSql.IsDBNull(ApprovedBy)) { relation.ApprovedBy = drdSql.GetGuid(ApprovedBy); } if (!drdSql.IsDBNull(DeletedBy)) { relation.DeletedBy = drdSql.GetGuid(DeletedBy); } relation.IsNew = false; relation.IsDirty = false; list.Add(relation); } } } return(list); }
public XObjectRelation Get(Guid Id) { XObjectRelation relation = null; List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@Id", Id)); using (SqlDataReader rdr = base.OpenDataReader(spAssetAssetRelation_Get, paramList)) { if ((rdr == null) || (!rdr.HasRows)) { return(null); } relation = new XObjectRelation(); rdr.Read(); if (!rdr.IsDBNull(rdr.GetOrdinal("FromAssetId"))) { relation.FromAssetId = rdr.GetGuid(rdr.GetOrdinal("FromAssetId")); } if (!rdr.IsDBNull(rdr.GetOrdinal("ToAssetId"))) { relation.ToAssetId = rdr.GetGuid(rdr.GetOrdinal("ToAssetId")); } if (!rdr.IsDBNull(rdr.GetOrdinal("AssetRelationTypeId"))) { relation.AssetRelationType = EnumerationOps.EAssetRelationTypeFromValue((Int16)rdr.GetByte(rdr.GetOrdinal("AssetRelationTypeId"))); } if (!rdr.IsDBNull(rdr.GetOrdinal("Created"))) { relation.Created = (DateTime)rdr[rdr.GetOrdinal("Created")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Approved"))) { relation.Approved = (DateTime)rdr[rdr.GetOrdinal("Approved")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedBy"))) { relation.CreatedBy = rdr.GetGuid(rdr.GetOrdinal("CreatedBy")); } if (!rdr.IsDBNull(rdr.GetOrdinal("ApprovedBy"))) { relation.ApprovedBy = rdr.GetGuid(rdr.GetOrdinal("ApprovedBy")); } if (!rdr.IsDBNull(rdr.GetOrdinal("DeletedBy"))) { relation.DeletedBy = rdr.GetGuid(rdr.GetOrdinal("DeletedBy")); } relation.Id = Id; relation.IsNew = false; relation.IsDirty = false; } return(relation); }
public XImage Get(Guid id, bool omitData) { XImage image = null; using ( SqlDataReader drdSql = base.OpenDataReader(StoredProcs.Image_Get, new List <SqlParameter> { new SqlParameter("@Id", id) })) { if ((drdSql != null) && (drdSql.HasRows)) { image = new XImage(); drdSql.Read(); if (!drdSql.IsDBNull(drdSql.GetOrdinal("ImageTypeId"))) { image.ImageType = EnumerationOps.EImageTypeFromValue((Int16)drdSql.GetByte(drdSql.GetOrdinal("ImageTypeId"))); } if (!drdSql.IsDBNull(drdSql.GetOrdinal("Order"))) { image.Order = (Int16)drdSql.GetByte(drdSql.GetOrdinal("Order")); } if (!drdSql.IsDBNull(drdSql.GetOrdinal("Name"))) { image.Name = drdSql.GetString(drdSql.GetOrdinal("Name")); } if (!drdSql.IsDBNull(drdSql.GetOrdinal("Description"))) { image.Description = (string)drdSql[drdSql.GetOrdinal("Description")]; } if (!omitData) { if (!drdSql.IsDBNull(drdSql.GetOrdinal("ImageData"))) { image.ImageData = (Byte[])drdSql[drdSql.GetOrdinal("ImageData")]; } } //if (!drdSql.IsDBNull(drdSql.GetOrdinal("Width"))) //{ // image.Width = drdSql.GetInt32(drdSql.GetOrdinal("Width")); //} //if (!drdSql.IsDBNull(drdSql.GetOrdinal("Height"))) //{ // image.Height = drdSql.GetInt32(drdSql.GetOrdinal("Height")); //} if (!drdSql.IsDBNull(drdSql.GetOrdinal("Created"))) { image.Created = (DateTime)drdSql[drdSql.GetOrdinal("Created")]; } if (!drdSql.IsDBNull(drdSql.GetOrdinal("Approved"))) { image.Approved = (DateTime)drdSql[drdSql.GetOrdinal("Approved")]; } if (!drdSql.IsDBNull(drdSql.GetOrdinal("CreatedBy"))) { image.CreatedBy = (Guid)drdSql[drdSql.GetOrdinal("CreatedBy")]; } if (!drdSql.IsDBNull(drdSql.GetOrdinal("ApprovedBy"))) { image.ApprovedBy = (Guid)drdSql[drdSql.GetOrdinal("ApprovedBy")]; } if (!drdSql.IsDBNull(drdSql.GetOrdinal("DeletedBy"))) { image.DeletedBy = (Guid)drdSql[drdSql.GetOrdinal("DeletedBy")]; } image.Id = id; image.IsNew = false; image.IsDirty = false; } } return(image); }
public XDocument Get(Guid id, bool omitData) { List <SqlParameter> paramList = new List <SqlParameter> { new SqlParameter("@Id", id) }; using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.Document_Get, paramList)) { if ((rdr == null) || (!rdr.HasRows)) { return(null); } if (!rdr.Read()) { return(null); } XDocument document = new XDocument(); if (!rdr.IsDBNull(rdr.GetOrdinal("DocumentTypeId"))) { document.DocumentType = EnumerationOps.EDocumentTypeFromValue(rdr.GetInt32(rdr.GetOrdinal("DocumentTypeId"))); } if (!rdr.IsDBNull(1)) { document.Name = rdr.GetString(1); } if (!rdr.IsDBNull(rdr.GetOrdinal("Title"))) { document.Title = (string)rdr[rdr.GetOrdinal("Title")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Description"))) { document.Description = (string)rdr[rdr.GetOrdinal("Description")]; } if (!omitData) { if (!rdr.IsDBNull(rdr.GetOrdinal("Data"))) { document.Data = (Byte[])rdr[rdr.GetOrdinal("Data")]; } } if (!rdr.IsDBNull(rdr.GetOrdinal("Created"))) { document.Created = (DateTime)rdr[rdr.GetOrdinal("Created")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("Approved"))) { document.Approved = (DateTime)rdr[rdr.GetOrdinal("Approved")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("CreatedBy"))) { document.CreatedBy = (Guid)rdr[rdr.GetOrdinal("CreatedBy")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("ApprovedBy"))) { document.ApprovedBy = (Guid)rdr[rdr.GetOrdinal("ApprovedBy")]; } if (!rdr.IsDBNull(rdr.GetOrdinal("DeletedBy"))) { document.DeletedBy = (Guid)rdr[rdr.GetOrdinal("DeletedBy")]; } document.Id = id; document.IsNew = false; document.IsDirty = false; return(document); } }
public IDictionary <Guid, IXProperty> GetObjectDictionary(IList <Guid> propertyIds) { string propIds = Helpers.ListOfGuidToCommaDelimString(propertyIds); IDictionary <Guid, IXProperty> values = new Dictionary <Guid, IXProperty>(); List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@PropertyIds", propIds)); using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.Properties_GetObjectDictionary, paramList)) { if ((rdr == null) || (!rdr.HasRows)) { return(values); } int Id = rdr.GetOrdinal("Id"); int Name = rdr.GetOrdinal("Name"); int DisplayValue = rdr.GetOrdinal("DisplayValue"); int Description = rdr.GetOrdinal("Description"); int DataTypeId = rdr.GetOrdinal("DataTypeId"); int IsSystem = rdr.GetOrdinal("IsSystem"); int SystemTypeId = rdr.GetOrdinal("SystemTypeId"); int Precision = rdr.GetOrdinal("Precision"); int PickListId = rdr.GetOrdinal("PickListId"); int RoleId = rdr.GetOrdinal("RoleId"); int IsOrdered = rdr.GetOrdinal("IsOrdered"); int AllowMultiValue = rdr.GetOrdinal("AllowMultiValue"); int Singular = rdr.GetOrdinal("Singular"); int Plural = rdr.GetOrdinal("Plural"); int AssetTypeId = rdr.GetOrdinal("AssetTypeId"); int AssetTypeIsInstance = rdr.GetOrdinal("AssetTypeIsInstance"); int Created = rdr.GetOrdinal("Created"); int CreatedBy = rdr.GetOrdinal("CreatedBy"); //int Approved = rdr.GetOrdinal("Approved"); //int ApprovedBy = rdr.GetOrdinal("ApprovedBy"); int LastModified = rdr.GetOrdinal("LastModified"); int LastModifiedBy = rdr.GetOrdinal("LastModifiedBy"); int Deleted = rdr.GetOrdinal("Deleted"); int DeletedBy = rdr.GetOrdinal("DeletedBy"); while (rdr.Read()) { XProperty property = new XProperty(); property.Id = rdr.GetGuid(Id); if (!rdr.IsDBNull(Name)) { property.Name = rdr.GetString(Name); } if (!rdr.IsDBNull(DisplayValue)) { property.DisplayValue = rdr.GetString(DisplayValue); } if (!rdr.IsDBNull(Description)) { property.Description = rdr.GetString(Description); } if (!rdr.IsDBNull(DataTypeId)) { property.DataType = EnumerationOps.EDataTypeFromValue((Int16)rdr.GetByte(DataTypeId)); } if (!rdr.IsDBNull(IsSystem)) { property.IsSystem = (bool)rdr[IsSystem]; } if (!rdr.IsDBNull(SystemTypeId)) { property.SystemType = EnumerationOps.ESystemTypeFromValue(rdr.GetInt32(SystemTypeId)); } if (!rdr.IsDBNull(Precision)) { property.Precision = (Int16)rdr[Precision]; } if (!rdr.IsDBNull(PickListId)) { property.XListId = rdr.GetGuid(PickListId); } if (!rdr.IsDBNull(RoleId)) { property.RoleId = rdr.GetGuid(RoleId); } if (!rdr.IsDBNull(IsOrdered)) { property.IsOrdered = (bool)rdr[IsOrdered]; } if (!rdr.IsDBNull(AllowMultiValue)) { property.AllowMultiValue = (bool)rdr[AllowMultiValue]; } if (!rdr.IsDBNull(Singular)) { property.Singular = rdr.GetString(Singular); } if (!rdr.IsDBNull(Plural)) { property.Plural = rdr.GetString(Plural); } if (!rdr.IsDBNull(AssetTypeId)) { property.XObjectTypeId = rdr.GetGuid(AssetTypeId); } if (!rdr.IsDBNull(AssetTypeIsInstance)) { property.AssetTypeIsInstance = (bool)rdr[AssetTypeIsInstance]; } property.Created = rdr.GetDateTime(Created); property.CreatedBy = rdr.GetGuid(CreatedBy); if (!rdr.IsDBNull(LastModified)) { property.LastModified = rdr.GetDateTime(LastModified); } if (!rdr.IsDBNull(LastModifiedBy)) { property.LastModifiedBy = rdr.GetGuid(LastModifiedBy); } if (!rdr.IsDBNull(Deleted)) { property.Deleted = rdr.GetDateTime(Deleted); } if (!rdr.IsDBNull(DeletedBy)) { property.DeletedBy = rdr.GetGuid(DeletedBy); } property.IsNew = false; property.IsDirty = false; values.Add(property.Id, property); } } return(values); }
public XProperty Get(Guid id) { XProperty property = null; List <SqlParameter> paramList = paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("@Id", id)); using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.Property_Get, paramList)) { if ((rdr == null) || (!rdr.HasRows)) { return(null); } int Name = rdr.GetOrdinal("Name"); int DisplayValue = rdr.GetOrdinal("DisplayValue"); int Description = rdr.GetOrdinal("Description"); int DataTypeId = rdr.GetOrdinal("DataTypeId"); int IsSystem = rdr.GetOrdinal("IsSystem"); int SystemTypeId = rdr.GetOrdinal("SystemTypeId"); int Precision = rdr.GetOrdinal("Precision"); int PickListId = rdr.GetOrdinal("PickListId"); int RoleId = rdr.GetOrdinal("RoleId"); int IsOrdered = rdr.GetOrdinal("IsOrdered"); int AllowMultiValue = rdr.GetOrdinal("AllowMultiValue"); int Singular = rdr.GetOrdinal("Singular"); int Plural = rdr.GetOrdinal("Plural"); int AssetTypeId = rdr.GetOrdinal("AssetTypeId"); int AssetTypeIsInstance = rdr.GetOrdinal("AssetTypeIsInstance"); int Created = rdr.GetOrdinal("Created"); int CreatedBy = rdr.GetOrdinal("CreatedBy"); //int Approved = rdr.GetOrdinal("Approved"); //int ApprovedBy = rdr.GetOrdinal("ApprovedBy"); int LastModified = rdr.GetOrdinal("LastModified"); int LastModifiedBy = rdr.GetOrdinal("LastModifiedBy"); int Deleted = rdr.GetOrdinal("Deleted"); int DeletedBy = rdr.GetOrdinal("DeletedBy"); property = new XProperty(); rdr.Read(); property.Id = id; if (!rdr.IsDBNull(Name)) { property.Name = rdr.GetString(Name); } if (!rdr.IsDBNull(DisplayValue)) { property.DisplayValue = rdr.GetString(DisplayValue); } if (!rdr.IsDBNull(Description)) { property.Description = rdr.GetString(Description); } if (!rdr.IsDBNull(DataTypeId)) { property.DataType = EnumerationOps.EDataTypeFromValue((Int16)rdr.GetByte(DataTypeId)); } if (!rdr.IsDBNull(IsSystem)) { property.IsSystem = (bool)rdr[IsSystem]; } if (!rdr.IsDBNull(SystemTypeId)) { property.SystemType = EnumerationOps.ESystemTypeFromValue(rdr.GetInt32(SystemTypeId)); } if (!rdr.IsDBNull(Precision)) { property.Precision = (Int16)rdr[Precision]; } if (!rdr.IsDBNull(PickListId)) { property.XListId = rdr.GetGuid(PickListId); } if (!rdr.IsDBNull(RoleId)) { property.RoleId = rdr.GetGuid(RoleId); } if (!rdr.IsDBNull(IsOrdered)) { property.IsOrdered = (bool)rdr[IsOrdered]; } if (!rdr.IsDBNull(AllowMultiValue)) { property.AllowMultiValue = (bool)rdr[AllowMultiValue]; } if (!rdr.IsDBNull(Singular)) { property.Singular = rdr.GetString(Singular); } if (!rdr.IsDBNull(Plural)) { property.Plural = rdr.GetString(Plural); } if (!rdr.IsDBNull(AssetTypeId)) { property.XObjectTypeId = rdr.GetGuid(AssetTypeId); } if (!rdr.IsDBNull(AssetTypeIsInstance)) { property.AssetTypeIsInstance = (bool)rdr[AssetTypeIsInstance]; } property.Created = rdr.GetDateTime(Created); property.CreatedBy = rdr.GetGuid(CreatedBy); if (!rdr.IsDBNull(LastModified)) { property.LastModified = rdr.GetDateTime(LastModified); } if (!rdr.IsDBNull(LastModifiedBy)) { property.LastModifiedBy = rdr.GetGuid(LastModifiedBy); } if (!rdr.IsDBNull(Deleted)) { property.Deleted = rdr.GetDateTime(Deleted); } if (!rdr.IsDBNull(DeletedBy)) { property.DeletedBy = rdr.GetGuid(DeletedBy); } property.IsNew = false; property.IsDirty = false; } return(property); }
public List <XRoleHelper> Roles_GetEditable(Guid userId) { List <XRoleHelper> values = new List <XRoleHelper>(); using (SqlDataReader rdr = base.OpenDataReader(StoredProcs.Roles_Get_Editable, new List <SqlParameter>() { new SqlParameter("@MemberId", userId) })) { if ((rdr != null) && (rdr.HasRows)) { while (rdr.Read()) { values.Add(new XRoleHelper(rdr.GetGuid(0), rdr.GetString(1), rdr.GetGuid(2), EnumerationOps.EAssetRequestTypeFromValue(Convert.ToInt32(rdr.GetValue(3))))); } } } return(values); }