private void GenerateJSON()
{
//Get options
bool asArray = (Options.Controls.Find("JsonAsArray", true)[0] as CheckBox).Checked;
bool includeNull = (Options.Controls.Find("IncludeNull", true)[0] as CheckBox).Checked;
DialogResult SaveResult = DialogResult.OK;
string baseJsonStr = "\"+\": -";
string JsonLine = "{_}" + (asArray ? "," : "");
string tmp;
if (!Preview)
{
Save.Filter = "Json files (*.json)|*.json";
Save.Title = "Guardar archivo JSON";
//Nombre del archivo por defecto.
Save.FileName = "GEN_X.json";
SaveResult = Save.ShowDialog();
Writer = SaveResult == DialogResult.OK ? new StreamWriter(Save.OpenFile()) : null;
}
Result = (asArray ? "[" : "");
for (int i = 0; i < Lines; i++)
{
tmp = "";
for (int j = 0; j < Fields.Count; j++)
{
FieldPanel p = Fields.ElementAt(j);
var str = p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "\"", DefaultNullValue);
if (includeNull || str != DefaultNullValue)
{
tmp += (asArray ? identation : "") +
baseJsonStr.Replace("+", p.FieldName).Replace("-", str + ",") +
(asArray && j + 1 != Fields.Count ? nl : "");
}
}
tmp = !tmp.Equals(string.Empty) || !asArray ? (asArray ? nl : "") + tmp.TrimEnd(',') + (!asArray ? "" : nl) : nl;
if (!Preview && SaveResult == DialogResult.OK && Save.FileName != "")
{
string line = (asArray && i == 0 ? "[" : "") + JsonLine.Replace("_", tmp);
if (asArray && i + 1 == Lines)
{
//Elimiar ultima coma del array
line = line.TrimEnd(',') + (asArray ? "]" : "");
}
Writer.WriteLine(line);
}
else
{
Result += JsonLine.Replace("_", tmp) + (!asArray ? nl : "");
}
}
if (Preview)
{
Result = Result.TrimEnd(',') + (asArray ? "]" : "");
PreviewForm PreviewFrm = new PreviewForm(Result);
PreviewFrm.ShowDialog();
}
}
private void GenerateSQL()
{
string SQLLine = "INSERT INTO __ (+) VALUES (-)";
string createTableStr = "";
string tableName = (Options.Controls.Find("TableName", true)[0] as TextBox).Text;
string columns = "";
string values = "";
string valuesChanged = "";
if (!Preview)
{
Save.Filter = "SQL Script|*.sql";
Save.Title = "Guardar script SQL";
//Nombre del archivo por defecto.
Save.FileName = tableName == "" ? "GEN_X.sql" : tableName + ".sql";
}
//Añadir el create table
if ((Options.Controls.Find("CreateTableCkBx", true)[0] as CheckBox).Checked)
{
createTableStr = $"CREATE TABLE {tableName} ({nl}";
Fields.ForEach(f =>
{
if (f.FieldType.BName == EBFieldType.Number)
{
int dec = (f.OptionsPanel.Options as OptionsNumberType).Dec;
f.FieldType.ColumnType = dec == 0 ? "INT" : $"DECIMAL(5, {dec})";
}
createTableStr += '\t' + $"{f.TBFieldName.Text} {f.FieldType.ColumnType},{nl}";
});
createTableStr += ");" + nl;
}
for (var i = 0; i <= Fields.Count - 1; i++)
{
columns += (i != 0 ? " " : "") + $"{{{i}}},";
values += (i != 0 ? " " : "") + $"{{{i}}},";
}
//Remover la ultima coma.
columns = columns.TrimEnd(',');
values = values.TrimEnd(',');
//Tomar los nombres de las columnas
columns = string.Format(columns, Fields.ConvertAll(p => p.FieldName).ToArray());
//Insertar Nombre de fila
SQLLine = SQLLine.Replace("+", columns);
SQLLine = SQLLine.Replace("__", tableName);
//valuesArr.AddRange(Fields.ConvertAll(p => p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "\'", DefaultNullValue)).ToArray());
if (!Preview && Save.ShowDialog() == DialogResult.OK && Save.FileName != "")
{
Writer = new StreamWriter(Save.OpenFile());
Writer.Write(createTableStr);
for (int i = 0; i < Lines; i++)
{
var str = Fields.ConvertAll(p => p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "\'", DefaultNullValue)).ToArray();
valuesChanged = string.Format(values, str);
Writer.WriteLine($"{SQLLine.Replace("-", valuesChanged)}");
}
Writer.Dispose();
Writer.Close();
}
else
{
for (int i = 0; i < Lines; i++)
{
var str = Fields.ConvertAll(p => p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "\'", DefaultNullValue)).ToArray();
//Sustituir {i} por sus correspondientes valores
valuesChanged = string.Format(values, str);
Result += $"{SQLLine.Replace("-", valuesChanged)}{nl}";
}
}
Result = createTableStr + Result;
if (Preview)
{
PreviewForm PreviewFrm = new PreviewForm(Result);
PreviewFrm.ShowDialog();
}
}
private void GenerateCSVTSV()
{
//Get options
bool includeHeader = (Options.Controls.Find("IncludeHeader", true)[0] as CheckBox).Checked;
string outputExt = OutputFormat.ToString();
DialogResult SaveResult = DialogResult.OK;
string delimiter = OutputFormat == EOutputFormat.CSV ? "," : "\t";
string columns = "";
string values = "";
string valuesLine = "";
if (!Preview)
{
Save.Filter = $"Archivo {OutputFormat}(*.{outputExt.ToLower()})|*.{outputExt.ToLower()}";
Save.Title = $"Guardar archivo {OutputFormat}";
//Nombre del archivo por defecto.
Save.FileName = $"GEN_X.{outputExt.ToLower()}";
SaveResult = Save.ShowDialog();
Writer = SaveResult == DialogResult.OK ? new StreamWriter(Save.OpenFile()) : null;
}
for (int i = 0; i < Fields.Count; i++)
{
string fName = Fields.ElementAt(i).FieldName;
if (fName.Contains('"'))
{
fName = fName.Replace("\"", "\"\"");
fName = !fName.Contains(",") ? '"' + fName + '"' : fName;
}
if (delimiter == ",")
{
if (fName.Contains(","))
{
fName = '"' + fName + '"';
}
}
columns += (i != 0 ? delimiter : "") + fName;
values += (i != 0 ? delimiter : "") + "{" + i + "}";
}
if (!Preview && SaveResult == DialogResult.OK && Save.FileName != "")
{
if (includeHeader)
{
Writer.WriteLine(columns);
}
for (int i = 0; i < Lines; i++)
{
var str = Fields.ConvertAll(p => p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "", DefaultNullValue)).ToArray();
valuesLine = string.Format(values, str);
Writer.WriteLine(valuesLine);
}
Writer.Dispose();
Writer.Close();
}
else
{
if (includeHeader)
{
Result += columns + nl;
}
for (int i = 0; i < Lines; i++)
{
var str = Fields.ConvertAll(p => p.OptionsPanel.Options.Generate(fkr, Convert.ToInt32(Lines), "", DefaultNullValue)).ToArray();
valuesLine = string.Format(values, str);
Result += valuesLine + nl;
}
PreviewForm PreviewFrm = new PreviewForm(Result);
PreviewFrm.ShowDialog();
}
}
