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());
}
public bool RecurciveForDataMappings(string tablename, string filepath, Dictionary <string, string> dicTmp)
{
try
{
TableMigration tm = new TableMigration();
ImportFromSourceFile isf = new ImportFromSourceFile();
List <String> tableNameList = new List <string>();
Dictionary <string, string> fieldMapping = new Dictionary <string, string>();
DataTable regardingOurTable = tm.getMyRegardingTable(tablename);
DataTable sourceTable = isf.importExlIntoDt(filepath, tablename);
if (sourceTable == null || sourceTable.Rows.Count <= 0)
{
return(true);
}
DataTable dtCombineSourceDataWithDataMapping = tm.BuildMyNewStructure(sourceTable, regardingOurTable);
fieldMapping = GetMappingResults(dtCombineSourceDataWithDataMapping);
string fieldsGroup = string.Empty;
dicTmp.TryGetValue(tablename, out fieldsGroup);
tableNameList = CommonHelper.instance.GetListFromTable(dtCombineSourceDataWithDataMapping, "DM_Fields_Table").Distinct().ToList();
insertIntoDB(dtCombineSourceDataWithDataMapping, sourceTable, regardingOurTable, tableNameList, fieldMapping);
}
catch (Exception ex)
{
return(false);
}
return(true);
}
