public string GetFieldNamespace(string aTable, string aField)
{
if (string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aTable) || string.IsNullOrEmpty(aField))
{
return(string.Empty);
}
string n = TableM4Fields.GetNamespace(aTable, aField);
if (!string.IsNullOrEmpty(n))
{
return(n);
}
string t = string.Empty;
int i = 0;
while (string.IsNullOrEmpty(n) & i < 10)
{
t = GetParentTableName(aTable);
if (string.IsNullOrEmpty(t))
{
return(string.Empty);
}
n = TableM4Fields.GetNamespace(t, aField);
i++;
}
return(n);
}
public bool FieldsInsert(string aTable, string aField, string aFieldNamespace)
{
return(string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aTable) || string.IsNullOrEmpty(aField) || string.IsNullOrEmpty(aFieldNamespace) ? false : TableM4Fields.Insert(aTable, aField, aFieldNamespace) >= 0);
}
// FIELDS
public bool IsFieldsEmpty()
{
return(string.IsNullOrEmpty(mDBName) ? true : TableM4Fields.IsEmpty());
}
public bool FieldsDelete()
{
return(string.IsNullOrEmpty(mDBName) ? false : TableM4Fields.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);
}