/// <summary>
/// Determines whether or not the provided extension is present in any of the categories registered in this class.
/// </summary>
/// <returns><c>true</c> if the extension is unknown; otherwise, <c>false</c>.</returns>
/// <param name="extension">Extension.</param>
public static bool IsExtensionUnknown(string extension)
{
return(ModelTypeExtensions.Contains(extension) ||
TextureTypeExtensions.Contains(extension) ||
AudioTypeExtensions.Contains(extension) ||
DataTypeExtensions.Contains(extension) ||
TerrainTypeExtensions.Contains(extension));
}
public static bool IsDataTypeIgnoringUserStartNodes(this IDataTypeService dataTypeService, Guid key)
{
if (DataTypeExtensions.IsBuildInDataType(key))
{
return(false); //built in ones can never be ignoring start nodes
}
var dataType = dataTypeService.GetDataType(key);
if (dataType != null && dataType.Configuration is IIgnoreUserStartNodesConfig ignoreStartNodesConfig)
{
return(ignoreStartNodesConfig.IgnoreUserStartNodes);
}
return(false);
}
public static bool IsDataTypeIgnoringUserStartNodes(this IDataTypeService dataTypeService, Guid key)
{
if (DataTypeExtensions.IsBuildInDataType(key))
{
return(false); //built in ones can never be ignoring start nodes
}
var dataType = dataTypeService.GetDataTypeDefinitionById(key);
if (dataType != null)
{
var preValues = dataTypeService.GetPreValuesCollectionByDataTypeId(dataType.Id);
if (preValues.FormatAsDictionary().TryGetValue(
Constants.DataTypes.ReservedPreValueKeys.IgnoreUserStartNodes, out var preValue))
{
return(preValue.Value.InvariantEquals("1"));
}
}
return(false);
}
public static string ReadSchema(string connectionstrings, bool includeViews, string type,
string procedureName = null, bool upper = false)
{
var sb = new StringBuilder();
if (type.Equals("Table"))
{
const string providername = "System.Data.SqlClient";
DatabaseSchema schema;
using (var dbReader = new DatabaseReader(connectionstrings, providername))
{
schema = dbReader.ReadAll();
}
var tablolar = schema.Tables;
foreach (var table in tablolar)
{
sb.AppendLine("\t[Table(" + "\"" + table.Name + "\"" + ")]");
sb.AppendLine("\tpublic partial class " + table.Name.ToLetterCase() + " { ");
var columns = table.Columns;
foreach (var colum in columns)
{
if (colum.IsPrimaryKey)
{
sb.AppendLine("\t\t[Key]");
}
sb.AppendLine("\t\t[Column(" + "\"" + colum.Name + "\"" + ")]");
sb.AppendLine("\t\t public virtual " +
DataTypeExtensions.GetNetString(colum.DataType.GetNetType().Name, colum.Nullable) +
" " + colum.Name.ToLetterCase() + " { get; set; } ");
}
sb.AppendLine("\t } ");
}
if (includeViews)
{
var views = schema.Views;
foreach (var view in views)
{
sb.AppendLine("\t[Table(" + "\"" + view.Name + "\"" + ")]");
sb.AppendLine("\tpublic partial class " + view.Name.ToLetterCase() + " { ");
var columns = view.Columns;
foreach (var colum in columns)
{
sb.AppendLine("\t\t[Column(" + "\"" + colum.Name + "\"" + ")]");
sb.AppendLine("\t\t public virtual " +
DataTypeExtensions.GetNetString(colum.DataType.GetNetType().Name,
colum.Nullable) +
" " + colum.Name.ToLetterCase() + " { get; set; } ");
}
sb.AppendLine("\t } ");
}
}
}
else if (type.Equals("Procedure"))
{
using (var db = new SqlConnection(connectionstrings))
{
using (var cmd = db.CreateCommand())
{
db.Open();
cmd.CommandText = "Helper_CreatePocoFromProcName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@procname",
DbType = DbType.String,
Value = procedureName
});
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
sb.AppendLine(reader.GetString(0));
}
reader.Close();
}
}
db.Close();
db.Dispose();
}
}
else if (type.Equals("Parameter"))
{
sb.AppendLine("var p = new DynamicParameters();");
using (var db = new SqlConnection(connectionstrings))
{
using (var cmd = db.CreateCommand())
{
db.Open();
cmd.CommandText = "Helper_CreateParameterFromProcedure";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@procedure",
DbType = DbType.String,
Value = procedureName
});
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
/*/*
* p.Add("@lang", lang, DbType.String);*/
var parameterName = reader["ParameterName"].ToString();
string cleanParameterName;
if (upper)
{
cleanParameterName = parameterName.Replace("@", "");
}
else
{
cleanParameterName = parameterName.Replace("@", "").ToLetterCase();
}
var parameterDataType = reader["ParameterDataType"].ToString().ToClrType().ToString();
sb.AppendLine("p.Add(\"" + parameterName + "\", item." + cleanParameterName + ", DbType." + parameterDataType + ");");
}
reader.Close();
}
}
db.Close();
db.Dispose();
}
}
return(sb.ToString());
}
public void InsertData(DataRow row, SQLiteConnection connection = null)
{
var insertStatement = $"INSERT INTO {_tableName}";
var columns = row.Table.Columns.Cast <DataColumn>().Select(col => $"[{col.ColumnName}]");
var columnString = string.Join(", ", columns);
var parameters = row.Table.Columns.Cast <DataColumn>()
.Select((col, index) => new Tuple <string, object>($"@param{index}", DataTypeExtensions.GetDynamicValue(col.DataType, row[col])));
var parametersString = string.Join(", ", parameters.Select(param => param.Item1));
var query = $"{insertStatement}({columnString}) VALUES ({parametersString})";
sqliteService.ExecuteQuery(query, connection, parameters);
}
