public string GetJsonName(string aControlClass)
{
return(string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aControlClass) ? string.Empty : TableM4ControlsClasses.GetControlJsonName(aControlClass));
}
public bool ControlsClassesInsert(string aJsonName, string aControlClass)
{
return(string.IsNullOrEmpty(mDBName) || string.IsNullOrEmpty(aJsonName) || string.IsNullOrEmpty(aControlClass) ? false : TableM4ControlsClasses.Insert(aJsonName, aControlClass) >= 0);
}
// CONTROLS CLASSES
public bool IsControlsClassesEmpty()
{
return(string.IsNullOrEmpty(mDBName) ? true : TableM4ControlsClasses.IsEmpty());
}
public bool ControlsClassesDelete()
{
return(string.IsNullOrEmpty(mDBName) ? false : TableM4ControlsClasses.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);
}