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