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