public string GenerateDataScript()
{
DataGenType dtype = DataGenType.Insert;
if (rbDInsert.Checked)
dtype = DataGenType.Insert;
else if (rbDUpdate.Checked)
dtype = DataGenType.Update;
else if (rbDTruncate.Checked)
dtype = DataGenType.Truncate;
else if (rbDTruncateInsert.Checked)
dtype = DataGenType.TruncateInsert;
ScriptBusiness scriptBusiness = new ScriptBusiness();
var server = new EntityBusiness().GetServerList().Where(x=> x.ServerID == Convert.ToInt32(tscomserver.ComboBox.SelectedValue)).First();
string query = scriptBusiness.GenerateTableData(server, dtype, selectedtables);
return query;
}
public string GenerateStructureScript()
{
StructureType stype = StructureType.IfNotExists;
if(rbStIfNotExists.Checked)
stype = StructureType.IfNotExists;
else if (rbStDropnCreate.Checked)
stype = StructureType.DropAndCreate;
else if (rbStCreate.Checked)
stype = StructureType.Create;
ScriptBusiness scriptBusiness = new ScriptBusiness();
string query = scriptBusiness.GenerateTableStructure(AppTimeConfiguration.MainServer, stype, selectedtables);
return query;
}
