using (SqlCommand oCommand1 = new SqlCommand("delete from paiem", oConnSql.Connection, transac))
    {
    try
    {
        oCommand1.ExecuteNonQuery();
    }
    catch (SqlException ex)
    {
        transac.Rollback();
        oConnSql.Connection.Close();
        oConnSql.Connection.Dispose();
        Api.Zstoperror("", oCommand1, ex);
        return;
    }
}