/// <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[] { "idMall", "serverName", "mallName" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string) };
bool existsTable = DataAccessConnection.DBCheckedTable("Mall");
if (!existsTable)
{
DataAccessConnection.CreateTable("Mall", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteMall");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveMall");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateMall");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Mall", "idMall");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Mall", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Mall", "idMall", fieldsName, 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[] { "idCampaign", "description", "name", "startDate", "stopDate", "idUser" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(System.DateTime), typeof(System.DateTime), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Campaign");
if (!existsTable)
{
DataAccessConnection.CreateTable("Campaign", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteCampaign");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveCampaign");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateCampaign");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Campaign", "idCampaign");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Campaign", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Campaign", "idCampaign", fieldsName, 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[] { "idConnectionPoint", "connectionType", "xCoordinateRelativeToParent", "yCoordinateRelativeToParent", "idParentComponent", "idComponent", "idConnectionWidget" };
Type[] fieldsType = new Type[] { typeof(int), typeof(int), typeof(double), typeof(double), typeof(int), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("ConnectionPoint");
if (!existsTable)
{
DataAccessConnection.CreateTable("ConnectionPoint", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteConnectionPoint");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveConnectionPoint");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateConnectionPoint");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("ConnectionPoint", "idConnectionPoint");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("ConnectionPoint", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("ConnectionPoint", "idConnectionPoint", fieldsName, 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[] { "idRegisterAssociation", "idRegister", "idTable" };
Type[] fieldsType = new Type[] { typeof(int), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("RegisterAssociation");
if (!existsTable)
{
DataAccessConnection.CreateTable("RegisterAssociation", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteRegisterAssociation");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveRegisterAssociation");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateRegisterAssociation");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("RegisterAssociation", "idRegisterAssociation");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("RegisterAssociation", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("RegisterAssociation", "idRegisterAssociation", fieldsName, 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[] { "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, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteUserActionClientData");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveUserActionClientData");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateUserActionClientData");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("UserActionClientData", "idUserActionClientData");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("UserActionClientData", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("UserActionClientData", "idUserActionClientData", fieldsName, 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[] { "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, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteDeviceProfile");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveDeviceProfile");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateDeviceProfile");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("DeviceProfile", "idDeviceProfile");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("DeviceProfile", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("DeviceProfile", "idDeviceProfile", fieldsName, 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[] { "idStore", "name", "telephoneNumber", "internalPhoneNumber", "contactName", "ownerName", "email", "webAddress", "localNumber", "idMall", "idDataModel" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Store");
if (!existsTable)
{
DataAccessConnection.CreateTable("Store", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteStore");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveStore");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateStore");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Store", "idStore");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Store", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Store", "idStore", fieldsName, 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[] { "idPermission", "allowRead", "allowUpdate", "allowNew", "allowDelete", "businessClassName", "idGroup" };
Type[] fieldsType = new Type[] { typeof(int), typeof(bool), typeof(bool), typeof(bool), typeof(bool), typeof(string), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Permission");
if (!existsTable)
{
DataAccessConnection.CreateTable("Permission", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeletePermission");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SavePermission");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdatePermission");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Permission", "idPermission");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Permission", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Permission", "idPermission", fieldsName, 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[] { "idTable", "name", "isStorage", "idDataModel", "idComponent" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(bool), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("Table");
if (!existsTable)
{
DataAccessConnection.CreateTable("Table", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteTable");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveTable");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateTable");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Table", "idTable");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Table", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Table", "idTable", fieldsName, 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[] { "idUser", "userName", "password", "name", "surname", "phoneNumber", "isUserActive", "charge", "idStore" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(string), typeof(string), typeof(string), typeof(bool), typeof(string), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("User");
if (!existsTable)
{
DataAccessConnection.CreateTable("User", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteUser");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveUser");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateUser");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("User", "idUser");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("User", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("User", "idUser", fieldsName, 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[] { "idGroup", "name", "description", "isGroupActive" };
Type[] fieldsType = new Type[] { typeof(int), typeof(string), typeof(string), typeof(bool) };
bool existsTable = DataAccessConnection.DBCheckedTable("Group");
if (!existsTable)
{
DataAccessConnection.CreateTable("Group", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteGroup");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveGroup");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateGroup");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Group", "idGroup");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Group", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Group", "idGroup", fieldsName, 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[] { "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, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeletePreference");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SavePreference");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdatePreference");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("Preference", "idPreference");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("Preference", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("Preference", "idPreference", fieldsName, 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[] { "idConnectionWidget", "idTarget", "idSource", "idCustomerServiceData" };
Type[] fieldsType = new Type[] { typeof(int), typeof(int), typeof(int), typeof(int) };
bool existsTable = DataAccessConnection.DBCheckedTable("ConnectionWidget");
if (!existsTable)
{
DataAccessConnection.CreateTable("ConnectionWidget", fieldsName, true, fieldsType);
}
bool existsProcedureDelete = DataAccessConnection.DBCheckedStoredProcedure("DeleteConnectionWidget");
bool existsProcedureSave = DataAccessConnection.DBCheckedStoredProcedure("SaveConnectionWidget");
bool existsProcedureUpdate = DataAccessConnection.DBCheckedStoredProcedure("UpdateConnectionWidget");
if (!existsProcedureDelete)
{
DataAccessConnection.CreateDeleteStoredProcedure("ConnectionWidget", "idConnectionWidget");
}
if (!existsProcedureSave)
{
DataAccessConnection.CreateSaveStoredProcedure("ConnectionWidget", fieldsName, fieldsType);
}
if (!existsProcedureUpdate)
{
DataAccessConnection.CreateUpdateStoredProcedure("ConnectionWidget", "idConnectionWidget", fieldsName, fieldsType);
}
dbChecked = true;
}