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