public StorageConnection GetConnection(bool skipInitiatedCheck = false) { if (!skipInitiatedCheck && !storageInitiated) { logger.Error("Cannot created connection to database: storage not initialized"); statusService.Post("Помилка: база даний не ініційована, продовження роботи неможливе"); } string fullDbFilePath = FilenameService.GetDBPath(); string connString = GetConnectionString(); StorageConnection connection = new StorageConnection(connString); if (connection != null && (connection.State == System.Data.ConnectionState.Connecting || connection.State == System.Data.ConnectionState.Open)) { return connection; } else { throw new Exception(string.Format("Database is not available with connection string {0}", connString)); } }
public async Task<bool> DeleteProductSubType(ProductSubTypeModel subType, StorageConnection connection = null) { bool result = false; try { using (var db = connection ?? dbManager.GetConnection()) using (var command = db.Connection.CreateCommand()) { command.CommandText = string.Format("DELETE FROM PRODUCTSUBTYPE WHERE Id = {0}", subType.Id); await command.ExecuteNonQueryAsync().ConfigureAwait(false); result = true; } } catch (Exception ex) { result = false; logger.Error("Exception during execution method \"DeleteProductSubType\": {0}", ex.Message); } return result; }