private async Task CreateUpdateStoredProcedure(DbUtilities dbConn) { List <DataAccessDef> accessDefs = await GetDataAccessDefinitions(); var dataTypes = accessDefs.Select(s => s.DataType).Where(s => s != "Index").ToList(); foreach (string dataType in dataTypes) { DataAccessDef accessDef = accessDefs.First(x => x.DataType == dataType); BuildUpdateProcedure(dbConn, dataType, accessDef); } RuleManagement rm = new RuleManagement(); string type = "Rules"; DataAccessDef ruleDef = rm.GetDataAccessDefinition(type); BuildUpdateProcedure(dbConn, type, ruleDef); type = "Functions"; DataAccessDef functionDef = rm.GetDataAccessDefinition(type); BuildUpdateProcedure(dbConn, type, functionDef); }
private async Task CreateGetStoredProcedure(DbUtilities dbConn) { RuleManagement rm = new RuleManagement(); string type = "Rules"; DataAccessDef ruleDef = rm.GetDataAccessDefinition(type); BuildGetProcedure(dbConn, type, ruleDef); BuildGetProcedureWithId(dbConn, type, ruleDef); type = "Functions"; DataAccessDef functionDef = rm.GetDataAccessDefinition(type); BuildGetProcedure(dbConn, type, functionDef); BuildGetProcedureWithId(dbConn, type, functionDef); IndexAccess ia = new IndexAccess(); type = "Index"; DataAccessDef indexDef = ia.GetDataAccessDefinition(); BuildGetProcedure(dbConn, type, indexDef); BuildGetProcedureWithQcString(dbConn, indexDef); }