public static List <Attribute> GetAttributes(string conn, int pClientID)
{
Builder.Data.ComponentBuilder cb = new Builder.Data.ComponentBuilder(conn);
DataTable dt = new DataTable();
dt = cb.GetAllAttributes();
List <Attribute> atts = new List <Attribute>();
for (int i = 0; i < dt.Rows.Count; i++)
{
// foreach (DataRow dr in dt.Rows) {
DataRow dr = dt.Rows[i];
Attribute a = new Attribute();
a.ClientID = 0;
a.ComponentID = dr[Builder.Schema.TalentozSchemaInfo.ComponentID.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.ComponentID.Name].ToString() : "";
a.ID = dr[Builder.Schema.TalentozSchemaInfo.FieldID.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.FieldID.Name].ToString() : "";
// a.ID = dr[Builder.Schema.TalentozSchemaInfo.ID.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.ID.Name].ToString() : "";
a.Name = dr[Builder.Schema.TalentozSchemaInfo.AttributeName.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.AttributeName.Name].ToString() : "";
a.DisplayName = dr[Builder.Schema.TalentozSchemaInfo.DisplayName.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.DisplayName.Name].ToString() : "";
a.IsRequired = dr[Builder.Schema.TalentozSchemaInfo.IsRequired.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsRequired.Name]) : false;
a.IsUnique = dr[Builder.Schema.TalentozSchemaInfo.IsUnique.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsUnique.Name]) : false;
a.IsCore = dr[Builder.Schema.TalentozSchemaInfo.IsCore.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsCore.Name]) : false;
// a.Is = dr[Builder.Schema.TalentozSchemaInfo.IsReadOnly.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.IsReadOnly.Name].ToString() : "";
a.IsSecured = dr[Builder.Schema.TalentozSchemaInfo.IsSecured.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsSecured.Name]) : false;
a.IsNullable = dr[Builder.Schema.TalentozSchemaInfo.IsNullable.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsNullable.Name]) : false;
a.IsKey = dr[Builder.Schema.TalentozSchemaInfo.ISPrimaryKey.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.ISPrimaryKey.Name]) : false;
a.LookupInstanceID = dr[Builder.Schema.TalentozSchemaInfo.LookUpID.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.LookUpID.Name].ToString() : "";
a.Type = dr[Builder.Schema.TalentozSchemaInfo.AttributeType.Name] != null ? (AttributeType)dr[Builder.Schema.TalentozSchemaInfo.AttributeType.Name] : AttributeType._string;
a.Length = dr[Builder.Schema.TalentozSchemaInfo.Length.Name] != null?Convert.ToInt32(dr[Builder.Schema.TalentozSchemaInfo.Length.Name]) : 0;
a.DefaultValue = dr[Builder.Schema.TalentozSchemaInfo.DefaultValue.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.DefaultValue.Name].ToString() : "";
a.FileExtension = dr[Builder.Schema.TalentozSchemaInfo.FileExtension.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.FileExtension.Name].ToString() : "";
a.ComponentLookup = dr[Builder.Schema.TalentozSchemaInfo.LookupComponent.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.LookupComponent.Name].ToString() : "";
a.ComponentLookupDisplayField = dr[Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName.Name] != null ? dr[Builder.Schema.TalentozSchemaInfo.ComponentLookupDisplayName.Name].ToString() : "";
a.IsAuto = dr[Builder.Schema.TalentozSchemaInfo.IsAuto.Name] != null?Convert.ToBoolean(dr[Builder.Schema.TalentozSchemaInfo.IsAuto.Name]) : false;
atts.Add(a);
}
return(atts);
}
