/// <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;
}