public Dictionary <Guid, string> GetDictionary(ECommonObjectType objectType)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode())
};
return(this.GetDictionary(StoredProcs.Dictionary, paramList));
}
public DateTime?LastModified(ECommonObjectType objectType, Guid id)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode()),
new SqlParameter("@Id", id)
};
return(this.ExecuteScalarDateTime(StoredProcs.LastModified, paramList));
}
public Guid CreatedBy(ECommonObjectType objectType, Guid id)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode()),
new SqlParameter("@Id", id)
};
return(this.ExecuteScalarGuid(StoredProcs.CreatedBy, paramList).Value);
}
public string Description(ECommonObjectType objectType, Guid id)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode()),
new SqlParameter("@Id", id)
};
return(this.ExecuteScalarString(StoredProcs.Description, paramList));
}
public Guid Id(ECommonObjectType objectType, string nameOrDisplay)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode()),
new SqlParameter("@NameOrDisplay", nameOrDisplay)
};
return(this.ExecuteScalarGuid(StoredProcs.Id, paramList).Value);
}
public bool IsValidId(ECommonObjectType objectType, Guid id)
{
List <SqlParameter> paramList = new List <SqlParameter>()
{
new SqlParameter("@ObjectTypeId", objectType.GetHashCode()),
new SqlParameter("@Id", id)
};
return(this.ExecuteScalar(StoredProcs.IsValidId, paramList) == 1);
}