public void Visit(CParameter parameter)
{
_codeWriter.Write($"{parameter.Type} {parameter.ParameterName}");
if (!string.IsNullOrEmpty(parameter.DefaultValue))
{
_codeWriter.Write($" = {parameter.DefaultValue}");
}
}
public void AppendParameter(string strTitle, string strName, string strType,
string strDirect, string AppearMode,
bool bReadOnly, string strDefault, string strDescription,
List <CParamSubItem> lstSubItem)
{
CParameter param = new CParameter(strTitle, strName, strType, strDirect, AppearMode,
bReadOnly, strDefault, strDescription, lstSubItem);
lstParams.Add(param);
}
static void Main(string[] args)
{
CParameter <int> ints = new CParameter <int>();
CParameter <long> longs = new CParameter <long>();
CInformation info = new CInformation();
info.AddParameter(ints);
info.AddParameter(longs);
CParameter <int> ints2 = info.GetParameter <int>();
}
static void Main(string[] args)
{
CParameter <int> ints = new CParameter <int>();
CParameter <long> longs = new CParameter <long>();
CInformation info = new CInformation();
info.AddParameter(ints);
info.AddParameter(longs);
CParameter <int> ints2 = info.GetParameter <int>();
// ints2 and ints will both refer to the same CParameter instance.
}
public List <String> getParamNames()
{
List <String> aparams = new List <String>();
for (int i = 0; i < parametros.Count; i++)
{
CParameter cparameter = (CParameter)parametros[i];
aparams.Add(cparameter.parametro.Trim());
}
return(aparams);
}
public fFileManage()
{
InitializeComponent();
finalTable = new DataTable();
parameter = new CParameter();
parameter.FilePath = @"Config.xml";
dbfFile = new string[200];
this.tbDate.Text = DateTime.Today.ToShortDateString().Replace("/","");
GetPath(this.tbDate.Text.ToString());
this.logBox.Items.Clear();
TableInit(finalTable);
}
public List <String> getValue(String s)
{
for (int i = 0; i < parametros.Count; i++)
{
CParameter cparameter = (CParameter)parametros[i];
if (cparameter.parametro.Trim().Equals(s.Trim()))
{
return(cparameter.Valor);
}
}
return(null);
}
private CParameter FindParameter(String parameter)
{
CParameter findParameter = null;
for (int i = 0; i < parametros.Count; i++)
{
CParameter cparameter = (CParameter)parametros[i];
if (cparameter.parametro.Trim().Equals(parameter))
{
findParameter = cparameter;
}
}
return(findParameter);
}
private bool CheckValue(CParameter cParameter, String value)
{
bool checkValue = false;
IEnumerator values = cParameter.Valor.GetEnumerator();
while (values.MoveNext())
{
String svalue = (String)values.Current;
if (svalue.Trim().Equals(value.Trim(), StringComparison.InvariantCultureIgnoreCase))
{
checkValue = true;
}
}
return(checkValue);
}
public void VisitCParameter(CParameter parameter)
{
_parameterVisitor.Visit(parameter);
}
public fDBConfig()
{
InitializeComponent();
parameter = new CParameter();
parameter.FilePath = @"Config.xml";
}
public void AddParameter <T>(CParameter <T> parameter)
{
this.parameters.Add(parameter);
}
private List <CMethod> GetDataServiceMethodsFromQueries()
{
var methods = new List <CMethod>();
foreach (var kQuery in _dataStoreKProject.Query)
{
if (kQuery.GeneratedQuery == null)
{
//todo: shouldn't have any null
continue;
}
var query = kQuery.GeneratedQuery;
CClass dtoParameterClass = null; // GetParameterDto(query, query.ParameterSetName);
CClass dtoResultClass = null; //GetResultDto(query, query.ResultSetName);
var method = new CMethod
{
AccessModifier = CAccessModifier.Public,
IsAsync = true,
ReturnType = query.HasResultSet
? $"Task<IEnumerable<{dtoResultClass.ClassName}>>"
: "Task<bool>",
MethodName = $"{query.QueryName}Async",
//DerivedFrom = query
};
if (dtoParameterClass != null)
{
var methodParameter = new CParameter
{
Type = dtoParameterClass.ClassName,
ParameterName = dtoParameterClass.ClassName.ToLower() //.ParameterNameCamelCase
};
method.Parameter.Add(methodParameter);
}
else
{
foreach (var parameter in query.Parameter)
{
var type = "object";
if (!parameter.ParameterTypeIsUserDefined)
{
type = SqlMapper.ParseValueAsSqlDbType(parameter.ParameterTypeRaw).ToClrTypeName();
if (parameter.IsCollection)
{
type = $"IEnumerable<{type}>";
}
}
else if (parameter.ParameterTypeIsUserDefined)
{
var parameterType = parameter.ParameterTypeRaw;
if (parameterType.StartsWith("tt"))
{
parameterType = parameterType.Substring(2, parameterType.Length - 2);
}
var tableDto = FindTableByParameterTypeRaw(parameterType);
type = GetTableDto(_tables, tableDto, tableDto.TableName).ClassName;
type = $"IEnumerable<{type}>";
/*
* var tableType = FindTableType(parameter.ParameterTypeRaw);
*
* type = GetTableTypeDto(tableType.GeneratedTableType, tableType.TableTypeName).ClassName;
* type = $"IEnumerable<{type}>";
*/
}
var methodParameter = new CParameter
{
Type = type,
ParameterName = parameter.ParameterNameCamelCase
};
method.Parameter.Add(methodParameter);
}
}
var codeWriter = new CodeWriter();
codeWriter.WriteLine($@"using var connection = DbProvider.GetConnection();");
codeWriter.WriteLine("");
codeWriter.WriteLine("var sqlParams = new DynamicParameters();");
if (dtoParameterClass != null)
{
foreach (var property in dtoParameterClass.Property)
{
var propertyName = property.PropertyName;
/*
* if (ConnectsToDatabaseType == DatabaseTypes.Postgres)
* propertyName = propertyName.ToSnakeCase();
*/
var dbType = SqlMapper.GetDbType(property.Type);
codeWriter.WriteLine(
$@"sqlParams.Add(""@{propertyName}"",{dtoParameterClass.ClassName.ToLower()}.{
property.PropertyName
}, DbType.{dbType});");
}
}
else
{
foreach (var parameter in query.Parameter)
{
var parameterName = parameter.ParameterName;
/*
* if (ConnectsToDatabaseType == DatabaseTypes.Postgres)
* parameterName = parameterName.ToSnakeCase();
*/
if (parameter.ParameterTypeIsUserDefined)
{
var tableType = FindTableType(parameter.ParameterTypeRaw);
var tableTypeClass = BuildTableTypeList(tableType);
codeWriter.WriteLine(
$@"sqlParams.Add(""@{parameterName}"",new {tableTypeClass.ClassName}({
parameter.ParameterNameCamelCase
}), DbType.Object);");
}
else
{
var dbType = parameter.ParameterType.ToClrType().ToDbType();
codeWriter.WriteLine(
$@"sqlParams.Add(""@{parameter.ParameterName}"",{
parameter.ParameterNameCamelCase
}, DbType.{dbType});");
}
}
}
codeWriter.WriteLine("");
if (query.HasResultSet)
{
var schemaName = query.Schema.SchemaName;
var queryName = query.QueryName;
var resultClassName = dtoResultClass.ClassName;
/*
* if (ConnectsToDatabaseType == DatabaseTypes.Postgres)
* {
* schemaName = schemaName.ToSnakeCase();
* queryName = queryName.ToSnakeCase();
* resultClassName = resultClassName.ToSnakeCase();
* }*/
codeWriter.WriteLine($@"var result = await connection");
codeWriter.WriteLine($@" .QueryAsync<{dtoResultClass.ClassName}>(");
codeWriter.WriteLine(
$@" ""{schemaName}.{queryName}"",");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.StoredProcedure)");
codeWriter.WriteLine($@" .ConfigureAwait(false);");
codeWriter.WriteLine("");
codeWriter.WriteLine($@"return result.ToList();");
}
else
{
codeWriter.WriteLine($@"var result = await connection");
codeWriter.WriteLine($@" .ExecuteAsync(");
codeWriter.WriteLine(
$@" ""{query.QueryName}"",");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.StoredProcedure)");
codeWriter.WriteLine($@" .ConfigureAwait(false);");
codeWriter.WriteLine("");
codeWriter.WriteLine($@"return result > 0;");
}
codeWriter.WriteLine(@"");
method.CodeSnippet = codeWriter.ToString();
methods.Add(method);
}
return(methods);
}
private List <CMethod> GetDataServiceMethodsFromStoredProcs()
{
var methods = new List <CMethod>();
foreach (var storedProcedure in _dataStoreKProject.StoredProcedure.Select(s => s.GeneratedStoredProcedure))
{
var dtoParameterClass = BuildParameterEntityClass(storedProcedure, storedProcedure.ParameterSetName);
var dtoResultClass = BuildResultEntityClass(storedProcedure, storedProcedure.ResultSetName, _dataLayerKProject);
var method = new CMethod
{
AccessModifier = CAccessModifier.Public,
IsAsync = true,
ReturnType = storedProcedure.HasResultSet
? $"Task<IEnumerable<{dtoResultClass.ClassName}>>"
: "Task<bool>",
MethodName = $"{storedProcedure.StoredProcedureName}Async",
DerivedFrom = storedProcedure
};
if (dtoParameterClass != null)
{
var methodParameter = new CParameter
{
Type = dtoParameterClass.ClassName,
ParameterName = dtoParameterClass.ClassName.ToLower() //.ParameterNameCamelCase
};
method.Parameter.Add(methodParameter);
}
else
{
foreach (var parameter in storedProcedure.Parameter)
{
var type = "object";
if (!parameter.ParameterTypeIsUserDefined)
{
type = SqlMapper.ParseValueAsSqlDbType(parameter.ParameterTypeRaw).ToClrTypeName();
if (parameter.IsCollection)
{
type = $"IEnumerable<{type}>";
}
}
else if (parameter.ParameterTypeIsUserDefined)
{
var parameterType = parameter.ParameterTypeRaw;
if (parameterType.StartsWith("tt"))
{
parameterType = parameterType.Substring(2, parameterType.Length - 2);
}
var tableDto = FindTableByParameterTypeRaw(parameterType);
type = GetTableDto(_tables, tableDto, tableDto.TableName).ClassName;
type = $"IEnumerable<{type}>";
/*
* var tableType = FindTableType(parameter.ParameterTypeRaw);
*
* type = GetTableTypeDto(tableType.GeneratedTableType, tableType.TableTypeName).ClassName;
* type = $"IEnumerable<{type}>";
*/
}
var methodParameter = new CParameter
{
Type = type,
ParameterName = parameter.ParameterNameCamelCase
};
method.Parameter.Add(methodParameter);
}
}
var codeWriter = new CodeWriter();
codeWriter.WriteLine($@"using var connection = DbProvider.GetConnection();");
codeWriter.WriteLine("");
codeWriter.WriteLine("var sqlParams = new DynamicParameters();");
if (dtoParameterClass != null)
{
foreach (var property in dtoParameterClass.Property)
{
var propertyName = property.PropertyName;
if (storedProcedure.ConvertToSnakeCase)
{
propertyName = propertyName.ToSnakeCase();
}
var dbType = SqlMapper.GetDbType(property.Type);
codeWriter.WriteLine(
$@"sqlParams.Add(""@{propertyName}"", {dtoParameterClass.ClassName.ToLower()}.{
property.PropertyName
}, DbType.{dbType});");
}
}
else
{
foreach (var parameter in storedProcedure.Parameter)
{
var parameterName = parameter.ParameterName;
if (storedProcedure.ConvertToSnakeCase)
{
parameterName = parameterName.ToSnakeCase();
}
if (parameter.ParameterTypeIsUserDefined)
{
var tableType = FindTableType(parameter.ParameterTypeRaw);
var tableTypeClass = BuildTableTypeList(tableType);
if (tableTypeClass != null)
{
codeWriter.WriteLine(
$@"sqlParams.Add(""@{parameterName}"", new {tableTypeClass.ClassName}({
parameter.ParameterNameCamelCase
}), DbType.Object);");
}
else
{
codeWriter.WriteLine("//todo");
}
}
else
{
var dbType = parameter.ParameterType.ToClrType().ToDbType();
codeWriter.WriteLine(
$@"sqlParams.Add(""@{parameterName}"", {
parameter.ParameterNameCamelCase
}, DbType.{dbType});");
}
}
}
codeWriter.WriteLine("");
var resultClassName = dtoResultClass.ClassName;
var storedProcName = storedProcedure.StoredProcedureName;
var storedProcNameOriginal = storedProcedure.StoredProcedureName;
var schemaName = storedProcedure.Schema.SchemaName;
if (storedProcedure.ConvertToSnakeCase)
{
resultClassName = resultClassName.ToSnakeCase();
storedProcName = storedProcName.ToSnakeCase();
schemaName = schemaName.ToSnakeCase();
}
if (storedProcedure.GenerateAsEmbeddedQuery)
{
codeWriter.WriteLine($@"var sqlQuery = Assembly.GetExecutingAssembly().GetEmbeddedQuery(""{storedProcNameOriginal}"");");
}
if (storedProcedure.HasResultSet)
{
codeWriter.WriteLine($@"var result = await connection");
codeWriter.WriteLine($@" .QueryAsync<{dtoResultClass.ClassName}>(");
if (storedProcedure.GenerateAsEmbeddedQuery)
{
codeWriter.WriteLine(
$@" sqlQuery,");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.Text)");
}
else
{
codeWriter.WriteLine(
$@" ""{schemaName}.{storedProcName}"",");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.StoredProcedure)");
}
codeWriter.WriteLine($@" .ConfigureAwait(false);");
codeWriter.WriteLine("");
codeWriter.WriteLine($@"return result.ToList();");
}
else
{
codeWriter.WriteLine($@"var result = await connection");
codeWriter.WriteLine($@" .ExecuteAsync(");
if (storedProcedure.GenerateAsEmbeddedQuery)
{
codeWriter.WriteLine(
$@" sqlQuery,");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.Text)");
}
else
{
codeWriter.WriteLine(
$@" ""{schemaName}.{storedProcName}"",");
codeWriter.WriteLine($@" sqlParams,");
codeWriter.WriteLine($@" commandType: CommandType.StoredProcedure)");
}
codeWriter.WriteLine($@" .ConfigureAwait(false);");
codeWriter.WriteLine("");
codeWriter.WriteLine($@"return result > 0;");
}
codeWriter.Write(@"");
method.CodeSnippet = codeWriter.ToString();
methods.Add(method);
}
return(methods);
}
public void AppendParameter(string strName, string strType, string strDefault, string strDescription)
{
CParameter param = new CParameter(strName, strType, strDefault, strDescription);
lstParams.Add(param);
}
Dictionary <String, Object> parseMulti(String s, Stream servletinputstream)
{
char c = '\u2000';
Dictionary <String, Object> hashtable = new Dictionary <String, Object>();
String s1 = "--" + s;
byte[] abyte0 = new byte[c];
int i = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (i == -1)
{
throw new Exception("InputStream truncated");
}
//String s2 = new String(abyte0, 0, 0, i);
String s2 = System.Text.Encoding.Default.GetString(abyte0, 0, i);
if (!s2.StartsWith(s1))
{
throw new Exception("MIME boundary missing: " + s2);
}
do
{
String s3;
String s6;
MemoryStream bytearrayoutputstream;
String s7;
String s8;
do
{
s7 = null;
s8 = null;
bytearrayoutputstream = new System.IO.MemoryStream();
//Object obj = null;
int j = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (j == -1)
{
return(hashtable);
}
//s3 = new String(abyte0, 0, 0, j - 2);
s3 = System.Text.Encoding.Default.GetString(abyte0, 0, j - 2);
s6 = s3.ToLower();
}while (!s6.StartsWith("content-disposition"));
int l = s6.IndexOf("content-disposition: ");
int i1 = s6.IndexOf(";");
if (l == -1 || i1 == -1)
{
throw new Exception("Content Disposition line misformatted: " + s3);
}
String s10 = s6.Substring(l + 21, i1 - 21 - l);
if (!s10.Equals("form-data"))
{
throw new Exception("Content Disposition of " + s10 + " is not supported");
}
int j1 = s6.IndexOf("name=\"", i1);
int k1 = s6.IndexOf("\"", j1 + 7);
if (j1 == -1 || k1 == -1)
{
throw new Exception("Content Disposition line misformatted: " + s3);
}
String s9 = s3.Substring(j1 + 6, k1 - 6 - j1);
int l1 = s6.IndexOf("filename=\"", k1 + 2);
int i2 = s6.IndexOf("\"", l1 + 10);
if (l1 != -1 && i2 != -1)
{
s7 = s3.Substring(l1 + 10, i2 - 10 - l1);
}
int k = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (k == -1)
{
return(hashtable);
}
//s3 = new String(abyte0, 0, 0, k - 2);
s3 = System.Text.Encoding.Default.GetString(abyte0, 0, k - 2);
s6 = s3.ToLower();
for (; sContentType == null; sContentType = s6)
{
;
}
if (s6.StartsWith("content-type"))
{
int j2 = s6.IndexOf(" ");
if (j2 == -1)
{
throw new Exception("Content-Type line misformatted: " + s3);
}
s8 = s6.Substring(j2 + 1);
k = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (k == -1)
{
return(hashtable);
}
//s3 = new String(abyte0, 0, 0, k - 2);
s3 = System.Text.Encoding.Default.GetString(abyte0, 0, k - 2);
if (s3.Length != 0)
{
throw new Exception("Unexpected line in MIMEpart header: " + s3);
}
}
else
{
if (s3.Length != 0)
{
throw new Exception("Misformatted line following disposition: " + s3);
}
}
bool flag = true;
bool flag1 = true;
byte[] abyte1 = new byte[c];
int k2 = 0;
k = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (k == -1)
{
return(hashtable);
}
//s3 = new String(abyte0, 0, 0, k);
s3 = System.Text.Encoding.Default.GetString(abyte0, 0, k);
CParameter cparameter = FindParameter(s9.Trim());
if (cparameter != null)
{
cparameter.Valor.Add(s3);
}
else
{
cparameter = new CParameter();
cparameter.parametro = s9.Trim();
cparameter.Valor.Add(s3);
}
if (!s3.StartsWith(s1))
{
Array.Copy(abyte0, 0, abyte1, 0, k);
k2 = k;
k = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (k == -1)
{
return(hashtable);
}
//String s4 = new String(abyte0, 0, 0, k);
String s4 = System.Text.Encoding.Default.GetString(abyte0, 0, k);
flag1 = false;
if (s4.StartsWith(s1))
{
flag = false;
}
}
else
{
flag = false;
}
int line = 0;
do
{
if (!flag)
{
break;
}
bytearrayoutputstream.Write(abyte1, 0, k2);
Array.Copy(abyte0, 0, abyte1, 0, k);
k2 = k;
k = readLine(abyte0, 0, abyte0.Length, servletinputstream);
if (k == -1)
{
return(hashtable);
}
//String s5 = new String(abyte0, 0, 0, k);
String s5 = System.Text.Encoding.Default.GetString(abyte0, 0, k);
if (s5.StartsWith(s1))
{
flag = false;
}
line++;
}while (true);
//if(!flag1 && k2 > 2)
if (!flag1 && (k2 > 2 || line > 0))
{
bytearrayoutputstream.Write(abyte1, 0, k2 - 2);
if (!CheckValue(cparameter, bytearrayoutputstream.ToString()))
{
//cparameter.Valor[0]=new String(bytearrayoutputstream.ToString());
cparameter.Valor[0] = System.Text.Encoding.Default.GetString(bytearrayoutputstream.ToArray());
}
}
if (s7 == null)
{
if (hashtable[s9] == null)
{
String[] @as = new String[1];
@as[0] = bytearrayoutputstream.ToString();
hashtable.Add(s9, @as);
}
else
{
Object obj1 = hashtable[s9];
if (obj1 is String[])
{
String[] as1 = (String[])obj1;
String[] as2 = new String[as1.Length + 1];
Array.Copy(as1, 0, as2, 0, as1.Length);
as2[as1.Length] = bytearrayoutputstream.ToString();
hashtable.Add(s9, as2);
}
else
{
throw new Exception("failure in parseMulti hashtable building code");
}
}
}
else
{
Dictionary <String, Object> hashtable1 = new Dictionary <String, Object>(4);
hashtable1.Add("name", s9);
hashtable1.Add(FILENAME, s7);
if (s8 == null)
{
s8 = "application/octet-stream";
}
hashtable1.Add("content-type", s8);
hashtable1.Add(CONTENT, bytearrayoutputstream.ToArray());
hashtable.Add(s9, hashtable1);
}
if (FindParameter(cparameter.parametro.Trim()) == null)
{
parametros.Add(cparameter);
}
}while (true);
}
