/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idCategory", "description", "name", "idParentCategory" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Category");
if (!existsTable)
{
DataAccessConnection.CreateTable("Category", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idDeviceProfile", "deviceType", "deviceModel", "macAddress", "windowsMobileVersion", "idCustomer" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("DeviceProfile");
if (!existsTable)
{
DataAccessConnection.CreateTable("DeviceProfile", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idService", "name", "description", "webAccess", "relativePathAssembly", "pathAssemblyServer", "active", "global", "image", "website", "deployed", "updated", "idStore", "startDate", "stopDate" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(bool), typeof(bool), typeof(string), typeof(string), typeof(bool), typeof(bool), typeof(int), typeof(System.DateTime), typeof(System.DateTime) };
bool existsTable = DataAccessConnection.DBCheckedTable("Service");
if (!existsTable)
{
DataAccessConnection.CreateTable("Service", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idUserActionClientData", "actionType", "start", "stop", "idTable", "idRegister", "idComponent", "idService" };
Type[] fieldsType = new Type[] { typeof(int), typeof(int), typeof(System.DateTime), typeof(System.DateTime), typeof(int), typeof(int), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("UserActionClientData");
if (!existsTable)
{
DataAccessConnection.CreateTable("UserActionClientData", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idStore", "name", "telephoneNumber", "internalPhoneNumber", "contactName", "ownerName", "email", "webAddress", "localNumber" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string) };
bool existsTable = DataAccessConnection.DBCheckedTable("Store");
if (!existsTable)
{
DataAccessConnection.CreateTable("Store", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Function to check and create table and stored procedures for this class.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idCustomer", "name", "surname", "address", "phoneNumber", "userName", "password", "birthday", "howManyChildren", "gender", "civilState" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(System.DateTime), typeof(int), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Customer");
if (!existsTable)
{
DataAccessConnection.CreateTable("Customer", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idLastSync", "entityName", "lastTimestamp" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(System.DateTime) };
bool existsTable = DataAccessConnection.DBCheckedTable("LastSync");
if (!existsTable)
{
DataAccessConnection.CreateTable("LastSync", fieldsName, false, fieldsType);
}
dbChecked = true;
}
/// <summary>
/// Función que controla y crea la tabla y los procedimientos almacenados para esta clase.
/// </summary>
private static void DbChecked()
{
if (dbChecked)
{
return;
}
string[] fieldsName = new string[] { "idPreference", "active", "level", "idCustomer", "idCategory" };
Type[] fieldsType = new Type[] { typeof(int), typeof(bool), typeof(double), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Preference");
if (!existsTable)
{
DataAccessConnection.CreateTable("Preference", fieldsName, false, fieldsType);
}
dbChecked = true;
}