public ZNxtUserRDBService(IRDBService rdBService, IUserNotifierService userNotifierService, ILogger logger, IApiGatewayService apiGatewayService, ITenantSetterService tenantSetterService, IInMemoryCacheService inMemoryCacheService) : base( userNotifierService, logger, apiGatewayService, tenantSetterService ) { _rdBService = rdBService; _inMemoryCacheService = inMemoryCacheService; }
public static string GetInsertSQLWithParam(this IRDBService dbService, JObject data, string table) { StringBuilder sb = new StringBuilder(); sb.Append($"INSERT INTO {table}"); var columns = new List <string>(); var values = new List <string>(); foreach (var item in data) { columns.Add(item.Key); if (item.Value.Type == JTokenType.Integer || item.Value.Type == JTokenType.Boolean) { values.Add(item.Value.ToString().ToLower()); } else { values.Add($"'{item.Value.ToString()}'"); } } sb.Append($"([{string.Join("],[", columns) }])"); sb.Append($" values ({string.Join(",", values) })"); return(sb.ToString()); }
public ZNxtUserServiceBaseUnitTest() { Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=identity;"); _rDBService = new SqlRDBService(new HttpProxyMock()); _zNxtUserService = new ZNxtUserRDBService(_rDBService, new MockUserNotifierService(), new MockLogger(), new MockApiGatewayService(), new MockTenantSetterService(), new MockinMemoryCacheService()); }
public PingController(IHttpContextProxy httpContextProxy, IDBService dBService, IRDBService rDBService, ILogger logger, IResponseBuilder responseBuilder) : base(httpContextProxy, dBService, logger, responseBuilder) { _logger = logger; _responseBuilder = responseBuilder; }
public ClientController(IResponseBuilder responseBuilder, ILogger logger, IHttpContextProxy httpContextProxy, IDBService dBService, IRDBService rDBService, IZNxtUserService zNxtUserService) : base(httpContextProxy, dBService, logger, responseBuilder) { _responseBuilder = responseBuilder; _httpContextProxy = httpContextProxy; _logger = logger; _rDBService = rDBService; _zNxtUserService = zNxtUserService; }
public IdentityCURD() { Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=identity;"); _rDBService = new SqlRDBService(new HttpProxyMock()); }
public GetDataUnitTest() { Environment.SetEnvironmentVariable("MSSQLConnectionString", "Server=.\\SQLEXPRESS;Database=TEST;Trusted_Connection=True;"); _rDBService = new SqlRDBService(new HttpProxyMock()); }
public InsertDataPGDBUnitTest() { Environment.SetEnvironmentVariable("NPGSQLConnectionString", "Host=103.212.120.XXX;Username=root;Password=root;Database=mvp_tenant_mgt"); _rDBService = new SqlRDBService(new HttpProxyMock()); }