public string GetParentTableName(string aTable)
{
return(string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aTable) ? string.Empty : TableM4Tables.GetParentTableName(aTable));
}
public bool TablesInsert(string aParentTable, string aTable)
{
return(string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aParentTable) || string.IsNullOrEmpty(aTable) ? false : TableM4Tables.Insert(aParentTable, aTable) >= 0);
}
// TABLES
public bool IsTablesEmpty()
{
return(string.IsNullOrEmpty(mDBName) ? true : TableM4Tables.IsEmpty());
}
public bool TablesDelete()
{
return(string.IsNullOrEmpty(mDBName) ? false : TableM4Tables.Delete() >= 0);
}
public static bool CreateDB(string dbName)
{
bool result = true;
SqlCommand myCommand;
SqlConnection myConn = new SqlConnection(string.Format("Server={0};Integrated security=True;database=master", System.Environment.MachineName));
if (!ExistDB())
{
string str;
str = string.Format("CREATE DATABASE {0}", dbName);
myCommand = new SqlCommand(str, myConn);
try
{
myConn.Open();
myCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message, "CREATE DATABASE");
}
finally
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
}
}
conn = new SqlConnection(Connection);
conn.Open();
if (!ExistDBTable("Fields"))
{
if (TableM4Fields.Create())
{
result = false;
}
}
if (!ExistDBTable("Tables"))
{
if (TableM4Tables.Create())
{
result = false;
}
}
if (!ExistDBTable("ControlsClasses"))
{
if (TableM4ControlsClasses.Create())
{
result = false;
}
}
if (!ExistDBTable("Controls"))
{
if (TableM4Controls.Create())
{
result = false;
}
}
if (!ExistDBTable("Label"))
{
if (TableM4Label.Create())
{
result = false;
}
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(result);
}