private int DesativarTodosProdutosDoParceiro(int idParceiro) { int retorno = 0; DBManager dbManager = new DBManager(ConfigurationManager.AppSettings["ConnectionString"]); string strSQL = "UPDATE produto SET isAtivo=0, isDisponivel=0 WHERE idParceiro = " + idParceiro; try { dbManager.Open(); retorno = dbManager.ExecuteNonQuery(CommandType.Text, strSQL); } catch { } finally { dbManager.Close(); dbManager.Dispose(); } return retorno; }
public void GetTransactionTest() { DataProvider providerType = DataProvider.SqlServer; IDbTransaction actual; using (IDBManager manager = new DBManager(ConfigurationManager.AppSettings["ConnectionString"])) { manager.Open(); actual = DBManagerFactory.GetTransaction(providerType, manager.Connection); Assert.IsNotNull(actual); manager.Close(); } }
private object ExecuteScalar(string strSQL) { object retorno = 0; DBManager dbManager = new DBManager(ConfigurationManager.AppSettings["ConnectionString"]); try { dbManager.Open(); retorno = dbManager.ExecuteScalar(CommandType.Text, strSQL).ToString(); } catch { } finally { dbManager.Close(); dbManager.Dispose(); } return retorno; }