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);
}
