public static System.Data.DataTable createDataTable()
{
var dataTable = new System.Data.DataTable(Guid.NewGuid().ToString());
dataTable.AddColumn(System.Type.GetType("System.Int32"), "userId");
dataTable.AddColumn(System.Type.GetType("System.Int16"), "researchId");
dataTable.AddColumn(System.Type.GetType("System.Byte"), "isCompleted");
dataTable.AddColumn(System.Type.GetType("System.Int32"), "investedResearchpoints");
dataTable.AddColumn(System.Type.GetType("System.Int16"), "researchPriority");
return(dataTable);
}
public static System.Data.DataTable createDataTable()
{
var dataTable = new System.Data.DataTable(Guid.NewGuid().ToString());
DataColumn column;
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "id";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "userId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "name";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "energy";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "crew";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "scanRange";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "attack";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "defense";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "hitpoints";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "damageReduction";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "cargoroom";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int16");
column.ColumnName = "fuelroom";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "max_hyper";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "max_impuls";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "hyper";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Decimal");
column.ColumnName = "impuls";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Boolean");
column.ColumnName = "colonizer";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int64");
column.ColumnName = "population";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "shipHullsImage";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "hullId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "systemX";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "systemY";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "spaceX";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "spaceY";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "systemId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "templateId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Byte");
column.ColumnName = "refitCounter";
dataTable.Columns.Add(column);
dataTable.AddColumn(System.Type.GetType("System.Byte"), "noMovementCounter");
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "objectId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int64");
column.ColumnName = "versionId";
dataTable.Columns.Add(column);
column = new DataColumn();
column.DataType = System.Type.GetType("System.Int32");
column.ColumnName = "experience";
dataTable.Columns.Add(column);
return(dataTable);
}
private DataTable ParseFile(string FileName)
{
if (File.Exists(FileName))
{
string[] fileLines = File.ReadAllLines(FileName);
if (fileLines != null && fileLines.Length > 0)
{
DataTable dtFWRules = new DataTable();
dtFWRules.AddColumn<string>("Name");
dtFWRules.AddColumn<string>("Group");
dtFWRules.AddColumn<ProfileTypeEnum>("Profile");
dtFWRules.AddColumn<bool>("On");
dtFWRules.AddColumn<FirewallActionTypeEnum>("Allow");
dtFWRules.AddColumn<bool>("Override");
dtFWRules.AddColumn<string>("Program");
dtFWRules.AddColumn<string>("Local IP");
dtFWRules.AddColumn<string>("Remote IP");
dtFWRules.AddColumn<ProtocolTypeEnum>("Protocol");
dtFWRules.AddColumn<string>("Local Ports");
dtFWRules.AddColumn<string>("Remote Ports");
dtFWRules.AddColumn<string>("Allowed Users");
dtFWRules.AddColumn<string>("Allowed Computers");
for (int i = 1; i < fileLines.Length; i++)
{
string[] lineFields = fileLines[i].Split('\t');
DataRow dr = dtFWRules.NewRow();
dr[0] = lineFields[0];//Name
dr[1] = lineFields[1] ?? "";//Group
dr[2] = lineFields[2].ParseEnum<ProfileTypeEnum>();//Profile
dr[3] = lineFields[3].Matches("yes");//Enabled
dr[4] = lineFields[4].ParseEnum<FirewallActionTypeEnum>();//Allow
dr[5] = lineFields[5].Matches("yes");//Override
dr[6] = lineFields[6];//Program
dr[7] = lineFields[7];//Local Address
dr[8] = lineFields[8];//Remote Address
dr[9] = lineFields[9].ParseEnum<ProtocolTypeEnum>();////Protocol
dr[10] = lineFields[10];//Local Port
dr[11] = lineFields[11];//Remote Port
dr[12] = lineFields[12];//Allowed Users
dr[13] = lineFields[13];//Allowed Computers
dtFWRules.Rows.Add(dr);
}
return dtFWRules;
}
else
return null;
}
else
return null;
}
