public static void MusicItemsTable(IdbMigration db)
{
var t = new TableMigration
{
HasIdentity = true,
TableName = xmConsts.MusicItems
};
t.Fields = new List <TableMigrationField>();
t.Fields.Add(new TableMigrationField {
FieldName = "Artist", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "FullFileName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "FileName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "Title", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "MachineName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
//t.Fields.Add(new TableMigrationField { FieldName = "ToUsb", FieldType = TableMigrationFieldType.Bit, IsNullAble = true });
//t.Fields.Add(new TableMigrationField { FieldName = "ToPlaylist", FieldType = TableMigrationFieldType.Bit, IsNullAble = true });
db.ExecurteCreateTable(t.ToString());
}
private static void InitGenericTables()
{
try
{
var subclassTypes = Assembly.GetAssembly(typeof(GenericData)).GetTypes().Where(t => t.IsSubclassOf(typeof(GenericData)));
var names = subclassTypes.Select(x => x.Name).ToList();
foreach (var genericItem in subclassTypes)
{
if (!_DBr.DbMigration.CheckTableExistence(genericItem.Name))
{
var t = new TableMigration
{
HasIdentity = true,
TableName = genericItem.Name
};
t.Fields = new List <TableMigrationField>();
t.Fields.Add(new TableMigrationField {
FieldName = "Description", FieldType = TableMigrationFieldType.NVarchar, FieldLLenght = 500, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "CreationDate", FieldType = TableMigrationFieldType.Date
});
t.Fields.Add(new TableMigrationField {
FieldName = "UpdateDate", FieldType = TableMigrationFieldType.Date
});
t.Fields.Add(new TableMigrationField {
FieldName = "Active", FieldType = TableMigrationFieldType.Bit
});
var properties = genericItem.GetProperties();
foreach (var propertyInfo in properties)
{
var genericDataField = ((GenericDataFieldAttribute[])propertyInfo.GetCustomAttributes(typeof(GenericDataFieldAttribute), true)).FirstOrDefault();
if (genericDataField.NotNull())
{
t.Fields.Add(new TableMigrationField
{
FieldName = genericDataField.FieldName,
FieldType = TableMigrationFieldType.NVarchar,
FieldLLenght = 500,
IsNullAble = true
});
}
}
_DBr.DbMigration.ExecurteCreateTable(t.ToString());
}
}
}
catch (Exception ex)
{
string exx = ex.Message;
}
}
public static void UserPlaylistsTable(IdbMigration db)
{
var t = new TableMigration
{
HasIdentity = true,
TableName = xmConsts.UserPlayList
};
t.Fields = new List <TableMigrationField>();
t.Fields.Add(new TableMigrationField {
FieldName = "UserId", FieldType = TableMigrationFieldType.Integer, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "ItemId", FieldType = TableMigrationFieldType.Integer, IsNullAble = true
});
db.ExecurteCreateTable(t.ToString());
}
public static void UsersTable(IdbMigration db)
{
var t = new TableMigration
{
HasIdentity = true,
TableName = xmConsts.Users
};
t.Fields = new List <TableMigrationField>();
t.Fields.Add(new TableMigrationField {
FieldName = "UserName", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "Password", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
db.ExecurteCreateTable(t.ToString());
}
//public static void T3(IDbMigration db)
//{
// //var t = new TableMigration
// //{
// // HasIdentity = true,
// // TableName = "testmigration3"
// //};
// //t.Fields = new List<TableMigrationField>();
// //t.Fields.Add(new TableMigrationField { FieldName = "col1", FieldType = TableMigrationFieldType.Integer, IsNullAble = false });
// //t.Fields.Add(new TableMigrationField { FieldName = "col2", FieldType = TableMigrationFieldType.Decimal, IsNullAble = true });
// //t.Fields.Add(new TableMigrationField { FieldName = "col3", FieldType = TableMigrationFieldType.Date, IsNullAble = true });
// //t.Fields.Add(new TableMigrationField { FieldName = "col4", FieldType = TableMigrationFieldType.Text, IsNullAble = true });
// //t.Fields.Add(new TableMigrationField { FieldName = "col5", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 500, IsNullAble = true });
// //db.ExecurteCreateTable(t.ToString());
//}
public static void MigrationTable(IdbMigration db)
{
var t = new TableMigration
{
HasIdentity = true,
TableName = "migItems"
};
t.Fields = new List <TableMigrationField>();
t.Fields.Add(new TableMigrationField {
FieldName = "Name", FieldType = TableMigrationFieldType.Varchar, FieldLLenght = 5000, IsNullAble = true
});
t.Fields.Add(new TableMigrationField {
FieldName = "Date", FieldType = TableMigrationFieldType.Date, IsNullAble = true
});
db.ExecurteCreateTable(t.ToString());
}